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)