A school has set up a database table SchoolTrip to record details of students that will go on a school trip. | StudentID | StudentName | ParentName | Permission | DateReceived | | :--- | :--- | :--- | :--- | :--- | | STU147 | Amir | Mr Akar | True | 03/03/2025 | | STU348 | Filip | Mrs Johnson | True | 04/03/2025 | | STU274 | Matthew | Mr Smith | False | | | STU873 | Jafar | Mr Al-Saigh | True | 21/03/2025 | | STU221 | Hussein | Mr Alkasab | True | 28/02/2025 | | STU553 | Julie | Mrs Jones | True | 25/02/2025 | | STU213 | Julie | Mr Smith | False | | (a) State the reason why ParentName is not appropriate as the primary key. \_\_\_\_ [1] (b) Give the name of the field that should be the primary key. \_\_\_\_ [1] (c) The database only uses these data types: - text - character - Boolean - integer - real - date/time. Complete the table to show the most appropriate data type for each field. Each data type must be different. | Field | Data type | | :--- | :--- | | ParentName | | | Permission | | | DateReceived | | [2] (d) Complete the structured query language (SQL) statement to display only the names of the students who do not have permission to go on the trip. SELECT \_\_\_\_ FROM \_\_\_\_ WHERE \_\_\_\_

2025 - O/N - 0478/21 | Q8

0/11

0 correct · 0 wrong

A school has set up a database table SchoolTrip to record...