Gold Unit 11 – Database Software Create and modify non-relational database tables I can identify the components of a database design See database I can describe the field characteristics for the data required Name of field Data type If text – length required If number – type required. Decimal places needed? Reason for choice of Data Type Choice field – if yes, list the choices Would an ‘input mask’ help? (An input mask allows a layout, e. g. for national insurance numbers, post codes, phone fields.) Primary Key Yes / No Title Text 5 It is a text a only uses letters I only used 5 letters for a tittle because not many common titles have over 5 characters Yes An input mask would not help as a set layout would not work as each option is a different format e.g. different amounts of text. no Surname Text 25 It uses only letters and all surnames are under 25 characters long. No An input mask would not help as a set layout would not work as each option No
is a different format e.g. different amounts of text. Initial Text 1 It is a text a only uses letters I only used 1 letters for an initial because not many common titles have over 1 characters No An input mask would not help as a set layout would not work as each option is a different format. No Address 1 Text 40 It is a text a only uses letters I only used 40 letters for an address line 1 because not many common titles have over 40 characters No An input mask would not help as a set layout would not work as each option is a different format e.g. different amounts of text. No Address 2 Text 20 It is a text a only uses letters I only used 1 letters for an address line 2 because not many common No An input mask would not help as a set layout would not work as each option is a different format. No
titles have over 1 characters different amounts of text. Town Text 20 It uses only letters and all towns names are under 20 characters long. No An input mask would not help as a set layout would not work as each option is a different format e.g. different amounts of text. No Postcode Text 10 It uses only letters and numbers and this option is suitable for them both. All postcodes are under 10 characters long. Yes It would help as a postcode is always in the same layout so this would be suitable. No Home Phone Text 15 It uses only numbers and all home phone numbers are under 15 characters long. No An input may help but in the input mask mobile numbers you have the first bit in brackets and you do not write a mobile number in this format. No Mobile No Text 15 It uses only No It would Yes
numbers and all mobile phone numbers are under 15 characters long. work as it would be in the correct format but some are ex-directory and these would not be able to be inputted in to the filed. Phone Purchased Text 20 It uses only letters and all phone names are under 20 characters long. No An input mask would not help as a set layout would not work as each option is a different format e.g. different amounts of text. No Date of Purchase Date/Time Short date It is the best option for inputting dates. No The date text type already has an inbuilt input mask so one is not needed. No Price Plan Text 15 It uses only letters and all price plan names are under 15 characters long. Yes An input mask would not help as a set layout would not work as each option is a different format. No