Relationships in ER Model

Last Updated :
Discuss
Comments

Question 1

What does the degree of a relationship represent in DBMS?

  • Number of attributes in a relation

  • Number of records in a table

  • Number of entity types in a relationship

  • Number of primary keys in an entity

Question 2

Which type of relationship is the most commonly used in databases?

  • Unary

  • Binary

  • Ternary

  • N-ary

Question 3

In a unary relationship, how many entity sets participate?

  • 1

  • 2

  • 3

  • 4

Question 4

Which of the following is true about binary relationships?

  • They cannot be converted into relational tables

  • They are rarely used

  • They involve more than three entities

  • They are the simplest and most common type

Question 5

What does mapping cardinality define in a DBMS?

  • Number of attributes in a table

  • Number of records in a database

  • Number of instances of one entity related to another

  • Number of primary keys in a relation

Question 6

Which type of relationship connects each instance of one entity with exactly one instance of another entity

  • One to many

  • One to one

  • Many to one

  • Many to many

Question 7

What kind of participation is it when every instance of an entity must be involved in a relationship?

  • Partial participation

  • Total participation

  • Weak participation

  • Redundant participation

Question 8

What is a recursive relationship in an ER diagram?

  • A relationship between two different entities

  • A relationship where entities have no roles

  • A relationship between two instances of the same entity

  • A relationship with no attributes

Question 9

In a recursive relationship, how to distinguish the different roles that the same entity plays?

  • Attributes

  • Relationships

  • Role names

  • Constraints

Question 10

What kind of participation is present in the recursive relationship described?

  • Both total

  • Both partial

  • One total, one partial

  • Not applicable

There are 10 questions to complete.

Take a part in the ongoing discussion