Book
Tables (4)
Department (department)
- depID — int — Primary key — NOT NULL
- Field (depManager) — char(30)
- Field (managerStartDate) — date
- Field (Location) — char(20)
- Field (depName) — char(20)
- Key (empSSN) — char(14) — Foreign key → EMPLOYEE.EmpSSN — NOT NULL
EMPLOYEE
- EmpSSN — Char(14) — Primary key — NOT NULL
- EmpName — Char(30)
- (Department) — Int
- Field (DepID) — Int
- Field (SuperVssn) — Char(14)
- EmpSSN (EmpSSN2) — Char(14) — Foreign key → EMPLOYEE.EmpSSN — NOT NULL
- depID — int — Foreign key → Department.depID — NOT NULL
PROJECT
- ProjectID — Int(10) — Primary key — NOT NULL
- ProjectName — Char(30)
- StartDate — Date
- EndDate — Date
- Description — Text
- depID (ManagedepID) — int — Foreign key → Department.depID — NOT NULL
Workson
- EmpSSN — Char(14) — Foreign key → EMPLOYEE.EmpSSN — NOT NULL
- ProjectID — Int(10) — Foreign key → PROJECT.ProjectID — NOT NULL
- HoursPerWeek — Float