Computer Science (AS & A Level) · Oct / Nov 2022 · Paper 11 · Question 4

A photographer creates a relational database to store data about photographs taken at birthday parties. The database, PHOTOGRAPHS, stores details of the customer, the party, the photographs taken and the cameras used. The photographer has several cameras that are used for taking the photographs at the parties. Each camera has a specific lens type (for example, XY32Z) and lighting type (for example, F1672). Data about each photograph is stored in the database including the party at which it was taken, the time it was taken and the camera used. The database has these four tables: CUSTOMER(CustomerID, FirstName, LastName, Telephone) PARTY(PartyID, CustomerID, PartyDate, StartTime) PHOTO_DATA(PhotoID, PartyID, TimeTaken, CameraID) CAMERA_DATA(CameraID, LensType, LightingType)

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