homework

Tables (7)

Untitled (Employee)

  • Key (EmpID) — char((10) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (birthdate) — date
  • Field (gender) — char(1)
  • Field (salary) — char(4)
  • Field (supervisor) — char(20)
  • Field (phone) — char(11)
  • Key (depID) — char(4) — Foreign key → Untitled.Key — NOT NULL

Untitled

  • Key (depID) — char(4) — Primary key — NOT NULL
  • Field (depname) — char(20)
  • Field (managerStartDate) — date
  • Field (manager) — char(20)
  • Key (EmoID) — char((10) — Foreign key → Untitled.Key — NOT NULL
  • Key (depID2) — char(4) — Foreign key → Untitled.Key — NOT NULL

Untitled2 (Location)

  • Key (locID) — char(4) — Primary key — NOT NULL
  • Field (locname) — char(20)
  • Field (phon) — char(10)

Untitled2 (dep_loc)

  • Key (depID) — char(4) — Foreign key → Untitled.Key — NOT NULL
  • Key (locID) — char(4) — Foreign key → Untitled2.Key — NOT NULL

Untitled2 (Project)

  • Key (proNo) — char(10) — Primary key — NOT NULL
  • Field (proname) — char(20)
  • Field (location) — char(20)
  • Field (controllingDep) — char(4)

Untitled2 (Works-On)

  • Key (EmpID) — char((10) — Foreign key → Untitled.Key — NOT NULL
  • Key (proNo) — char(10) — Foreign key → Untitled2.Key — NOT NULL
  • Field (hour) — char(4)

Untitled2 (Dependent)

  • Key (depenID) — char(10) — Primary key — NOT NULL
  • Field (depname) — char(20)
  • Field (birthdate) — date
  • Field (gender) — char(1)
  • Field (relationship) — char(10)
  • Field (parent) — char(4)
  • Key (EmpID) — char((10) — Foreign key → Untitled.Key — NOT NULL