Is the following scenario correct and why:
- A and B are two entities
- B is-a A
- A is-a B
And what if A, B were relationship?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
In databases, subtyping means that one domain is a subset of another. If A is a subset of B and B is a subset of A, then it means A = B. The same logic applies whether A and B are entity sets or relationship sets. There would be no point distinguishing A and B in an ER model.