ERD Exercise1

Tables (6)

Untitled (PRODUCTOR)

  • prodID (Key) — int(15) — Primary key — NOT NULL
  • prodName (Field) — char(15)
  • prodAddress (Field2) — char(20)
  • prodPH (Field3) — int(12)
  • pdtcompID (Key2) — int(15) — Foreign key → Untitled.pdtcompID — NOT NULL

Untitled (COMPONENT)

  • compNumber (Key) — int(15) — Primary key — NOT NULL
  • compExplanation (Field) — text
  • compID (Key3) — int(15) — Foreign key → Untitled.compID — NOT NULL
  • prodID (Key2) — int(15) — Foreign key → Untitled.prodID — NOT NULL

Untitled (PRODUCT)

  • pdtNum (Key) — int(15) — Primary key — NOT NULL
  • pdtExp (Field) — text
  • pdtPrice (Field2) — int
  • compID (Key2) — int(15) — Foreign key → Untitled.compID — NOT NULL

Untitled (COMPANY)

  • compID (Key) — int(15) — Primary key — NOT NULL
  • compName (Field) — char(15)
  • compAddress (Field2) — char(15)
  • compPH (Field3) — int(12)
  • pdtcompID (Key2) — int(15) — Foreign key → Untitled.pdtcompID — NOT NULL

Untitled (MAKE)

  • compNumber (Key) — int(15) — Foreign key → Untitled.compNumber — NOT NULL
  • pdtNum (Key2) — int(15) — Foreign key → Untitled.pdtNum — NOT NULL
  • compNumber (Field) — int(15)
  • pdtNum (Field2) — int(15)
  • amount (Field3) — int

Untitled (PRODUCT COMPANY)

  • pdtcompID (Key) — int(15) — Primary key — NOT NULL
  • pdtcompName (Field) — char(15)
  • pdtcompAddress (Field2) — char(15)
  • pdtcompPH (Field3) — int(12)