$6\mathrm{.}2-$ University Database with Marks and Exams

Students, courses, sections, and test grades are all involved in this activity.

$6\mathrm{.}2$a $-$ Ternary Relationship ER Diagram:

Student: Serves as the entity's representative.

Course: This refers to the available courses.

Section: There may be more than one section in a course.

Exam: Students take numerous tests for each unit.

In this case, there is a ternary link between the student, section, and exam, allowing the

student to take several tests in various sections.

Relation Schemas:

Student: $($Studentald$,$ Name, Address$)$

Course: $($Courskead$,$ Title, Department$)$

Section: $($Section ID$,$ Courseald, Instructor$)$

Exam: $($ExamelD$,$ Section ID$,$ Date, Type$)$

Student Exam Marks: $($

Student.ID$,$ Section ID$,$ ExamoID, Marks$)$

$6\mathrm{.}2$b $-$ Binary Relationship ER Diagram: