Aims
?To analyse and comprehend a given ER diagram and Database schema

? To implement a database based on the given ER diagram and Database schema
? To write required SQL statements to query the database
? 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 use Data Definition statements to implement a database from a given ER diagram
and the corresponding Database schema
? learn how to use Data Manipulation statements to query a database, and insert and update data
in the tables