Consider the scenario where a database designer is structuri…
Consider the scenario where a database designer is structuring a relational database for a university. The database includes two tables: Students and Enrollments. The Students table has a primary key StudentID, and the Enrollments table lists the courses students are enrolled in, with CourseID and StudentID as its columns. The designer plans to enforce referential integrity between these tables.Which of the following implementations correctly utilizes primary and foreign key constraints to maintain database integrity and why?