ERD Exercise1_supply & assemble
Tables (4)
Untitled (SUPPLIER)
- Key (supplierNo) — VARCHAR2(10) — Primary key — NOT NULL
- Field (supplierName) — VARCHAR(3)
- Field (supplierAddress) — VARCHAR2(30)
- Field (supplierPhone) — VARCHAR2(10)
Untitled (PART)
- Key (partNo) — VARCHAR2(10) — Primary key — NOT NULL
- Field (description) — VARCHAR2(30)
- Key (supplierNo) — VARCHAR2(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (PRODUCT)
- Key (productNo) — VARCHAR2(10) — Primary key — NOT NULL
- Field (productName) — VARCHAR2(10)
- Field (describtion) — VARCHAR2(30)
- Field (price) — INTEGER
Untitled (ASSEMBLE)
- Key (assembleNo) — VARCHAR2(10) — Primary key — NOT NULL
- Key (productNo) — VARCHAR2(10) — Foreign key → Untitled.Key — NOT NULL
- Key (partNo) — VARCHAR2(10) — Foreign key → Untitled.Key — NOT NULL