데이터베이스 과제1
테이블 (4)
DEPARTMENT (Untitled)
- departmentId (Key) — char(4) — 기본 키 — NOT NULL
- deptName (Field) — char(20)
- departManager (Field2) — char(30)
- managerStarDate (Field3) — date
EMPLOYEE (Untitled2)
- employeeId (Field) — char(5)
- name (Field2) — char(20)
- gender (Field3) — char(5)
- address (Field4) — char(30)
- birthdate (Field5) — date
- phone (Field6) — char(11)
- salary (Field7) — char(11)
- depatmentId (Key) — char(4) — 외래 키 → DEPARTMENT.departmentId — NOT NULL
PROJECT (Untitled3)
- projectNo (Field) — char(10)
- projectName (Field2) — char(30)
- location (Field3) — char(20)
- dontrollingDept (Field4) — char(10)
- departmentId (Key) — char(4) — 외래 키 → DEPARTMENT.departmentId — NOT NULL