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
RELATIONAL DATABASE DESIGN


