Convert this E/R diagram to relations, resolving the dual use of the attribute \

Question

Convert this E/R diagram to relations, resolving the dual use of the attribute "name" in some reasonable way. Then, confirm your correct translation by indicating which of the database schemas below is the most reasonable translation from the E/R diagram above into relations?

Convert this E/R diagram to relations, resolving the dual use of the attribute "name" in some reasonable way. Then, confirm your correct translation by indicating which of the database schemas below is the most reasonable translation from the E/R diagram above into relations?

Explanation / Answer

I think (B) is the most resonable translation .because it is recommended not to have same attribute names which leads to ambiguity and also we can able to see which city is in which state.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

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