Please explain:

 

 

For this step, you should draw an E-R Diagram for this dataset. To this goal, you should conduct the following steps (as an example please refer to the 15th slide in the Database Management presentation file): 1. Identify the entities and composite entities (10 Marks) 2. Identify the entities' attributes and primary key (10 Marks) 3. Identify the relationships among the entities and between entities and composite entities (10 Marks) 4. Specify the relationships' type (e.g., one-to-one,1-1, one-to-many,1-M, or many-to-many, M-M)(10 Marks) Note 1: To draw the E-R diagram, please use the following symbols. CODO Note Entity Relationship Composite entity Attribute 2: To identify primary keys, please underline them. Note 3: Please note that, for any identified M:N relationship, you should introduce a composite entity to resolve the M:N problem.