Task $2$: Creating the Database $(35\%)$ :

Create the database and its tables, taking care to align your implementation closely with the logical model. You should:

Ensure that each entity, along with its associated attributes from the ERD, corresponds to

Implement a range of MySQL integrity constraints, including but not limited to Primary tables and columns in SQL$.$ Keys $($PK$)$ and Foreign Keys $($FK$).$

Utilize indexes to optimize data retrieval.

Insert sample data, making sure there is enough data to generate meaningful query outputs and visualizations.