ERD Exercise 1
Tables (4)
assembly
- prodID — int(20) — Foreign key → product.prodID — NOT NULL
- makeID — int(20) — Foreign key → component.makeID — NOT NULL
component
- makeID — int(20) — Foreign key → producer.makeID — NOT NULL
- compName — string(30)
- compDescription — string(100)
producer
- makeID — int(20) — Primary key — NOT NULL
- makeName — string(30)
- makeAddress — string(50)
product
- prodID — int(20) — Primary key — NOT NULL
- prodName — string(30)
- prodDescription — string(100)
- prodPrice — int(20)