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)