데이터베이스과제HW#2

테이블 (8)

COURSE (Untitled4)

  • CNumber (Key) — 기본 키 — NOT NULL
  • CName (Field)
  • Desc (Field2)
  • Hours (Field3)
  • Level (Field4)
  • Dcode (Key2) — 외래 키 → DEPARTMENT.Dcode — NOT NULL

DEPARTMENT (Untitled2)

  • Dcode (Key) — 기본 키 — NOT NULL
  • DName (Field)
  • Number (Field2)
  • Phone (Field3)
  • College (Field4)

INSTRUCTOR (Untitled6)

  • Number (Key) — 기본 키 — NOT NULL
  • Name (Field)
  • Degree (Key2) — 외래 키 → INSTRUCTOR_Degree.Degree — NOT NULL
  • Research (Key3) — 외래 키 → INSTRUCTOR_Research.Research — NOT NULL

INSTRUCTOR_Degree (Untitled7)

  • Degree (Key) — 기본 키 — NOT NULL

INSTRUCTOR_Research (CopyOfUntitled7)

  • Research (Key) — 기본 키 — NOT NULL

MINOR (Untitled3)

  • SNumber (Key) — 외래 키 → STUDENT.SNumber — NOT NULL
  • Dcode (Key2) — 외래 키 → DEPARTMENT.Dcode — NOT NULL

SECTION (Untitled5)

  • CNumber (Key) — 외래 키 → COURSE.CNumber — NOT NULL
  • Number (Key2) — 외래 키 → INSTRUCTOR.Number — NOT NULL

STUDENT (Untitled)

  • SNumber (Key) — 기본 키 — NOT NULL
  • Sex (Field)
  • Class (Field2)
  • City (Field3)
  • Zip (Field5)
  • State (Field4)
  • FirstName (Field6)
  • LastName (Field7)
  • SSN (Field8)
  • Major (Key2) — 외래 키 → DEPARTMENT.Dcode — NOT NULL