May/June 2026 Paper 11

2026 · 7 questions · 29 parts · 75 marks

0/75 marks
0Correct0Partial0Wrong29Unattempted
Filters0 active

Questions

Select a part to jump to its question

Finish set
4(a)Relational Databases Data ModellingMedium4 marks
A shop allows customers to pay to borrow toys. The shop uses a database to record information about the customers and the toys they have borrowed.
pseudocode
CUSTOMER(CustomerID, ContactFirstName, Phone)TOY(ToyID, ToyName, CostPerDay)TOY_INSTANCE(UniqueToyID, ToyID, Quality)BORROW(BorrowID, CustomerID, UniqueToyID, StartDate, NumberDays)
Describe the relationship between each pair of tables. Include the primary key(s) and foreign key(s) and how these create each relationship.
CUSTOMER and BORROW
0 words
TOY_INSTANCE and TOY
0 words
4(b)Sql QueriesMedium4 marks
Write a Structured Query Language (SQL) script to return the total number of days of all toys borrowed by each customer. The customer ID and first name for each customer also need to be returned. The result needs to include a suitable field name for the total number of days.
SQL script
0 words
4(c)(i)Sql Data Definition ManipulationMedium2 marks
The table BORROW needs amending to include an additional field.
The field will store whether the toy has been returned and will store either Yes or No.
Write an SQL script to include the additional field in the table BORROW.
SQL script
0 words
4(c)(ii)Sql Data Definition ManipulationMedium3 marks
The toy that was borrowed with the borrow ID A2226 has been returned.
Write an SQL script to amend the record and store that the toy has been returned.
SQL script
0 words
4(d)(i)Data Validation VerificationMedium4 marks
When data is entered into the database it is validated and verified.
Explain how validation and verification support data integrity within a database.

Answer

0 words
4(d)(ii)Data Validation VerificationMedium1 mark
Give one reason why data may still be incorrect even after it passes validation and verification.