Overview - Design and Implement a Data Warehouse for a Successful Olympic Performance consultant agency (SOPCA).
A data warehouse is an extremely useful tool that can be used for both analysis and analytics. You have been asked to design and implement a data warehouse for a company that assists coaches and Olympic teams worldwide. They have contracts with a number of national Olympic teams and individual athletes and they work hand in hand with the international Olympic committee.
Overview
SOPCA has commissioned you to design and implement a Data warehouse. The aim is to produce an example of a suitable data warehouse design that can be used to demonstrate to the agency the benefits to themselves and to the countries’ Olympic teams. The demonstrations of the data warehouse will include some visualization too.
You have been granted access to a large dataset of their historical data. The data are accessible in Moodle under the coursework heading. The data may need some cleaning before they can be used. There may be other tables and attributes that you consider are required. In this case, you are encouraged to add them as you see fit. Attribute types and sizes; it is up to you to decide on appropriate values.
Therefore your tasks are:
Task 1:
Define a Constellation schema. Your schema should cover two subjects (i.e. two fact tables). You must present your design as one constellation diagram (which is simply a collection of multiple fact tables which share dimension tables).
You are expected to create and populate further tables with dummy data, which will enhance the experience and rationale of the data warehouse. You can generate your own dummy data any way you see fit, for example using https://mockaroo.com/
The constellation diagram design must be created in MS Visio.
Task 2:
Create and populate the tables on your VMs using PostgreSQL or on SQL Developer Web using PL/SQL.
Task 3:
Write and run 4 SQL queries. Your queries must be meaningful and demonstrate the strength of DW in supporting decision makers. Also, your queries must cover all subjects in your DW. You should provide a short description of each query.
Your queries and your table creation and population should be on the same SQL version, for example if you use Oracle PL/SQL to create and populate the data warehouse, then you should use Oracle PL/SQL for your SQL queries.
Deliverables of this component is a report that contains:
You must submit 1 pdf document including:
a. Short description of your project: the report should explain your design decisions. [800 words max].
b. Your Constellation schema. It must be clear and readable.
c. Screenshots of each table creation query and insert data statement.
d. Screenshots of each query and its output along with a short description of each query that includes your rationale for creating the query. Your screenshots must be clear and readable. If the query and/or the result of the query are not clear and readable, zero will be awarded.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
