Data Modeling & Schema Design
You've worked through the fundamentals. These exercises give you a system to design from scratch — no hints about which concepts apply. Read the requirements and walk the evaluator through your schema.
Exercise 1: Gym Membership System
Check your understanding
A local gym wants to manage memberships and class bookings. **Requirements:** - Members can sign up and hold an active membership - The gym offers fitness classes, each taught by a single instructor - Classes have a scheduled time and a maximum capacity - Members can book classes and view their full booking history Walk me through how you'd design the schema for this system.
Exercise 2: Recipe Sharing App
Check your understanding
A cooking app lets users create and discover recipes. **Requirements:** - Users can create recipes with a title, description, and preparation steps - Each recipe contains multiple ingredients, each with a specific quantity and unit (e.g. 2 cups, 100g) - Users can save recipes to a personal collection - Each recipe is authored by one user Walk me through how you'd design the schema for this system.