Free SQL Database Design Learning Path
The relation workshop

GOAL
Design a small relational schema with keys and constraints, load fixtures and prove that invalid relationships are rejected.

START
Read workbook.html, inspect case-data.csv, complete the five stage outputs, then the capstone. Use evidence-log.csv to record only actions actually performed.

CASE
A fictional reading club needs members, events and registrations. One member may join many events; one event may have many members. A registration must refer to an existing member and event, and the same pair cannot be registered twice.

TOOLS
Basic SELECT queries and a local SQLite interpreter or Python 3 sqlite3 module. No hosted database is required.

LOCAL COMMANDS / OPENING
python check_schema.py

ASSESSMENT
Score at least 80/100, supply every required artifact, and satisfy the path-specific critical condition. Rework missing evidence before marking complete.
Critical condition: Foreign keys are enabled and invalid-insert evidence is retained; capacity enforcement is not falsely claimed.

SOURCE COURSES
CS50’s Introduction to Databases with SQL — https://wikifree.com/courses/harvard-cs50-sql/

RIGHTS AND SCOPE
Original WikiFree teaching case and exercises. All case data are synthetic. Provider lessons are linked, not redistributed. No certificate, real project delivery or unperformed runtime test is claimed.
