A university maintains a database where each student has a unique ID, but multiple students can enroll in the same course, and each course has a unique Course_ID. The database design needs to ensure that if a student drops a course, the enrollment record is removed, but neither the student nor the course information is deleted.
Which type of referential integrity constraint is most appropriate for the Enrollment table, referencing both Student and Course tables?