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