Database Implementation and Queries
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.
MyAssignmenthelp.com has gained overwhelming popularity among the students of USA for providing cheap dissertation help without hampering the quality of papers. We are one of the few dissertation service providers who offer the combination of quality and affordability. Hence, we have become most preferred dissertation help provider in Washington, D.C., New York, Chicago and many cities of America. Apart from buying dissertation online, students also can avail editing and proofreading services from us. We also boast a pool of experienced dissertation editors who handle students requests for editing and proofreading.