• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  • Level: GCSE
  • Subject: ICT
  • Word count: 3679

Planning my tables and the complete database for the new system.

Extracts from this document...

Introduction

In this section I will be planning my tables and the complete database for the new system. This will include my designs for queries, forms, sub-forms, linked-forms, relationships and macros. Once I have finished this I will be using a test plan to make sure that my system will work the way that I expect it to work. This test plan will ensure that my system is accurate and has accomplished many of the goals. TABLES I will create the tables in DESIGN mode as this will allow my to make more customised changes. In DESIGN mode I can enter the field name, the data type and any extra comments, which would not be possible in the WIZARD mode. Also, I can add validation rules and input masks in the field properties section. These are the tables I plan to create: ITEMS This table will hold the details of the item and its stock information. This is the record structure of this table: FIELD NAME DATA TYPE EXAMPLE ICODE NUMBER 10304 NAME TEXT WEGA T40 SCODE NUMBER 3100 SUPPLIER TEXT Sony ITEM TYPE TEXT TV PIC OLE Object (a picture file) PRESENT NUMBER 310 MIN LEVEL NUMBER 200 MAX LEVEL NUMBER 330 STATUS TEXT OK COST PRICE NUMBER Dhs. 500 SELL PRICE NUMBER Dhs. 725 To increase the level of integrity of the data entered, I will be using some simple validation rules to accompany the table. If any of these rules are violated, then an error message is displayed. The error message displays what is entered in VALIDATION TEXT. These are the validation rules and validation texts that I have inserted: FIELD NAME VALIDATION RULE VALIDATION TEXT NAME Is Not Null Please enter the item name PRESENT Is Not Null Enter present level MIN Is Not Null Enter minimum level MAX Is Not Null Enter maximum level SELL PRICE Is Not Null Enter selling price Sometimes data is required in a certain format. ...read more.

Middle

[Enter date] COLLECT, ID, LNAME, NAME, ITEMTYPE, TECHNICIAN, COST REP TECH N SUB TECHNICIAN = [Enter tech's name], SUBMIT = [Enter submission date] ID, LNAME, ICODE, NAME, SUPPLIER, ITEMTYPE, TECHNICIAN, SUBMIT REPANDY TECHNICIAN = "Andy" ID, LNAME, ICODE, SCODE, ITEMTYPE, TECHNICIAN, COLLECT, COST REPARVINDA TECHNICIAN = "Arvinda" ID, LNAME, ICODE, SCODE, ITEMTYPE, TECHNICIAN, COLLECT, COST REPBARRY TECHNICIAN = "Barry" ID, LNAME, ICODE, SCODE, ITEMTYPE, TECHNICIAN, COLLECT, COST REPICODE ICODE = [Enter ICODE] ID, FNAME, LNAME, ICODE, NAME, SCODE, SUPPLIER, TECHNICIAN, COST REPJOSE TECHNICIAN = "Jose" ID, LNAME, ICODE, SCODE, ITEMTYPE, TECHNICIAN, COLLECT, COST RESTOCK STATUS = "Restock" ICODE, NAME, SCODE, SUPPLIER, PRESENT, SELL PRICE, STATUS FORMS Forms are also important in my system. This will make the system more user friendly as I can customise the fields to be in different positions. This enables me to group specific fields together so that the database is easier to understand. The next few sheets will display my designs of my forms. I will create the forms using the WIZARD. Here I will choose the required fields, the type of view (columnar), the colour scheme and name of the form. After I make the form in the wizard I will tamper around with the design of the form in design mode. My forms will be in the COLUMNAR format as it looks more professional and user friendly. These are the designs of my forms: In the MAX field, I will insert the following code in the CODE BUILDER: Private Sub MAX_LostFocus() 'also MAX_onChange() and MAX_AfterUpdate() 01 Dim maxz 02 Dim minz 03 Dim pres 04 Dim subtr 05 Dim subtr2 06 Dim perc 07 maxz = MAX.Value 08 minz = MIN.Value 09 pres = PRESENT. Value 10 subtr = pres - minz 11 subtr2 = maxz - minz 12 perc = Int((subtr / subtr2) * 100) 13 If (perc <= 2) Then 14 MsgBox "WARNING! STOCK VERY LOW!!!" ...read more.

Conclusion

684 5841 ACCEPTED 40 TELEPHONE SUPPLIERS - REJECTED : Enter telephone number USER FEEDBACK Now my design plans are complete. Before I began my practical work, I decided to have the manager evaluate my progress, so that I would not make a mistake and regret it later. A few days later I went to the manager and asked his opinion after showing him all the designs that I proposed for the system. The manager said it was "well done" but one important thing was missing - the mail merge feature. Also, the manager wanted me to change the structure of the PURCHASE form so that it would look like a receipt with details. So then I started working on the problems. To send letters to the suppliers I need information from both the SUPPLIERS table and the ITEM PROPERTIES TABLE. At first I thought of making a table but after some time it struck me that I could create a query that would link the two tables together. So now I plan to create the query in the following way: QUERY NAME: MAILMERGE CRITERIA: (none) FIELDS SELECTED: ICODE, NAME, ITEM TYPE, MAX, STATUS, SUPPLIER (ITEMS table), SCODE, ADDRESS, STATE, COUNTRY, P/ZCODE, SUPPLIER (SUPPLIERS table). Then this will be my format for my standard letter: To: The manager, <<POBOX>> Dear Sir, Elektronikz has reached its stocking date and is now currently restocking all goods from various countries. In order to replenish our stock levels, we require the normal level (<<MAX>>) of <<NAME>> which is supplied by your company, hopefully reached to us latest by the 7th of April 2003. Please ensure that the goods delivered are in good condition and payment will be made on the 10th of April personally by the manager. Thank you, Mr. Nathan Fernandes, GENERAL MANAGER OF ELEKTRONIX Now that the mail merge has been handled, I will create the new design of the PURCHASE form. The following is my new planning, and as shown, it looks like a receipt: Now that my designs have completely been prepared, I will start implementing the new system. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. Database design.

    Number 3 >000< No Rent_Customer_ID Customer ID number Number 6 Foreign No Rent_Video_ID Video ID Number Number 4 Foreign >9999< No Rent_date_out Date Of Video Rented out Date __/__/__ No Rent_date_returned Date of video returned Date __/__/__ No Table Customer Entity Types Description Data type Length Key Validation Input Masks

  2. Camelot Restaurant Bookings System - computer system design

    other formulae like this one for between 13:00 and 15:00, 14:00 and 16:00, etc. There was a problem with this though and it was that there was not enough room on the screen to create more warnings, so I decided to scrap this idea, as it would cause too much inconvenience to recreate the whole sheet.

  1. Creating a computer system.

    > The user will click on a button to enter customer details. A form will appear and when the customer enters their details, they will be added in the invoice. > If the customer is a current customer, then they will enter their ID into the form and when they

  2. Create an IT system for my karate club.

    The linking table saves typing out the persons details again to say what competition and what there emergency phone number is, instead the end user can just pull up the information already found within the system. Possible Solutions For the database, which I am going, to be using there are two types, which I could use.

  1. Benefits of using my IT system in the Travel Agents.

    * Furthermore, you click on Gender. * Additionally, you click on Validation Rule and type in ("MALE" Or "FEMALE"). * Finally, click on Validation Text and type in (Enter "MALE" or "FEMALE" only please!). Creating Queries * First, you should go on Microsoft Access. * Then, you should go on Blank Database.

  2. Travel Agent Database - Effects of New System The new system will affect ...

    Storing documents in folders. The method of storing documents in folders is reasonably organised and quite systematic. Thousands of folders will have to be purchased to store thousands of documents. Using folders will take less space than using filing cabinets.

  1. Features of a sports club database. The system has at least 1 table and ...

    This layout has validation on some of the fields to prevent the user entering invalid data.(A4) This layout has 3 different types of data: Number, Text and Container A1 - Creating a new record and new data being entered A2 & A3 - Amending the data and deleting the

  2. Designing an IT system for an A level Student.

    Keyboard Used to input letters/words into the computer. John needs this for a variety of tasks. It is essential for most computers. Widescreen Monitor A visual display unit John can use this to view what it is that he is doing on the computer. Mouse Uses motion detection to move the cursor on the screen.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work