5조

테이블 (6)

Enrollment

  • Enrollment ID (Key) — 기본 키
  • StudentId (Key2) — 외래 키 → Student.StudentId — NOT NULL
  • LectureId (Key3) — 외래 키 → Lecture.LectureId

Instructor (Untitled4)

  • InstructorID (Key) — 기본 키 — NOT NULL
  • Name (Field)
  • Subject (Field2)
  • Lecture (Field3)
  • Rate (Field4)

Lecture (Untitled3)

  • LectureId (Key) — 기본 키
  • RoomId (Key2) — 외래 키 → Room.RoomId — NOT NULL
  • SubjectID (Key3) — int — 외래 키 → Subject.SubjectID — NOT NULL
  • InstructorID (Key4) — 외래 키 → Instructor.InstructorID — NOT NULL
  • LectureDate (Field4)
  • LectureTime (Field5)
  • Duration (Field6)

Room (Untitled6)

  • RoomId (Key) — 기본 키 — NOT NULL
  • RoomName (Field)
  • SeatCapacity (Field2)
  • Level (Field3)

Student (Untitled5)

  • StudentId (Key) — int — 기본 키 — NOT NULL
  • Name (Field2)
  • DateOfBirth (Field3)
  • PhoneNumber (Field4)
  • Company (Field)

Subject (Untitled2)

  • SubjectID (Key) — int — 기본 키 — NOT NULL
  • SubjectName (Field)
  • Level (Field2)