Table 1 contains a small extract from a database used by a community theatre to allocate volunteer ushers. The database is being checked before the coordina...
Question 1 Report
Table 1 contains a small extract from a database used by a community theatre to allocate volunteer ushers. The database is being checked before the coordinator creates a report for the opening night. Each record is one volunteer. The ID field must remain unique so that two people with the same surname can still be identified correctly. The coordinator has saved the database and placed a screenshot of the query design in the document task.
| VolunteerID | Forename | Surname | Age | EveningAvailable |
|---|---|---|---|---|
| U041 | Mina | Patel | 17 | Yes |
| U042 | Lewis | Grant | 19 | No |
| U043 | Mina | Jones | 22 | Yes |
The coordinator needs evidence that the field selected as the primary key is suitable. They will use the information in Table 1 rather than changing the original table during task a2.
(a) Identify the field that should be used as the primary key. [1]
(b) Explain why this field is more suitable than Forename. [1]
Answer Details
(a) VolunteerID should be the primary key. [1]
(b) A primary key must uniquely identify one record. Every VolunteerID is unique, whereas a forename can be repeated: the table contains two volunteers called Mina. [1]
Download The App On Google Playstore
Everything you need to excel in your exams
