ERD Exercise1

Tables (6)

Untitled (Product)

  • Key (UniProNo) — Int(20) — Primary key — NOT NULL
  • Field (ProDescrip) — Char(30)
  • Field (Price) — Char(15)

Untitled (Part1)

  • Key (UniPartNo) — Int(20) — Primary key — NOT NULL
  • Field (PartDescrip) — Char(50)
  • Field (UniSupNo) — Int(20)
  • Key (UniProNo) — Int(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (UniSupNo2) — Int(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (UniProNo2) — Int(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (Part2)

  • Key (UniPartNo) — Int(20) — Primary key — NOT NULL
  • Field (PartDescrip) — Char(50)
  • Field (UniSupNo) — Int(20)
  • Key (UniProNo) — Int(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (UniSupNo2) — Int(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (UniProNo2) — Int(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (Part3)

  • Key (UniPartNo) — Int(20) — Primary key — NOT NULL
  • Field (PartDescrip) — Char(50)
  • Field (UniSupNo) — Int(20)
  • Key (UniProNo) — Int(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (UniProNo2) — Int(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (Found)

  • Key (UniProNo) — Int(20) — Primary key — NOT NULL
  • Field (UniPartNo) — Int(20)
  • Field (Quantity) — Int(10)

Untitled (Supplier)

  • Key (UniSupNo) — Int(20) — Primary key — NOT NULL
  • Field (Name) — Char(20)
  • Field (Address) — Char(50)
  • Field (PhoneNo) — Int(20)