Consider the following Relationship Entity Diagram(ERD) Which of the following…

To convert the given ER diagram into a relational model, we create one table for each entity and one separate table for the relationship (since it is M:N).

Thus, we must have:

Person (NID, Name) //{Here,NID is primary key for this table}

Exam (ExamID, ExamName) //{Here,ExamID is primary key for this table}

Qualification (NID, ExamID, QualifiedDate) //{Here,NID, ExamID Both together work as a primary key for this table}

The relationship “Qualification” cannot be merged into either entity because it is many-to-many, so a separate relation is required containing the primary keys of both entities.

Options A, B, and D are valid representations. However, Option C (Exam (ExamID, NID, ExamName)) is incorrect because it unnecessarily includes NID in the Exam table, violating proper normalization and incorrectly representing the relationship.

Hence, Option C will not hold. So option C is the correct choice.