Hausaufgabe

Tables (6)

CONTACT

  • StudentID — Foreign key → STUDENT.StudentID — NOT NULL
  • Email
  • Phone
  • Name

REGISTER (Register)

  • StudentID — Foreign key → STUDENT.StudentID — NOT NULL
  • SectionID — Foreign key → SECTION.SectionID — NOT NULL
  • Grade
  • Teacher
  • RegistrationDate

Require

  • SectionID — Foreign key → SECTION.SectionID — NOT NULL
  • ISBN — Foreign key → TEXTBOOK.ISBN — NOT NULL
  • SalesVolume

SECTION (Section)

  • SectionID — Primary key — NOT NULL
  • CourseName
  • RoomNumber
  • Semester
  • Department

STUDENT (Student)

  • StudentID — Primary key — NOT NULL
  • Major
  • GPA
  • YEAR

TEXTBOOK (Textbook)

  • ISBN — Primary key — NOT NULL
  • Title
  • Publisher
  • Writer
  • Price