연습문제

테이블 (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