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