Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

An Entity Relationship (ER)-designer is bothered by the large number of binary relationships in his ER diagram, and has the following idea. First create a

An Entity Relationship (ER)-designer is bothered by the large number of binary relationships in his ER diagram, and has the following idea. First create a new entity set called "all-entities" and connect every other entity set to "all-entities" via a generalization arrow. Now every entity belongs to the entity-set "all-entities". Next, replace all of the binary relationships by a single binary relationship called "is-related-to" that connects "all-entities" to itself. The "is-related-to" relationship has an attribute "relationship-type" so that the kind of relationship between two entities can be specified. Because "is-related-to" allows any entity to be related to any other entity, we don't need all of the different binary relationships any more. Critique this design. Is this design simpler because there are fewer binary relationships? Can it accurately model all of the relationships and constraints that might have been represented in the original diagram?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Machine Performance Modeling Methodologies And Evaluation Strategies Lncs 257

Authors: Francesca Cesarini ,Silvio Salza

1st Edition

3540179429, 978-3540179429

More Books

Students also viewed these Databases questions