Consider supporting us on Patreon. Help us keep revisedeck free.
8. Databases
A section of Computer Science, 9618
Listing 10 of 12 questions
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) Tick () one box in each row to identify whether each field is a primary key or a foreign key. Table Field name Primary key Foreign key MANAGER ManagerID SHOP ManagerID CAR RegistrationNumber CAR ShopID Describe the ways in which access rights can be used to protect the data in Javier’s database from unauthorised access. Javier uses Data Definition Language (DDL) and Data Manipulation Language (DML) statements in his database. Complete the following DML statements to return the number of cars for sale in each shop. SELECT COUNT( ) FROM ShopID Complete the DML statement to include the following car in the table CAR. Field Data RegistrationNumber 123AA Make Tiger Model Lioness NumberOfMiles ShopID 12BSTREET CAR ("123AA","Tiger","Lioness",10500,"12BSTREET")
9618_w21_qp_11
THEORY
2021
Paper 1, Variant 1
View
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) Tick () one box in each row to identify whether each field is a primary key or a foreign key. Table Field name Primary key Foreign key MANAGER ManagerID SHOP ManagerID CAR RegistrationNumber CAR ShopID Describe the ways in which access rights can be used to protect the data in Javier’s database from unauthorised access. Javier uses Data Definition Language (DDL) and Data Manipulation Language (DML) statements in his database. Complete the following DML statements to return the number of cars for sale in each shop. SELECT COUNT( ) FROM ShopID Complete the DML statement to include the following car in the table CAR. Field Data RegistrationNumber 123AA Make Tiger Model Lioness NumberOfMiles ShopID 12BSTREET CAR ("123AA","Tiger","Lioness",10500,"12BSTREET")
9618_w21_qp_13
THEORY
2021
Paper 1, Variant 3
View
Questions Discovered
12