Question 13
Consider the following scenario and answer the given subquestions
A startup company is building an online learning platform that hosts courses on various subjects. In this platform, students can enroll in multiple courses, and each course can be taught by one or more instructors. The company wants to design the database schema to manage the core entities: Student, Instructor, Course, and Enrollment.
In the Enrollment table, which of the following is a typical way to handle the primary key?
Use an auto-increment column (e.g., EnrollmentID) as the primary key.
Use a composite primary key consisting of StudentID and CourseID.
There is no need to have a primary key for the Enrollment table.
Use a primary key consisting of StudentID.