Database Design – 2nd Edition II — Database Modeling, Normalization, and SQL

The second of two beginner courses adapted from Adrienne Watt and Nelson Eng’s Database Design – 2nd Edition, applying relationship mapping, anomaly analysis, normalization through 3NF, and foundational SQL.

3 sections · 7 lessons

Course outline

Modeling Relationships

  1. Map Relationships into Tables
  2. See the Anomalies
  3. Model Workshop Bookings

Normalization Logic

  1. Key-Based Dependency Checks
  2. Normalize Through Third Normal Form
  3. Repair the Enrollment Sheet

SQL Implementation

  1. Define a Schema with SQL
  2. Read and Change Rows
  3. Combine and Summarize Tables
  4. Implement the Booking Database

Start learning with Wondering