25-Comp-B3 Data Bases and File Systems
Worked solutions to 5 past sittings (2013–2017), 40 questions. Pick a sitting, or start from a topic below.
Topics across the sittings
Topics that come up in more than one sitting, taken from the headings of our worked solutions. A topic counts once per sitting.
- ER diagram (3 sittings): December 2017 Q3 · December 2014 Q4 · December 2013 Q3
- Relational algebra (3 sittings): December 2017 Q6 · December 2014 Q6 · December 2013 Q6
- Functional dependencies (2 sittings): December 2014 Q7 · December 2013 Q7
- Toronto County Airport (2 sittings): December 2017 Q4 · December 2014 Q4
- Transactions (2 sittings): December 2014 Q8 · December 2013 Q8
Questions by sitting
December 2017
- Question 1
- Question 2
- Question 3: ER diagram — Downtown Records
- Question 4: ER diagram — Toronto County Airport
- Question 5: SQL — Employee/Manages/Department
- Question 6: Relational algebra — Bids/Auctions/Ratings
- Question 7
- Question 8
December 2015
May 2015
December 2014
- Question 1
- Question 2
- Question 3: ER model — bus company
- Question 4: ER diagram — Toronto County Airport
- Question 5: SQL — Doctor/Patient/Visit
- Question 6: SQL & relational algebra — Student/Course/Results
- Question 7: Functional dependencies — minimal cover, implication, decomposition
- Question 8: Transactions, ACID, and scheduling
December 2013
- Question 1
- Question 2
- Question 3: ER diagram — Downtown Vancouver Records
- Question 4: ER diagram — Toronto Downtown Airport
- Question 5: SQL queries — Suppliers/Parts/Catalog
- Question 6: Relational algebra — Passengers/Reservations/Flights
- Question 7: Functional dependencies and normalization
- Question 8: Transactions and serializability