Design Section – Gcse Ict Coursework Two – Database Project AndrÉ Skepple-Garraway – Candidate No.

... 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

want to read more? →