ERD case studies

Read a scenario, find the entities, and draw the relationships with the right cardinality and keys. Each case study has a model answer, and the lab grades your own diagram relationship by relationship.

• BeginnerCampus event ticketsThe student union sells tickets to its events and wants to replace its spreadsheet.4 entities · 3 relationships
• IntermediateCar rental branchesA regional car rental company with several branches needs to track its fleet and rentals.5 entities · 5 relationships
• StretchOnline course platformAn online learning platform needs to track instructors, courses, lessons and learner progress.5 entities · 4 relationships