"I have a group of GCSE English students who absolutely rave over your site and constantly tell me how useful they have found it to be. Trust me it has inspired them."
Design Section Gcse Ict Coursework Two Database Project AndrÉ Skepple-Garraway Candidate No.
- Words:
- 764
- Submitted:
- Thu Jul 11 2002

... Design Section - GCSE ICT Coursework Two - Database Project André Skepple-Garraway - Candidate No. 8218 1st April 2002 Form Designs Members Information Design and Field Definitions Table Field Name Data Type Field Size Validation Description Customer ID Text 7 Input mask: LL00\0900 Members chosen ID number Surname 20 -- Members Surname (Alphabetic order) Forename 50 Members Forename Telephone 13 Input mask: 0\ 20\-0000\-0000 Member's telephone number Gender 1 Input mask: L "M" or "F" Member's gender (M or F) Date Joined Date/Time -- Default value:=Date() Date Member joined. For a new member has today's date (=Date()) Date of Birth -- Member's Date of Birth Address Text 50 Member's address Post Code 8 Input mask: La09\ 0LL Member's post code Town 20 -- Member's town Borough Member's borough Video Information Design and Field Definitions Field Name Data Type Field Size Validation Description ID Number Text 12 Input mask: L\-000\-0000\-L Video's ID number given by the store for easy search and classification. Title 50 -- Video title to recognise the video by the staff and customers. Barcode 15 Input mask: "5 "000000\ 000000 The number recognised when the video is scanned in. Number created by manufacturers. VHS or DVD 3 Input mask: LLL To tell what format the video is to categorise by. Rating 2 -- The video's rating to restrict the purchase of video to people













