과제2
테이블 (7)
DEPARTMENT
- depID — Char(4)
- name — Char(15)
- managerID — Char(10)
- managestartDate (managerStartDate) — date
- empID — Char(10)
EMPLOYEE
- empID — Char(10)
- name — Char(10)
- gcnder (gender) — Char(1)
- phone (adress) — Char(30)
- Salary (phone) — Char(11)
- dcpID (salary) — int(10)
- supcrvEmpID (depID) — Char(4)
- Field (supervEmpID) — Char(10)
PROJECT (DEPENDANT)
- proID (dependID) — char(11)
- proName (name) — chae(30)
- startDate (birthDate) — date
- endDate (relation) — char(10)
- description (empID) — char(10)
Untitled (PROJECT)
- Field (proID) — Char(10)
- Field2 (proName) — Char(30)
- Field3 (stratDate) — date
- Field4 (endDate) — date
- Field (description) — text
- Field (managerdepID) — Char(4)
Untitled (LOCATION)
- Field (locID) — Char(5)
- Field2 (locName) — Char(10)
- Field (phone) — Char(10)
- Field (email) — email
Untitled5 (DEPARTMENT_LOCATION)
- Field (depID) — Char(4)
- Field (locID) — Char(5)
WORKSON
- empID — Char(10)
- proID — Char(10)
- hourperWeek (hourPerWeek) — float