Question 15159 – DSSSB TGT 2021
March 15, 2024Software-Engineering
March 15, 2024ER-Model
Question 12
|
In an Entity-Relationship (ER) model, suppose R is a many-to-one relationship from entity set E1 to entity set E2. Assume that E1 and E2 participate totally in R and that the cardinality of E1 is greater than the cardinality of E2.
Which one of the following is true about R?
Every entity in E1 is associated with exactly one entity in E2.
|
|
Some entity in E1 is associated with more than one entity in E2.
|
|
Every entity in E2 is associated with exactly one entity in E1.
|
|
Every entity in E2 is associated with at most one entity in E1.
|
Question 12 Explanation:
![](https://solutionsadda.in/wp-content/uploads/2019/12/6.jpg)
The M : 1 relationship holds between two entities E1 and E2, in which each tuple from E2 is in relation with many tuples of E1. One tuple from E1 is in relation with only one tuple of E2.
It is given that participation from both the sides is total and the cardinality of E1 is greater than E2.
![](https://solutionsadda.in/wp-content/uploads/2019/12/7.jpg)
Therefore, every entity E1 is associated with exactly one entity in E2.
Correct Answer: A
Question 12 Explanation:
![](https://solutionsadda.in/wp-content/uploads/2019/12/6.jpg)
The M : 1 relationship holds between two entities E1 and E2, in which each tuple from E2 is in relation with many tuples of E1. One tuple from E1 is in relation with only one tuple of E2.
It is given that participation from both the sides is total and the cardinality of E1 is greater than E2.
![](https://solutionsadda.in/wp-content/uploads/2019/12/7.jpg)
Therefore, every entity E1 is associated with exactly one entity in E2.
Subscribe
Login
0 Comments