정보학의 이해 과제(모델링예제 slide20,21)
테이블 (7)
DEPARTMENT
- Key (departmentID) — char(10) — 기본 키 — NOT NULL
- Field (department name) — char(20)
- Field (phone) — char(20)
- Field (email) — email
- Field (manager) — char(10)
- Field (startManageDate) — date
- Field (location) — char(30)
- Field (number) — char(10)
- Key (managerSsn) — char(12) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PROJECT)
- Key (projectID) — char(20) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (description) — longtext
- Field (project number) — char(30)
Untitled (EMPLOYEE)
- Key (ssn) — char(12) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (address) — char(50)
- Field (email) — email
- Field (phone) — char(12)
- Field (gender) — char(1)
- Field (birthDate) — date
- Field (wage) — chat(30)
- Key (departmentID) — char(10) — 외래 키 → DEPARTMENT.Key — NOT NULL
- Key (departmentID2) — char(10) — 외래 키 → DEPARTMENT.Key — NOT NULL
Untitled (DEPENDENT)
- Key (dependentID) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (gender) — char(1)
- Field (birthDate) — date
- Field (relation) — char(10)
- Key (employeeSsn) — char(12) — 외래 키 → Untitled.Key — NOT NULL
Untitled (WORKSON)
- Key (ssn) — char(12) — 외래 키 → Untitled.Key — NOT NULL
- Key (projectID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (hour) — float
- Key (departmentID) — char(10) — 외래 키 → DEPARTMENT.Key — NOT NULL
Untitled (LOCATION)
- Key (locationID) — char(3) — 기본 키 — NOT NULL
- Field (locationName) — char(20)
- Field (description) — text
Untitled (DEPARTMENT_LOCATION)
- Key (departmentID) — char(10) — 외래 키 → DEPARTMENT.Key — NOT NULL
- Key (locationID) — char(3) — 외래 키 → Untitled.Key — NOT NULL