Business Intelligence
Task
Discuss 2 issues that may be problematic in the creation of the data warehouse that is apparent from the description above. For both, explain what you see as being the issue, why it is problematic, and what you will suggest needs to be done. This should take no more than two (2) pages in total.
Based on the list of questions the client wants to be answered, discuss what you see as being the most appropriate level of granularity for your data warehouse. Your discussion will need to explain why you have made this choice, and why the alternatives have been discarded. This should take not more than 1 page.
Assuming that the issues you have raised in TASK 1 have been addressed to your satisfaction, design a Star Schema that will support the analyses as listed above.
Provide the SQL statements you would use to create the tables if you were to be implementing this design using Oracle