1

I'm designing an entity-relationship diagram (ERD) for a marketplace of events. An event can be created by a user, in which case the Event table must have owner_id or we pull it from an API in which case the Event table must have api_id.

However, it can only be one way or the other. So, an event can be created by a user or pulled from API, never both.

How do I express owner_id and api_id as mutually-exclusive in ER diagram and how will it translate in tables?

This is the ERD I have developed so far:

enter image description here

0

One possible solution to this is move the API entity up next to Admin, User, Biz User, and make a relationship User ISA (is a?) API.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.