Computer Science (AS & A Level) · May / June 2021 · Paper 12 · Question 1
9618
As printed in the paper
The question as text
Raj owns houses that other people rent from him. He has a database that stores details about the people who rent houses, and the houses they rent. The database, HOUSE_RENTALS, has the following structure: CUSTOMER(CustomerID, FirstName, LastName, DateOfBirth, Email) HOUSE(HouseID, HouseNumber, Road, Town, Bedrooms, Bathrooms) RENTAL(RentalID, CustomerID, HouseID, MonthlyCost, DepositPaid)
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
1(a)[6]
1(b)[2]
1(c)(i)[4]
1(c)(ii)[4]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.