Question

Q2 Demonstrate with an example how an entity set is mapped to a relation/table. ​

Answer 1

Explanation:

Mapping Process

Create table for a relationship. Add the primary keys of all participating Entities as fields of table with their respective data types. If relationship has any attribute, add each attribute as field of table. Declare a primary key composing all the primary keys of participating entities.