assignnmnet4

Tables (7)

Contact (Untitled2)

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

REGISTER (Untitled3)

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

REQUIRE (Untitled7)

  • SectionID — Foreign key → Section.SectionID — NOT NULL
  • ISBN — Foreign key → TEXTBOOK.ISBN — NOT NULL
  • SalesVo;ume (SalesVolume)

STUDENT (Untitled)

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

Section (Untitled4)

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

TEXTBOOK (Untitled5)

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

Writer (Untitled6)

  • ISBN — Foreign key → TEXTBOOK.ISBN — NOT NULL
  • Writer