Computer Science · May / June 2023 · Paper 2 SL · Question 1
Adapt for 2027Keys, relationships, SQL queries, views and DDL are all in A3.1-A3.3 (views are HL only); the validation-check part is extra but still answerable. Includes Higher Level only content, which Standard Level students do not study.
IBCS
As printed in the paper
The question as text
1. Quick Rent-a-Car is a popular car rental company in Chicago. The company stores information about the cars, customers and rental agreements. The diagram below shows a part of the entity-relationship diagram (ERD) for the Quick Rent-a-Car database. CUSTOMER CustID FName SName Phone … RENTAL RentalNum CustID DateOut DateRet CarID … CAR CarID Make Man Year CarSerialNum …
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
1(a)(i)[1]
1(a)(ii)[1]
1(a)(iii)[1]
1(b)[1]
1(c)[4]
1(d)[4]
1(e)[3]
1(f)[3]
1(g)[3]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.