• 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
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  • Level: GCSE
  • Subject: ICT
  • Word count: 3910

In this section I shall design my database. I will make a total of 5 tables. 1. Customer Details Table 2. Jobs Table 3. Products Table 4. Suppliers Table 5. Employees Table

Extracts from this document...

Introduction

In this section I shall design my database. I will make a total of 5 tables. 1. Customer Details Table 2. Jobs Table 3. Products Table 4. Suppliers Table 5. Employees Table From these tables I will be making all the outputs necessary such as queries reports and so on. The design of each table is described in its respective section. Tables: The method to create a table is the same for any table I will be creating. The only difference would be some properties in the table. After I open Access, I start by creating a new database. This can be done by choosing New from the File menu. I then choose 'Blank Database' so that I get a completely empty database. I give my database a name and choose create. From the list of options that appear in the form of a box, I choose 'create table in design view'. I can then enter the 'field names'. Field names should be a sensible name according to the data required. Then I must choose a 'data type' for that field, i.e. whether it will contain text, only numbers, a currency value, the date, etc. I may give a description to the field but it is not necessary. It is only to make the field easier to identify incase for example; changes need to be made in the future. Different fields will have different properties, which I can modify and set according to my need and liking. For example, for text fields, I can enter an 'input mask' which will form a standard set of data. This can only be applied to text fields and date fields. I will explain the different input masks as I create the tables. An example is a capital letter in all text fields. This makes them more organized and neat. When reports are printed, all similar fields will have data presented in the same way, regardless of how the user keyed in the data. ...read more.

Middle

Name of the supplier ContactName Text 20 Timmy Name of representative from company Emirate Text 20 Dubai Emirate where the company is situated Phone Text 9 042533653 Company's phone number Fax Text 9 042533654 Company's fax number Email Text 50 order@skyelec.co.ae Company's e-mail address Notes Memo - Additional notes or comments Below are the validation rules I will use. Field Name Validation Rule Validation Text SupplierID Is Not Null And Like "#" Or "##" Or "###" Supplier ID cannot be left blank and/or must contain a 1-3 digit number The different input masks I will use are shown in the table below. Field Name Input Mask Description SupplierName >L<??????????????????? The first letter of the name of the company will be a capital letter ContactName >L<??????????????????? The first letter of the name of the representative will be a capital letter Phone !(99) 0000000;;_ Area code will be in brackets, followed by a space then the 7 digit number Fax !(99) 0000000;;_ Area code will be in brackets, followed by a space then the 7 digit number Employee Table: The last table that I will create will be the Employee Table. This will contain information on the employees in CITY CROWN COMPUTER Computers. The different fields and their description is given in the table below. Field Name Type Length Example Description EmployeeID Number Long Integer 22 Key field giving Employee ID number FirstName Text 20 Johnson First Name of employee LastName Text 20 Junior Last Name of employee Sex Text 7 Male Sex of the employee Nationality Text 20 Syrian Nationality of employee Designation Text 20 Dubai Designation of employee Salary Currency - AED 2500 Salary of employee PassportNo Text 10 L104235693 Employee's passport number Phone Text 9 042211222 Telephone number of employee Mobile Text 10 0507999645 Mobile number of employee Comments Memo - In charge of repairs Comments on employee Picture OLE Object - johnson_junior.jpg Recent picture of employee The validation rules I will use are shown below Field Name Validation Rule Validation Text EmployeeID ...read more.

Conclusion

While creating a database for any application, it is necessary to always test the data. In the database, I have used some validation rules. However, before I can implement on my system, I will have to make sure that all the validation rules work perfectly fine. This is where the task of the test plan comes in. While creating a test plan, I will prepare certain sets of data that I will assign to each validation rules used. Some data might be correct, whereas for some data I will deliberately introduce certain errors to check if the computer detects them. Serial No Table Name Field Name Validation Rule Data Input Expected Result 1 Customer Details CustomerID Is Not Null - Error 2 Customer Details POBox Like "#" or "##" or "###" or "####" or "#####" 143960 Error 3 Customer Details Type Like "Upgrade" Or "Repair" Or "Purchase" Update Error 4 Customer Details Sex Like "Male" Or "Female" Male Accepted 5 Employees EmployeeID Is Not Null And Like "#" Or "##" Or "###" 1402 Error 6 Products ProductID Is Not Null And Like "#" Or "##" Or "###" 143 Accepted 7 Employees Sex Like "Male" Or "Female" F Error The input masks are also an important form of validation because they prevent incorrect formats of data, such as the length of the data or even the data type. Therefore, I will also be testing my input masks that I have used in several places. I will purposely enter incorrect data in some places to see if the computer recognizes the error. If the error is recognized, it means that the data is not suitable for the input mask used. Serial No Table Name Field Name Input Mask Data Input Expected Result 1 Customer Details CustomerID \C999;0;_ J123 Error 2 Jobs Date 00\->L<LL\-00;0;_ 26/12/01 Error - Month should be MMM 3 Products ProductID \P999;0;_ P540 Accepted 4 Suppliers Phone !(99) 0000000;;_ 042212422 Accepted 5 Employees Mobile !(999) 0000000;;_ 050645852 Error - Length of number 6 Employees PassportNo L\-00000000 C37985233 Accepted 7 Employees PassportNo L\-00000000 937985233 Error - Should start with alphabet ...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. Marked by a teacher

    Planning- design a memo, letter and webpage for Capital FM.

    4 star(s)

    We have a lot of different viewers who listen to our radio station. Everyday at 1.00pm we have a special show. This is where a member of our audience requests to run the radio show for an hour. They can choose their own music and have control over the microphone.

  2. I will design a new video database for the video shop that will also ...

    credit card system which I think will cost too much for the video shop. The video shop has a budget of �2.500 to spend on creating a new database system and a new computer so I have to be as cost effective as possible.

  1. Database Design Guideline

    Validation controls are given to create some rules for your assignment E.g. Validity check you can put minimum or maximum range. Validation rule gives you some rules witch you have to follow. The big advantage of using a validation rule is that there will be fewer changes of errors and

  2. Database design.

    the rows in this table is called a record, there is record for each employee, and the items in the columns are called fields. So we are able to say without any reservation that the above table is a record-structured relational database How a database will aid this system The

  1. Database &amp;amp; design.

    2.5 New films coming out on video a) Output ( On screen: Database of films to be released. b) Information to be output ( Title, date released, price, type of film, certificate. c) Data needed to produce the output ( A list of new film releases from the Internet or mailing from the companies that produce films.

  2. My task is to help Type a Flight travel agency to make their things ...

    Create a letterhead and design letter templates I can create a letterhead by hand but I will not because it doesn't look professional and it also time consuming. I can create a letterhead by notepad but I will not because it I cannot do some things, which are vital for me.

  1. Datalogging project. Objectives 1. Measure temperature 2.Measure light intensity 3. ...

    As the companies head person I want you to be able to log temperature and light intensity The finished work must include the attached User Requirements below. Your estimated time scale to finish this project is very short, as the company is losing valuable business time.

  2. Computer Systems Assignment 2

    Using Powerpoint as an example, it is better for a teacher to re-inforce a point rather than having to write it out on a whiteboard/blackboard.

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