Here are eight case studies in relational database design. Each case includes a complete explanation and illustrations of fields, tables, key fields, and relationships.
Case 1: MC Club Membership (2 tables)
Case 2: Social Security Contributions (3 tables)
Case 3: Breakfast Cereal Marketing Research (3 tables)
Case 4: Boat Rental Reservations (3 tables/4 tables)
Case 5: Mail Order Invoicing (4 tables)
Case 6: Magazine Subscriptions (4 tables)
Case 7: Clinics (4 tables)
Case 8 Part A: Adult Education Center (3 tables)
Case 8 Part B: Adult Education Center (5 tables)