Skip to content
Related Articles
Open in App
Not now

Related Articles

ISRO | ISRO CS 2015 | Question 16

Improve Article
Save Article
  • Last Updated : 24 Oct, 2018
Improve Article
Save Article

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)

Answer: (C)

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

My Personal Notes arrow_drop_up
Related Articles

Start Your Coding Journey Now!