week_4

Tables (6)

DEPARTMENT

  • depId (depID) — char(5) — Primary key — NOT NULL
  • name — char(30)
  • description — text
  • manageStartDate — date
  • ssn — char(10) — Foreign key → EMPLOYEE.ssn — NOT NULL

DEPENDENT

  • dependentName — char(30) — Primary key — NOT NULL
  • gender — char(6)
  • birthDate — date
  • relationship — char(15)
  • parent — char(10)
  • ssn (empID) — char(10) — Foreign key → EMPLOYEE.ssn — NOT NULL

EMPLOYEE

  • ssn (empID) — char(10) — Primary key — NOT NULL
  • name — char(30)
  • phone — char(11)
  • birthDate (birthdate) — date
  • supervisor — char(10)
  • worksOn — char(20)
  • gender — char(6)
  • address — text
  • salary — char(15)
  • depId (depID) — char(5) — Foreign key → DEPARTMENT.depId — NOT NULL

LOCATION

  • locaNo (loc) — char(30) — Primary key — NOT NULL
  • depId (depID) — char(5) — Foreign key → DEPARTMENT.depId — NOT NULL

PROJECT

  • projNo (projNO) — char(20) — Primary key — NOT NULL
  • name — char(20)
  • controllingDepartment — char(5)

WORKSON

  • hours — float
  • projNo (projNO) — int(6) — NOT NULL
  • ssn (empID) — char(10) — Foreign key → EMPLOYEE.ssn — NOT NULL
  • projNo (projNO2) — char(20) — Foreign key → PROJECT.projNo — NOT NULL