Saturday, July 16, 2022

RDBMS MCQ - Referential integrity and cardinality ratio in ER model

Multiple choices questions in DBMS, Interview questions in RDBMS, How referential integrity and cardinality ratio are related? How do we represent referential integrity in ER diagram? How to model referential integrity using cardinality ratios in entity relationship diagram?

RDBMS solved MCQ - Referential integrity and cardinality ratio in entity relationship model

< Previous                      

Next >

 

1. A relationship R connecting entity sets E and F has referential integrity from E to F, i.e., the edge connecting R and F has an arrow directed towards F. Which among the following statements may be true?

a) R is many-to-many from E to F

b) R is many-to-one from E to F

c) R is many-to-one from F to E

d) R is one-to-one from E to F

Answer: (b) R is many-one from E to F and (d) R is one-one from E to F

Referential integrity is a constraint added to a many-to-one relationship in the “one direction.” Since a one-to-one relationship is a special case of a many-to-one relationship, R may be one-one from E to F.

While reducing ER diagram into conceptual schemas, the primary key of the ONE side entity set will be added as the foreign key in the MANY side (or ONE side in one-to-one relationship) entity set.

Example:

 


In the ERD given above, Teacher is on ONE side and Subject is MANY side. After converting the ERD, the conceptual schemas are as follows;

Teacher (ERP, Name, Qualification, Address, Phone)

Subject (Sub_ID, Sub_Name, Syllabus, Medium, ERP)

ERP in Subject is the foreign key that refers ERP of Teacher.

 



< Previous                      

Next >


************************
Related posts:


What is referential integrity?

Cardinality ratios and referential integrity in Entity relationship model

How to represent referential integrity for a given type of relationship set in ER diagram?

Referential integrity and ER modeling

DBMS solved MCQ; database management system MCQ solved questions

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents

data recovery