Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. An ER-diagram designer comes up with the following argument. It isn't necessary to have all these different entities and relationships. Just create one kind

image text in transcribed
1. An ER-diagram designer comes up with the following argument. "It isn't necessary to have all these different entities and relationships. Just create one kind of entity, say E, one kind of binary relationship. say B, one kind of ternary relationship, say T, and so on. Then all entities belong to E, and we give E all attributes that an entity can possibly have. When an entity is missing a certain attribute we'll record a NULL. Similarly, every possible binary relationship could be mapped to B, again allowing for all possible attributes in B. By doing this exercise, we have a much simpler design: just one entity set and a small number of relationship sets." Explain why the design proposed by this designer is unsatisfactory. Make sure to describe all of the potential deficiencies of the design. Do you agree that the proposed design is "simpler

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_2

Step: 3

blur-text-image_3

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

Advances In Spatial Databases 2nd Symposium Ssd 91 Zurich Switzerland August 1991 Proceedings Lncs 525

Authors: Oliver Gunther ,Hans-Jorg Schek

1st Edition

3540544143, 978-3540544142

More Books

Students also viewed these Databases questions