1
Tables (8)
Department (DEPARTMENT)
- DepartmentNum (departmentNum) — char(2) — Primary key — NOT NULL
- name — char(20)
- managerNum — char(2)
- budget — char(10)
- employeeID — char(10)
Department_Location (DEPARTMENT_LOCATION)
- DepatmentNum (departNum) — char(2) — Primary key — NOT NULL
- LocationNum (locationNum) — chart(12)
- DepartmentNum (darpatyNum) — char(2) — Foreign key → Department.DepartmentNum — NOT NULL
- LocationNum (locationNum2) — char(2) — Foreign key → Location.LocationNum — NOT NULL
Dependant (DEPENDANT)
- dependantID (deptID) — char(10) — Primary key — NOT NULL
- name — char(20)
- employeeID (birthdate) — date
- Key2 (employe4eSsn) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
EMPLOYEE
- ssn — char(14) — Primary key — NOT NULL
- Field (phone) — char(11)
- Field (gender) — integer(1)
- Field (birthdate) — char(8)
- Field (name) — char(20)
- Key (projectNum) — char(11) — Foreign key → PROJECT_EMPLOYEE.Key — NOT NULL
- Key (employeeID2) — char(10) — Foreign key → PROJECT_EMPLOYEE.Key — NOT NULL
- departID (Key) — char(2) — Foreign key → Department.DepartmentNum — NOT NULL
Location (LOCATION)
- LocationNum (locationNum) — char(2) — Primary key — NOT NULL
- LocationName (locationName) — char(20)
- Adress (adress) — char(20)
PROJECT_EMPLOYEE
- Key (projectNum) — char(11) — Primary key — NOT NULL
- Key (employeeID) — char(10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (location) — char(20)
- Field (controllingDepartment) — char(20)
Project (PROJECT)
- projectID — char(10) — Primary key — NOT NULL
- projectname — char(20)
- manageDepartment (description) — text
- departmentNum (duration) — char(30)
- Key (employeeID) — char(10) — Foreign key → PROJECT_EMPLOYEE.Key — NOT NULL
Workson (WORKSON)
- projectID (ssn) — char(10) — Foreign key → Project.projectID — NOT NULL
- ssn (projectID) — char(10) — Foreign key → EMPLOYEE.ssn — NOT NULL
- Field (hours) — float