2025_2_database
Tables (5)
EMPLOYEE
- Key (emplID) — char — Primary key — NOT NULL
- Field (name) — char(30)
- Field (gender) — text
- Field2 (address) — char(50)
- Field (salary) — text
- Field (birthDate) — date
- Field (department) — char(10)
- Field (supervisor) — text
- Field (Weekly working hours) — char(2)
- Key (deptID) — char(5) — Foreign key → Untitled.Key — NOT NULL
PROJECT
- Key (projID) — char — Primary key — NOT NULL
- Key (projNo) — char(100) — NOT NULL
- Field (name) — char(30)
- Field (location) — text
- Field (controllingDepartment) — text
Untitled (DEPENDENT)
- Key (depID) — char — Primary key — NOT NULL
- Field (dependentName) — char(30)
- Field (gender) — text
- Field (birthDate) — date
- Field (relationship) — text
- Key (emplID) — char — Foreign key → EMPLOYEE.Key — NOT NULL
Untitled (DEPARTMENT)
- Key (deptID) — char(5) — Primary key — NOT NULL
- Key (deptNo) — char(20) — NOT NULL
- Field (name) — char(30)
- Field (locations) — text
- Field (manager) — text
- Field (managerStartDate) — date
- Key (emplID) — char — Foreign key → EMPLOYEE.Key — NOT NULL
Untitled (WORKSON)
- Key (emplID) — char — Foreign key → EMPLOYEE.Key — NOT NULL
- Key (projID) — char — Foreign key → PROJECT.Key — NOT NULL
- Field (hoursPerWeek) — float