Aims  To analyse and comprehend a given ER diagram and Relational Data Structures;  To implement a database based on the given ER diagram and Relational Data Structures;  To write required SQL statements to query the database; and  To write SQL statements to manipulate the data in the database. Learning Objectives In 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 ER diagram and the corresponding Database schema; and  learn how to use Data Manipulation statements to query a database, and insert and update data in the tables