Objectives:
To analyse and comprehend a provided ER diagram and Database Schema
To implement a database based on the provided ER diagram and Database Schema
To write required SQL statements to query the database
Project Specification
The management team of BigM now require a partial implementation of the design made
in Assignment 1. In order to keep consistency between the assignments, database
specification containing the ER diagram and the schema is provided in this document. You
should create your database according to this documentation. Please make sure that your
implementation is consistent with this design. This means that your table names (upper
case), field names (mixed case, no spaces) and data types have to be according to the
specifications provided in this document. The implementation phase includes writing SQL
statements to create a database and its tables, populating the tables with data, writing a
number of queries to create reports that can be used by the management team. Your
database should contain sufficient data in each table (at least, 5 to 10 records in each
table; some may require less or more) to demonstrate that your queries work.
