과제

테이블 (6)

DEPARTMENT (Untitled)

  • deptNo (Key) — char(2) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • manager (Key2) — 외래 키 → EMPLOYEE.ssn — NOT NULL
  • managerStartDate (Field4) — char(8)
  • locations (Key3) — 외래 키 → LOCATION.locaNo — NOT NULL

DEPENDENT (Untitled5)

  • dependentName (Field)
  • gender (Field2)
  • birthDate (Field3)
  • parent (Field5)
  • ssn (Key2) — 외래 키 → EMPLOYEE.ssn — NOT NULL
  • relationship (Field4)

EMPLOYEE (Untitled4)

  • ssn (Key) — 기본 키 — NOT NULL
  • name (Field)
  • gender (Field2)
  • address (Field3)
  • salary (Field4)
  • birthDate (Field5)
  • department (Key4) — char(2) — 외래 키 → DEPARTMENT.deptNo — NOT NULL
  • supervisor (Key3) — 외래 키 → EMPLOYEE.ssn — NOT NULL

LOCATION (Untitled6)

  • locaNo (Key) — 기본 키 — NOT NULL
  • name (Field2)
  • address (Field)
  • deptNo (Key2) — char(2) — 외래 키 → DEPARTMENT.deptNo — NOT NULL

PROJECT (Untitled2)

  • projNo (Key) — char(2) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • controllongDepartment (Key2) — char(2) — 외래 키 → DEPARTMENT.deptNo — NOT NULL

WORKS-ON (Untitled3)

  • ssn (Key) — 외래 키 → EMPLOYEE.ssn — NOT NULL
  • projNo (Key2) — char(2) — 외래 키 → PROJECT.projNo — NOT NULL
  • hours (Field3)