p21,p2
Tables (7)
Department (Departmant)
- deptNo — char — Primary key — NOT NULL
- name — char
- managerStartDate (manegerStartDate) — Date
- locations — char
- manager — char — Foreign key → Employee.ssn — NOT NULL
Employee
- ssn — char — Primary key — NOT NULL
- name — char
- gender — char
- salary — int
- brithDate (birthDate) — Date
- deptNo — char — Foreign key → Department.deptNo — NOT NULL
- ssn (supervisorID) — char — Foreign key → Employee.ssn — NOT NULL
Project
- projNo — int — Primary key — NOT NULL
- name — char
- deptNo — char — Foreign key → Department.deptNo — NOT NULL
Untitled (dept_Locations)
- deptNo — char — Foreign key → Department.deptNo — NOT NULL
- locNo — char — Foreign key → locations.locNo — NOT NULL
- Field (startDate) — Date
Untitled (works_on)
- ssn — char — Foreign key → Employee.ssn — NOT NULL
- projNo — int — Foreign key → Project.projNo — NOT NULL
- Field (hoursperWeek) — float
Untitled (depentant)
- Key (dependID) — char — Primary key — NOT NULL
- Field (name) — char
- Field (brithDateeld) — date
- Field (relation) — char
- ssn — char — Foreign key → Employee.ssn — NOT NULL
- Field (parent) — char
locations (Locations)
- locNo — char — Primary key — NOT NULL
- locName — char
- Field (address) — char
- Field2 (AdminArea) — char