ERD exercise 1(20200909)

Tables (4)

COMPONENT (Untitled2)

  • comNo (Key) — CHAR(10) — Primary key — NOT NULL
  • comExplanation (Field) — CHAR(50)
  • proSsn (Key2) — CHAR(8) — Foreign key → PRODUCER.ssn — NOT NULL

PRODUCER (Untitled4)

  • ssn (Key) — CHAR(8) — Primary key — NOT NULL
  • name (Field) — CHAR(10)
  • address (Field2) — CHAR(50)
  • phone (Field3) — CHAR(20)

PRODUCT (Untitled)

  • pNo (Key) — CHAR(10) — Primary key — NOT NULL
  • pExplanation (Field) — CHAR(50)
  • price (Field2) — int(8)

USEDIN (Untitled3)

  • pNo (Key) — CHAR(10) — Foreign key → PRODUCT.pNo — NOT NULL
  • comNo (Key2) — CHAR(10) — Foreign key → COMPONENT.comNo — NOT NULL
  • comQuantity (Field) — int(4)