ERD Exercise1

Tables (7)

Producer (producer)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — char(10)
  • Field (PhoneNo) — int
  • Field (Company) — char(20)

Untitled (Product)

  • Key (id) — int — Primary key — NOT NULL
  • Field (description) — char(50)
  • Field (price) — int
  • Field (status) — char(10)
  • Field (ManufacturingDate) — date
  • Field (ValidityDate) — date
  • Key (CompanyNo) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (Part)

  • Key (id) — int — Primary key — NOT NULL
  • Field (description) — char(50)
  • Field (ProducerID) — int
  • Key (CompanyNo) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (id2) — int — Foreign key → Producer.Key — NOT NULL
  • Key (Partid) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (Company)

  • Key (CompanyNo) — int — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(50)
  • Field (PhoneNumber) — int

Untitled (Part_Inventory)

  • Key (InventoryNo) — int — Primary key — NOT NULL
  • Field (quantity) — int
  • Field (location) — char(20)
  • Field (status) — char(8)
  • Key (id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (Making)

  • Key (Partid) — int — Primary key — NOT NULL
  • Field (NumberOfPart) — int
  • Field
  • Key (id3) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (Producer_Company)

  • Key (id) — int — Foreign key → Producer.Key — NOT NULL
  • Key (CompanyNo) — int — Foreign key → Untitled.Key — NOT NULL