Module 13 Week 6 Dimensional Data Modeling Assignment

1. Dimensional Data Modeling Assignment

The data warehousing / data mart dimensional attached below. Copy the data model into a MS Word document. In your MS Word document. (You can copy the data model graphic by right-clicking on it. On PCs, the keyboard combination of ctrl-V is the shortcut command for pasting.) In the MS Word document, 1) identify the fact table 2) identify the dimension tables, 3) for each dimension table, identify the attribute(s) that would be matched to an attribute in the fact table, and 4) list four queries that could be produced from this data model. For example, the queries from a data model of real estate sales that could typically be produced by matching a fact table to one or more dimension tables include: a) list of properties sold by each real estate agent, b) total properties sold by state, c) types of properties sold by month and year, d) dollar value of properties sold by each real estate company, e) total homes sold by real estate agent by company by year.Video: Module 13 – Introduction to Data Warehousing (5:27 min.) youtube

2. Data Management Project: Final

Please make corrections to the draft of final project that you submitted to me. i attached copy below. Your final project must include the following elements:

1. Background of database – why you chose to design this particular database
2. Purpose of database
3. Business goals and rules for database
4. User requirements for database
5. Data requirements for database
6. Reporting requirements for database
7. Estimated project schedule and project costs for creating the database and populating it with data
8. Logical data model
9. Data dictionary for all tables in data model
10. SQL statements:
– CREATE TABLE statements (for entities defined in model)
– Minimum of two SELECT statements
– INSERT, UPDATE, or DELETE statements for at least one table
11. Identify the database management system (DBMS) software that will be used for the database
12. Specify the hardware for storing your database
13. Create a basic database back-up and recovery plan that is consistent with the business goals