Identify the entities and relationships in the scenario given above and draw ER diagram and showing the entities, attributes, relationships, and cardinality.Decompose the design to create a schema to store the data in a suitable normal form (2NF).Create a MySQL database to store the data and Carry out the appropriate SQL queries and SQL code and the result of running the query on the data in your database
