ERD Exercise 1
Tables (4)
Component (Untitled2)
- Key (component number) — char(20) — Primary key — NOT NULL
- Field (explain) — char(30)
Producer (Untitled3)
- Key (producer number) — char(20) — Primary key — NOT NULL
- Field (name) — char(10)
- Field (address) — char(30)
- Field (phone number) — integer(11)
Product (Untitled)
- Key (product number) — char(20) — Primary key — NOT NULL
- Field (explain) — char(30)
- Field (price) — integer(10)
Workson (Untitled4)
- Key (component number) — char(20) — Foreign key → Component.Key — NOT NULL
- Key (product number) — char(20) — Foreign key → Product.Key — NOT NULL
- Field (hours) — float