Edexcel IGCSEGeneralGeneral Applications5 Marks
A database stores information about students. One of the fields in the database is `StudentID`.
- (a)State the most appropriate data type for `StudentID`.[1]
- (b)Explain why `StudentID` should be the primary key.[2]
- (c)The database stores the names of students. Explain one reason why the database should store first names and last names in separate fields.[2]
Mark scheme
Marking points from the official mark scheme. The mark or mark type is shown in brackets.
- 9(a) String / Text (1) B1
- 9(b) Up to two of: B1 for each point.
- Each student has a unique `StudentID` (1)
- Used to identify each record uniquely (1)
- Cannot be null / empty (1)
- 9(c) Up to two of: B1 for reason, B1 for explanation.
- Allows for easier searching / sorting (by first or last name) (1) (Explanation: Can sort by last name, then first name for alphabetical lists) (1)
- Allows for easier filtering / querying (by first or last name) (1) (Explanation: Can find all students with a specific last name) (1)
- Allows for easier data manipulation / updating / editing (1) (Explanation: Can update first name without affecting last name) (1)
- Allows for mail merge / personalisation (1) (Explanation: Can address individuals by first name in communications) (1)
Write your answer and get it marked
On Oracle Prep you can write or photograph your own answer and have it marked by AI against this mark scheme, with feedback on what you missed.
Sign up free →