a simple looking ERD (chen notation) situation - but seems quite tricky
Hi guys! I'm new to this forum, I originally joined, because of this problem I am having. I am a student studying databases applications and technologies, and it's one of my favourite courses at the moment. I think you will be seeing a fair bit of me round here, and when I'm less busy I'll keep a look out to give help with SQL and DB design concepts where possible
Anyway, the problem:
whilst designing the conceptual model for a database system, I've bumped into a point where I can go no further. :/
I need each occurrence of B to mandatorily have a relationship with at least one occurrence in either A1, or A2, or both, but it can't just be entered with having no relationships in both of A1 an A2.
How do I express this in chen notation? because in the above diagram, it just shows that I could make an occurrence in B that has no relationship with either of A1, or A2, because there's no double "mandatory" lines leading from it
Oh, also, I need the solution to still use a superclass/subclass relationship at least somewhere (it's brownie points)