ERD Exercise 1
Tables (4)
PART (Untitled2)
- partNo (Key) — char(10) — Primary key — NOT NULL
- description (Field) — char(50)
- price (Field2) — char(10)
- supplierNo (Key2) — char(10) — Foreign key → SUPPLIER.supplierNo — NOT NULL
PART-_QUANTITY (Untitled4)
- partNo (Key2) — char(10) — Foreign key → PART.partNo — NOT NULL
- acount (Field2) — char(5)
PRODUCT (Untitled)
- productNo (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(20)
- description (Field2) — char(50)
- price (Field3) — char(10)
- partNo (Key22) — char(10) — Foreign key → PART-_QUANTITY.partNo — NOT NULL
SUPPLIER (Untitled3)
- supplierNo (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(20)
- phoneNo (Field3) — char(11)
- partNo (Key2) — char(10) — Foreign key → PART.partNo — NOT NULL