일원관계(1)

테이블 (3)

COURSE (Untitled)

  • CourseNo (Key) — char(10) — 기본 키 — NOT NULL
  • Title (Field) — text
  • CreditHours (Field2)
  • CourseNo (Key2) — char(10) — 외래 키 → COURSE.CourseNo — NOT NULL

DEPARTMENT (Untitled3)

  • deptNo (Key) — char(3) — 기본 키 — NOT NULL
  • Name (Field) — char(10)
  • managerNo (Field2) — char(2)
  • budget (Field3) — char(5)
  • employeeNo (Key2) — char(3) — 외래 키 → EMPLOYEE.employeeNo — NOT NULL

EMPLOYEE (Untitled2)

  • employeeNo (Key) — char(3) — 기본 키 — NOT NULL
  • firstName (Field) — char(10)
  • lastName (Field2) — char(10)
  • phon (Field3) — char(10)
  • deptNo (Field4) — char(3)