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