Assignment 1: XXXXXXXXXXDue date: 08/26/2020
By definition, a graduate-level research paper provides a discussion of the content in the scholarly article from peer-reviewed sources where research was performed using relevant keywords. Do a research on the UMGC li
ary for scholarly articles related to the below question, and then answer the below question.
Answer the below questions by providing 150 words for each.
2) Describe the importance of denormalization as part of data warehouse design (150 words).
3) Review the key roles involved in the design of a dimensional model such as data modeler, business analyst, business intelligence application developer, data steward, ETL developer, database administrator, security manager, data warehouse administrator. Select a role and define the tasks that this person performs (150 words).
4) Identify the importance of selecting the Grain of a data warehouse in the Kimball Data Warehouse Model. Provide examples of grains within a Data Warehouse (150 words).
7) Compare and contrast the models used for developing a data warehouse for unstructured data versus structured data (150 words).
8) Define the importance of ontologies for unstructured data warehouses. Provide an example of unstructured data and the use of an ontology used to manage this data (150 words).
9) Define the importance of indexes for unstructured data warehouses. Provide an example of unstructured data and the indexes that you would define to manage this data (150 words).
10) Identify design decisions that must be made as part of the ETL process. Describe the importance of these design decisions (150 words).
Grading ru
ic:
· APA formatting of each question including citations and references is worth 10 points. One point off for each e
or.
· Each scholarly article from peer-reviewed sources from the UMGC li
ary is worth two points for a maximum of 8 points.
· Content relevant to each question is worth 10 points. Distinguished (10), Advanced (8), Proficient (6), Basic (4), or Unacceptable (2).
· Question length between 100 and 150 words for the Content is worth 9 points, met (9) or unmet (0). The References section is not included in the word count.
· Proper spelling, punctuation, and grammar are worth 9 points. One point off for each e
or.
Warning:
Wikipedia and sites such as blogs are not scholarly sources and will result in a zero grade for APA citation and references. You should use the UMGC li
ary to perform graduate-level research for scholarly articles from peer-reviewed sources. Therefore, use only references from the UMGC li
ary for all research in this assignment. This assignment will be submitted to Turnitin; therefore, similarity index should be less than 10%.
UMGC Li
ay: https:
sites.umgc.edu/li
ary/index.cfm?_ga= XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
If it prompts you to login, use this
Username: saku
Password:
[email protected]