c

Tables (5)

DEPARTMENT

  • depNo (Key) — int — Primary key — NOT NULL
  • depName (Field) — char(30)
  • managerStart (Field3) — date
  • location (Field4) — char(30)
  • managerSsn (Key2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL

DEPENDENT (Untitled4)

  • dependentNo (Key) — int — Primary key — NOT NULL
  • dependentName (Field) — char(50)
  • gender (Field2) — char(1)
  • birthDate (Field3) — date
  • ssn (Field4) — char(14)
  • relation (Field5) — char(20)
  • ssn (Key2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL

EMPLOYEE (Untitled3)

  • ssn (Key) — char(14) — Primary key — NOT NULL
  • empName (Field) — char(50)
  • address (Field2) — char(70)
  • salary (Field3) — int
  • birthDate (Field4) — date
  • gender (Field5) — chao(1)
  • supervisor (Field6) — char(14)
  • depNo (Key2) — int — Foreign key → DEPARTMENT.depNo — NOT NULL

PROJECT (Untitled2)

  • proNo (Key) — int — Primary key — NOT NULL
  • proName (Field) — char(50)
  • description (Field2) — text
  • manageDepartment (Field3)

WORKSON

  • woNo (Key3) — int — Primary key — NOT NULL
  • ssn (Key) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
  • proNo (Key2) — int — Foreign key → PROJECT.proNo — NOT NULL