4.1c

Tables (3)

Major (--)

  • MajorID (PK) — Primary key — NOT NULL
  • MajorName (Field)

Student (Untitled)

  • StudentID (PK) — Primary key — NOT NULL
  • StudentName (Field)
  • PhoneNumber (Field2)

Student_Major (-)

  • RegistrationID (PK) — Primary key — NOT NULL
  • StudentID (FK1) — Foreign key → Student.StudentID — NOT NULL
  • MajorID (FK2) — Foreign key → Major.MajorID — NOT NULL