Consider the following Relationship Entity Diagram(ERD)
Which of the following possible relations will not hold if the above ERD is mapped into a relation model?
(A) Person (NID, Name)
(B) Qualification (NID, ExamID, QualifiedDate)
(C) Exam (ExamID, NID, ExamName)
(D) Exam (ExamID, ExamName)
Explanation: If we convert an ER diagram into relational model then we can create table for each entity.
We get two tables
One for Entity Person – Person(NID,Name)
One for Entity Exam – Exam(ExamID,ExamName)
Now for relationship Entity Qualification, we can not add QualifiedDate in any of the two tables formed so we need to create a new table using Primary Key from both Entity Person and Entity Exam.
We obtain Qualification(NID, ExamID, QualifiedDate)
Hence Option (C) does not make any sense.
Quiz of this Question
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.