Paper 1 structured question: Design
Paper 1Theory6 marks
Description
File Structure Example
A student database includes fields such as Student ID, Name, Gender, and Age. The Gender field uses coding conventions where 'M' represents male and 'F' represents female.
| Field Name | Data Type | Field Length | Coding Convention |
|---|---|---|---|
| Student ID | Numeric | 6 | None |
| Name | Text | 30 | None |
| Gender | Text | 1 | M/F |
| Age | Numeric | 2 | None |
- a[2]
Define Define what is meant by a 'coding convention' in the context of the Gender field.
- b[4]
Explain Explain two validation checks that could be used for the Age field.