Convert this E/R diagram to relations, resolving the dual use of the attribute \
ID: 3675438 • Letter: C
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.