Search code examples
databasedatabase-designentitydiagramerd

Database moddelling - Trying to understand


erd

Hey guys, I always get confused by this so it's not exactly my strong point :( Am I understanding correctly that the above example suggests:

One shop must have one or more clients One client must have one shop

If there was to be a circle where at the end of the client arrow it suggests that the shop has zero or many clients.

I know it's a bad example but I am just trying to get my head around it. (Always get it the wrong way round)

Thanks very much, all help appreciated.

it's just a quick example so I apologise for the bad naming convention of table names


Solution

  • Yes, you are understanding correctly.