데이터베이스론 기말고사
테이블 (7)
Department place (Untitled7)
- DepartmentID (Key) — 외래 키 → department.DepartmentID — NOT NULL
- PlaceID (Key2) — 외래 키 → place.PlaceID — NOT NULL
Dependent (Untitled5)
- DependentID (Key) — 기본 키 — NOT NULL
- name (Field)
- gender (Field2)
- birthday (Field3)
- EmployeeID (Key2) — 외래 키 → Employee.EmployeeID — NOT NULL
Employee (Untitled2)
- EmployeeID (Key) — 기본 키 — NOT NULL
- name (Field)
- Birthday (Field2)
- address (Field3)
- Pay (Field4)
- Gender (Field5)
- Resident number (Field6)
- DepartmentID (Key2) — 외래 키 → department.DepartmentID — NOT NULL
Project (Untitled3)
- ProjectID (Key) — 기본 키 — NOT NULL
- Project name (Field)
Project_Employee (Untitled4)
- EmployeeID (Key) — 외래 키 → Employee.EmployeeID — NOT NULL
- ProjectID (Key2) — 외래 키 → Project.ProjectID — NOT NULL
department (Untitled)
- DepartmentID (Key) — 기본 키 — NOT NULL
- Department name (Field)
- Business start date (Field2)
- EmployeeID (Key2) — 외래 키 → Employee.EmployeeID — NOT NULL
- ProjectID (Key3) — 외래 키 → Project.ProjectID — NOT NULL
place (Untitled6)
- PlaceID (Key) — 기본 키 — NOT NULL
- place name (Field)
- place address (Field2)