연습문제
테이블 (7)
Department (department)
- Department ID (department id) — char(4) — 기본 키 — NOT NULL
- DepatmentStartDate (department startdate) — date
- DepartmentName (department name) — char(10)
- DepatmentManger (department manger) — char(30)
- EmployeeNo (Field7) — char(4) — 외래 키 → Employee.EmployeeNo
- DepatementID (Field3) — char(4) — 외래 키 → Employee.DepatementID
- Name (Key2) — char(5) — 외래 키 → Employee.Name — NOT NULL
- DepartmentNo (Key) — char(4) — 외래 키 → DepartmentLocation.DepartmentNo — NOT NULL
DepartmentLocation (Untitled2)
- DepartmentNo (Key) — char(4) — 기본 키 — NOT NULL
- LocationNo (Field) — char(10)
- LocationNo (Key2) — char(10) — 외래 키 → Location.LocationNo — NOT NULL
Employee (employee)
- EmployeeNo (Field7) — char(4) — 기본 키
- DepatementID (Field3) — char(4) — 기본 키
- Name (Key) — char(5) — 기본 키 — NOT NULL
- Phone (Field2) — char(11)
- ProjectName (Field8) — char(4)
- Birthdate (Field) — date
- Address (Field4) — char(50)
- Pay (Field5) — char(8)
- Gender (Field6) — char(1)
- ResidentNumber (Key2) — char(13) — NOT NULL
- Department ID (department id) — char(4) — 외래 키 → Department.Department ID — NOT NULL
Family4 (Untitled4)
- FamilyNo (Key3) — char(4) — 기본 키 — NOT NULL
- FamilyName (Key) — char(5) — NOT NULL
- FamilyGender (Field) — char(1)
- FamilyBirthday (Field2) — date
- Relationship (Field3) — char(10)
- EmployeeNo (Field7) — char(4) — 외래 키 → Employee.EmployeeNo
Location (Untitled5)
- LocationNo (Key) — char(10) — 기본 키 — NOT NULL
- LocationName (Field) — char(20)
- LocationAddress (Field2) — char(50)
Project (Untitled3)
- ProjectNo (Key) — char(4) — 기본 키 — NOT NULL
- ManagerNo (Field3) — char(4)
- Department ID (Key2) — char(4) — 외래 키 → Department.Department ID — NOT NULL
- ProjectNo (project no) — char(4) — 외래 키 → works-on.ProjectNo — NOT NULL
- Name (Key3) — char(5) — 외래 키 — NOT NULL
works-on (Untitled)
- ProjectNo (project no) — char(4) — 기본 키 — NOT NULL
- EmployeeNo (employee no) — char(4)
- weekhour (employee position) — float(5)
- EmployeeParticipation (employee participation) — char(10)
- EmployeePay (employee pay) — char(8)
- EmployeeNo (Field7) — char(4) — 외래 키 → Employee.EmployeeNo
- DepatementID (Field3) — char(4) — 외래 키 → Employee.DepatementID
- Name (Key) — char(5) — 외래 키 → Employee.Name — NOT NULL