Assignment Task - MIS602 - Data Modelling and Database Design Assignment

This final assessment requires you to produce a robust and 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 form 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.

Case Study

Please read the attached MIS602_Assessment 3_Case Study.

1. Database Case Study Report: Based on the information provided in the case study, create a functioning database using MySQL that can be queried to meet the requirements of the business.

2. The database case study report should include the following elements: a) ER diagram, relational model, and associated business rules and assumptions b) SQL commands to:

   • Create tables and insert sample data rows into each table
   • SQL queries to provide business insights. At least one of each of the following is required:
     • SELECT query with a condition
     • GROUP BY query
     • JOIN query
     • NESTED query

For each query, explain its business value, i.e., what business question does the result answer? Does it save money/more efficient process?