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 If text – Choice field – Would an Primary Name of field Data type Reason for length if yes, list the ‘input mask’ Key choice of Data required choices help? Type Yes / No (An input mask If number – allows a type set layout, e. g. required. for national Decimal insurance places numbers, post needed? codes, phone fields.) Title Text 5 It is a text Yes An input no a only uses mask would letters I not help as only used 5 a layout letters for a would not tittle work as because not each option many is a common different titles have format e.g. over 5 different characters amounts of text. Surname Text 25 It uses only No An input No letters and mask would all surnames not help as are under 25 a set layout characters would not long. work as each option
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