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