How to create relational mapping when an entity has more than one multivalued attribute in ER Diagram

277 Views Asked by At

We know that if there's an multivalued attribute in any entity - A different new table must be created. My ER Diagram has an entity named 'Restaurant' which has 2 multivaued attributes - 1. Location 2. Contact_no

Restaurants may have more than one locations and every location/branch has more than one Contact_no.

How to create relational database for this? What will the primary keys of the table?

0

There are 0 best solutions below