Given the following ER diagram requiring translation to the ER model: Assume tha

Question

Given the following ER diagram requiring translation to the ER model: Assume that there are about the same number of Dogs as Show Dogs. (type A query) " find all German Shepherd dogs that ranked 2^nd or above" or similar query, will represent 80% of all queries that I expect to be applied to my database, and (type B query) "find all German Shepherd dogs" or a similar query, will represent 5% of all queries that I expect to be applied to my database Which relational model translation, ER, OO, or null values would be most appropriate. and why?

Explanation / Answer

Entity relationship, ER, model would be most appropriate for representating the above kind of relationship as the model is based upon relationships.

It shows an entity( i.e. a dog) and its relation with the "is a dog" and then shows its rank and other attributes.

The database will contain two tables:

DOG

Name | D_ID | BREED | Other attributes..

SHOW_DOG

D_ID | RANK | Other attributes..

Type A query:

Select NAME from DOG,SHOW-DOG where BREED="German Shepard" and RANK<=2 and DOG.D_ID = SHOW-DOG.D_ID;

Type B query:

Select NAME from DOG where BREED="German Shepard";

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.