The Sakila sample database was initially developed by Mike Hillyer and is intended to provide a standard schema that can be used for examples in books, tutorials, articles, samples, and so forth....

The Sakila sample database was initially developed by Mike Hillyer and is intended to provide a standard schema that can be used for examples in books, tutorials, articles, samples, and so forth.
Using the MySQL Sakila database students are requested to implement a Data Mart by identifying an important business process and associated business requirements, designing a dimensional model that will support the requirements, implementing it using MySQL and populating it with appropriate data. The students should also demonstrate how the data mart meets the business requirements by the use of querying. Some of the more demanding earlier tasks such as dimensional modelling may be done during normal class time with support from the lecturer.


In order to implement this Data Mart students are required to produce:


1.    At least four important business requirements, based on the identification of one or more important business processes, for the Data Mart. The OLTP system must be able to support these requirements.
2.    A dimensional model (using Star or Snowflake schema) for the Data Mart to support the business requirements.
3.    An SQL Script to create the Fact table(s) and the Dimension tables.

4.    An SQL script to extract data from the Sakila database and load it into the Data Mart
5.    At least 4 queries to demonstrate that the requirements are satisfied. Important to state any assumptions that are made.