homework
Tables (7)
Untitled (Employee)
- Key (EmpID) — char((10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (birthdate) — date
- Field (gender) — char(1)
- Field (salary) — char(4)
- Field (supervisor) — char(20)
- Field (phone) — char(11)
- Key (depID) — char(4) — Foreign key → Untitled.Key — NOT NULL
Untitled
- Key (depID) — char(4) — Primary key — NOT NULL
- Field (depname) — char(20)
- Field (managerStartDate) — date
- Field (manager) — char(20)
- Key (EmoID) — char((10) — Foreign key → Untitled.Key — NOT NULL
- Key (depID2) — char(4) — Foreign key → Untitled.Key — NOT NULL
Untitled2 (Location)
- Key (locID) — char(4) — Primary key — NOT NULL
- Field (locname) — char(20)
- Field (phon) — char(10)
Untitled2 (dep_loc)
- Key (depID) — char(4) — Foreign key → Untitled.Key — NOT NULL
- Key (locID) — char(4) — Foreign key → Untitled2.Key — NOT NULL
Untitled2 (Project)
- Key (proNo) — char(10) — Primary key — NOT NULL
- Field (proname) — char(20)
- Field (location) — char(20)
- Field (controllingDep) — char(4)
Untitled2 (Works-On)
- Key (EmpID) — char((10) — Foreign key → Untitled.Key — NOT NULL
- Key (proNo) — char(10) — Foreign key → Untitled2.Key — NOT NULL
- Field (hour) — char(4)
Untitled2 (Dependent)
- Key (depenID) — char(10) — Primary key — NOT NULL
- Field (depname) — char(20)
- Field (birthdate) — date
- Field (gender) — char(1)
- Field (relationship) — char(10)
- Field (parent) — char(4)
- Key (EmpID) — char((10) — Foreign key → Untitled.Key — NOT NULL