Task 1: Data Warehouse Design
Design a data warehouse for the above mention scenario. Implement your data warehouse with SQL Developer.
Prepare a report of your data warehouse design and demonstrate your design to your tutor.
Task 2: OLAP Queries
Based on your design, write down the queries for the following problem:
• How many trades were placed in July by customer “John Alan”?
MyAssignmenthelp.com is committed to provide top-notch quality academic assistance at affordable price. To help students from different backgrounds, we have hired more than 3000 experts. Owing to in-depth knowledge in their respective subjects, they effectively provide geography assignment help, Physics assignment help, Strategic assignment help, history assignment help, art architecture assignment help and much more.