데이터베이스론 기말고사

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