Task Summary
This final assessment requires you to produce a robust and a flexible database that is able to accurately store information about the business mentioned in the case study. You also need to develop the queries and reports to provide data insights which in turn drive business decisions. Your submission should include:
a) Appropriate modelling plus any business rules or assumptions
b) SQL commands to
physically implement your logical model
populate the database
retrieve meaningful information
c) Visualizations that can be presented at a board meeting
Context
This assignment brings together all the learning gained over the duration of this subject. The skills and knowledge you've gained in this subject forms a vital part of your ability to traverse the major disciplines in the data and database fields. You will be able to interact with analysts, developers, database administrators and managers using a common language which is vital if an organization is to function effectively. These skills are the groundwork for further career progression in data analysis and information management.