슬라이드 20, 21 예제
테이블 (7)
DEPARTMENT (EMPLOYEE)
- departmentID (ssn) — char(12) — 기본 키 — NOT NULL
- name — char(30)
- gender (address) — char(50)
- birthdate (email) — email
- relationship (phone) — char(12)
- Field (birthDate) — date
- Field (department) — char(10)
- Field (gender)
- Key (departmentID) — char(10) — 외래 키 → EMPLOYEE.Key — NOT NULL
EMPLOYEE (DEPARTMENT)
- Key (departmentID) — char(10) — 기본 키 — NOT NULL
- name — char(20)
- gender (phone) — char(20)
- address (email) — email
- salary (manager) — char(10)
- Field (startMangeDate) — date
- departmentID (managerSsn) — char(12) — 외래 키 → DEPARTMENT.departmentID — NOT NULL
PROJECT
- Key (projectID) — char(20) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field2 (description) — longtext
- Field (location) — char(20)
- Field (controllingDepartment) — char(10)
Untitled (DEPENDENT)
- Key2 (dependentID) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (gender) — char(1)
- Field (birthDate) — date
- Field (relation) — char(10)
- departmentID (ssn) — char(12) — 외래 키 → DEPARTMENT.departmentID — NOT NULL
Untitled (WORKSON)
- departmentID (ssn) — char(12) — 외래 키 → DEPARTMENT.departmentID — NOT NULL
- Key (projectID) — char(20) — 외래 키 → PROJECT.Key — NOT NULL
- Field (hour) — float
Untitled (LOCATION)
- Key (locationID) — char(3) — 기본 키 — NOT NULL
- Field (locationName) — char(20)
- Field (description) — text
- Field (adress) — char(50)
Untitled (DEPARTMENT_LOCATION)
- Key (departmentID) — char(10) — 외래 키 → EMPLOYEE.Key — NOT NULL
- Key (locationID) — char(3) — 외래 키 → Untitled.Key — NOT NULL