Question

in dbms, what will be the outcome when we map a multivalued attribute for any entity from the er model to the relational model?

Answer 1

the multivalued attribute is made into another table and the primary key of original table is made the foreign key in the multivalue table which references the primary key of the original table

Answer 2

Answer:

In Database Management Systems, or DBMS, when a multivalued attribute for any entity is mapped from the Entity-Relationship (ER) Model to the Relational Model, the result is many relations, one for each of the distinct values of the attribute.

An ER Diagram is a conceptual model that needs to be implemented in a database. The implementation is done by converting it to a Relationship Model.

Explanation:

Hope it helpful for you