2주차교안 p20~21연습문제

테이블 (7)

DEPARTMENT (Untitled2)

  • deptNo (Key) — char(4) — 기본 키 — NOT NULL
  • name (Field) — char(10)
  • manager (Field2) — char(10)
  • managerStartDate (Field3) — date
  • ssn (Key2) — char(13) — 외래 키 → EMPLOYEE.ssn — NOT NULL

DEPENDENT (Untitled7)

  • dependentNo (Key) — char(10) — 기본 키 — NOT NULL
  • name (Field2) — char(10)
  • gender (Field) — char(4)
  • birthDate (Field3) — date
  • relationship (Field4) — char(10)
  • ssn (Key2) — char(13) — 외래 키 → EMPLOYEE.ssn — NOT NULL

DEPT-LOCATION (Untitled6)

  • deptNo (Key2) — char(4) — 외래 키 → DEPARTMENT.deptNo — NOT NULL
  • startDate (Field) — date
  • locationNo (Key) — char(4) — 외래 키 → LOCATION.locationNo — NOT NULL

EMPLOYEE (Untitled)

  • ssn (Key) — char(13) — 기본 키 — NOT NULL
  • name (Field) — char(10)
  • gender (Field2) — char(4)
  • adress (Field3) — char(40)
  • salary (Field4) — char(10)
  • birthDate (Field5) — date
  • supervisor (Field7) — char(10)
  • deptNo (Key2) — char(4) — 외래 키 → DEPARTMENT.deptNo — NOT NULL

LOCATION (Untitled4)

  • locationNo (Key) — char(4) — 기본 키 — NOT NULL
  • name (Field) — char(10)
  • adress (Field2) — char(40)

PROJECT (Untitled3)

  • projNo (Key) — char(4) — 기본 키 — NOT NULL
  • name (Field) — char(10)
  • location (Field2) — char(20)
  • controllingDepartment (Field3) — char(4)
  • deptNo (Key2) — char(4) — 외래 키 → DEPARTMENT.deptNo — NOT NULL

WORKS-ON (Untitled5)

  • worts-onNo (Key3) — char(10) — 기본 키 — NOT NULL
  • hours (Field2) — char(10)
  • salary (Field3) — char(10)
  • projNo (Key) — char(4) — 외래 키 → PROJECT.projNo — NOT NULL
  • ssn (Key2) — char(13) — 외래 키 → EMPLOYEE.ssn — NOT NULL