Question 1 of 19
In a relational database for a university, there are two tables: `Students` and `Courses`. The `Students` table contains columns for `StudentID`, `Name`, and `Major`, while the `Courses` table includes `CourseID`, `CourseName`, and `Credits`. Each student can enroll in multiple courses, and each course can have multiple students. If a new relationship is established through a junction table called `Enrollments`, which includes `StudentID` and `CourseID`, what is the primary purpose of this junction table in the context of database normalization and relationship management?
To facilitate a many-to-many relationship between students and courses
To store additional attributes related to students
To ensure that each course has a unique identifier
To maintain a history of course offerings

Preparing for Microsoft 98-364 Database Fundamentals? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free