Translate the EER diagram provided below, into a logical diagram. Provided below are also the requirements for the creation of the logical diagram.

Outline of the evaluation criteria: 1. The Logical Diagram (120 points) must: Be in the language/format that we use in this course for logical diagrams Follow the EER logic and rules Include the relations that are necessary to answer all the client's requirements (you should add all the relations that were missing in the EER diagram) Include all the referential integrity connectors Specify the primary key for each relation All the relations must be in the 3rd normal form Each relation must include all the attributes necessary to address the business