20230907

Tables (8)

DEPARTMENTLOCATION (Untitled5)

  • Key (depID) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (localNo) — int — Foreign key → Location.Key — NOT NULL

EMPLOYEEFAMILY (Untitled2)

  • Key (famSSN) — char(14) — Primary key — NOT NULL
  • Field (famName) — char(30)
  • Field (famGender) — char(10)
  • Field (famBirth) — date
  • Field (famRelation) — char(20)
  • Key (empSSN) — char(14) — Foreign key → Untitled.Key — NOT NULL

Location (Untitled4)

  • Key (localNo) — int — Primary key — NOT NULL
  • Field (localName) — char(20)
  • Field (localAddress) — char(30)

PROJECT (Untitled)

  • Key (proNo) — int — Primary key — NOT NULL
  • Field (proName) — char(20)
  • Key (depID) — int — Foreign key → Untitled.Key — NOT NULL

PROJECTMANAGE (Untitled6)

  • Key (proNo) — int — Foreign key → PROJECT.Key — NOT NULL
  • Key (empSSN) — char(14) — Foreign key → Untitled.Key — NOT NULL

Untitled (DEPARTMENT)

  • Key (depID) — int — Primary key — NOT NULL
  • Field (depName) — char(20)
  • Field (depLocation) — char(20)
  • Field2 (depManager) — int
  • Field2 (managerStartDate) — date
  • Key (empSSN) — char(14) — Foreign key → Untitled.Key — NOT NULL

Untitled (EMPLOYEE)

  • Key (empSSN) — char(14) — Primary key — NOT NULL
  • Field (empName) — char(30)
  • Field (empDepartment) — int
  • Key (depID) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (empSalary) — int
  • Field (empAddress) — char(30)
  • Field (empGender) — char(10)
  • Field (supervisor) — char(30)
  • Key (superVssn) — char(14) — Foreign key → Untitled.Key — NOT NULL
  • Field

WORKSON (Untitled3)

  • Key (empSSN) — char(14) — Foreign key → Untitled.Key — NOT NULL
  • Key (proNo) — int — Foreign key → PROJECT.Key — NOT NULL
  • hoursPerWeek (Field) — float