University of Nairobi Data Warehouse Star Schema Paper

Using the star schema developed in Portfolio Milestone 1 – Option 1 in Module 3 and incorporating your instructor’s feedback, develop and execute the SQL commands to create the tables, define the variables and their attributes, and apply the constraints to your fact and dimension tables.

Your deliverable for this Portfolio Milestone is a report containing the following information:

• Changes to your business process, business questions, and fact table grain from Module 3
• Updated version of the star schema incorporating your instructor’s feedback
• Screenshot of fact and dimension tables
• Listing of SQL commands

Your paper should be three to five pages in length, organized and well-written, and in conformity with the CSU Global Writing Center (Links to an external site.).

In support of your response, cite and integrate at least one credible outside source, which can be your textbook. Place the sources in a reference page formatted in accordance with APA style. This reference page does not count toward the total page requirement. The CSU Global Library is a great place to find these resources.