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