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”?
Do you need nursing assignment help in Australia? Or are you looking for programming language assignment help? No matter which subject you need help with, you can call MyAssignmenthelp.com, and we assure that we will provide you with a high quality assignment within the stipulated deadline at unbelievable prices. We also offer finance assignment help, hr assignment help and IT assignment help.