ERD Ex1

Tables (5)

Company

  • Key (mName) — char(20) — Foreign key → Manufacturer.Key — NOT NULL
  • Key (Name) — char(20) — Foreign key → Product.Key — NOT NULL

Manufacturer

  • Key (mName) — char(20) — Primary key — NOT NULL
  • Field (mNumber) — char(10)
  • Field (mAddress) — char(30)
  • Field (mPhonenumber) — char(10)
  • Key (PartName) — char(20) — Foreign key → Parts.Key — NOT NULL

Parts

  • Key (PartName) — char(20) — Primary key — NOT NULL
  • Field (PartNumber) — char(10)
  • Field (PartExplain) — char(50)
  • Key (Name) — char(20) — Foreign key → Product.Key — NOT NULL
  • Key (mName) — char(20) — Foreign key → Manufacturer.Key — NOT NULL

Product

  • Key (ProductName) — char(20) — Primary key — NOT NULL
  • Field (ProductNumber) — char(10)
  • Field (ProductExplain) — char(50)
  • Key (PartName) — char(20) — Foreign key → Parts.Key — NOT NULL

trace (Untitled)

  • Key (PartName) — char(20) — Foreign key → Parts.Key — NOT NULL
  • Key (ProductName) — char(20) — Foreign key → Product.Key — NOT NULL