A university maintains student records, including courses taken and grades earned. To prevent update anomalies, what should be done when designing the database schema?

Question $39$ options:

Store the student's name and address in each course record

Store the course name and grade in each student record

Store the course name, student ID$,$ and grade in a separate course history record and reference it using foreign keys in the student and course records

Store the student ID and course ID in a single record.