2주차교안 p20~21연습문제
테이블 (7)
DEPARTMENT (Untitled2)
- deptNo (Key) — char(4) — 기본 키 — NOT NULL
- name (Field) — char(10)
- manager (Field2) — char(10)
- managerStartDate (Field3) — date
- ssn (Key2) — char(13) — 외래 키 → EMPLOYEE.ssn — NOT NULL
DEPENDENT (Untitled7)
- dependentNo (Key) — char(10) — 기본 키 — NOT NULL
- name (Field2) — char(10)
- gender (Field) — char(4)
- birthDate (Field3) — date
- relationship (Field4) — char(10)
- ssn (Key2) — char(13) — 외래 키 → EMPLOYEE.ssn — NOT NULL
DEPT-LOCATION (Untitled6)
- deptNo (Key2) — char(4) — 외래 키 → DEPARTMENT.deptNo — NOT NULL
- startDate (Field) — date
- locationNo (Key) — char(4) — 외래 키 → LOCATION.locationNo — NOT NULL
EMPLOYEE (Untitled)
- ssn (Key) — char(13) — 기본 키 — NOT NULL
- name (Field) — char(10)
- gender (Field2) — char(4)
- adress (Field3) — char(40)
- salary (Field4) — char(10)
- birthDate (Field5) — date
- supervisor (Field7) — char(10)
- deptNo (Key2) — char(4) — 외래 키 → DEPARTMENT.deptNo — NOT NULL
LOCATION (Untitled4)
- locationNo (Key) — char(4) — 기본 키 — NOT NULL
- name (Field) — char(10)
- adress (Field2) — char(40)
PROJECT (Untitled3)
- projNo (Key) — char(4) — 기본 키 — NOT NULL
- name (Field) — char(10)
- location (Field2) — char(20)
- controllingDepartment (Field3) — char(4)
- deptNo (Key2) — char(4) — 외래 키 → DEPARTMENT.deptNo — NOT NULL
WORKS-ON (Untitled5)
- worts-onNo (Key3) — char(10) — 기본 키 — NOT NULL
- hours (Field2) — char(10)
- salary (Field3) — char(10)
- projNo (Key) — char(4) — 외래 키 → PROJECT.projNo — NOT NULL
- ssn (Key2) — char(13) — 외래 키 → EMPLOYEE.ssn — NOT NULL