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)