2025_2_database

Tables (7)

DEPARTMENT

  • deptNO — char(5) — Primary key — NOT NULL
  • name — char(20)
  • Field (description) — text
  • Field (managerStartDate) — date
  • empID — char(10) — Foreign key → EMPLOYEE.empNO — NOT NULL
  • projNO — char(10) — Foreign key → PROJECT.projNO — NOT NULL

DEPARTMENTLOCATION (DEPARTMENTLOCATIONS)

  • deptNO (deptNO2) — char(5) — Foreign key → DEPARTMENT.deptNO — NOT NULL
  • locationNO (locationNO2) — char(5) — Foreign key → LOCATION.locationNO — NOT NULL

DEPENDENT

  • depdID — char(10) — Primary key — NOT NULL
  • gender — char(10)
  • birthDate — date
  • relationship — char(10)
  • name — char(10)
  • parent — char(5)
  • empID — char(10) — Foreign key → EMPLOYEE.empNO — NOT NULL

EMPLOYEE

  • empNO — char(10) — Primary key — NOT NULL
  • name — char(30)
  • phone — char(11)
  • birthDate — date
  • Field (department) — char(10)
  • deptNO (Key) — char(5) — Foreign key → DEPARTMENT.deptNO — NOT NULL
  • gender — char(10)
  • address — char(35)
  • salary — char(10)
  • Field
  • depdID — char(10) — Foreign key → DEPENDENT.depdID — NOT NULL
  • empNO (empNO2) — char(10) — Foreign key → EMPLOYEE.empNO — NOT NULL

LOCATION (LOCATIONS)

  • locationNO — char(5) — Primary key — NOT NULL
  • name — char(10)
  • address — char(35)

PROJECT

  • projNO — char(10) — Primary key — NOT NULL
  • name — char(15)
  • location — char(20)
  • controllingDepartment — char(20)
  • deptNO — char(5) — Foreign key → DEPARTMENT.deptNO — NOT NULL

WORKSON

  • ssn — char(10) — Primary key — NOT NULL
  • hoursPerWeek (hour) — float
  • empNO — char(10) — Foreign key → EMPLOYEE.empNO — NOT NULL
  • projNO — char(10) — Foreign key → PROJECT.projNO — NOT NULL