From diagram to database: a small shop

Close the loop: read a diagram, choose tables, implement rules in DDL and insert checkable data. No new syntax: the challenge is connecting the ideas correctly.

Start with relationship meaning, map to keyed tables, then add constraints and data. Check schema, rows and valid/invalid cases together. A key identifies a row, FK links identities, and CHECK expresses a value rule.