To analyse and comprehend a given ER diagram and Database schema• To implement a database based on the given ER diagram and Database scheme• To write required SQL statements query the database• Write SQL statements to manipulate the data in the databaseLearning ObjectivesIn the process of this assessment task you will:• plan, schedule and execute project tasks with a view to improving your personal productivity;• gain awareness of the typical challenges related to the practical implementation of databases;• learn how to used Data Definition statements to implement a database from a given ERdiagram and the corresponding Database schema• learn how to use Data Manipulation statements to query a database, and insert and updatedata in the tables