Computer Science (AS & A Level) · Oct / Nov 2021 · Paper 13 · Question 5

Javier owns many shops that sell cars. He employs several managers who are each in charge of one or more shops. He uses the relational database CARS to store the data about his business. Part of the database is shown: SHOP(ShopID, ManagerID, Address, Town, TelephoneNumber) MANAGER(ManagerID, FirstName, LastName, DateOfBirth, Wage) CAR(RegistrationNumber, Make, Model, NumberOfMiles, ShopID)

Read automatically from the paper; the printed page above is exact.