In a short paper of one to three pages, discuss the various considerations and issues that are associated with data modeling requirements.
Be sure to address the following issues:
Major design issues that need to be addressed before proceeding with the data design.
Different approaches to dimensional modeling.
Hierarchies and categories as applicable to a dimension table.
Differences between dimension tables (wide) and fact tables (deep).
The star schema and component tables.
Data granularity in a data warehouse.
Three advantages of the star schema and any disadvantages of the star schema.
From the tools that are available for data modeling, identify the ones that would be the proper application for your project proposed in Unit 1. Your paper should open with a broad discussion of data modeling requirements and close with a summation of your points. The issues listed above can be addressed in short responses, consisting of one or two paragraphs each and introduced by headings.