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 database2. Purpose of database3. Business goals and rules for database4. User requirements for database5. Data requirements for database6. Reporting requirements for database7. Estimated project schedule and project costs for creating the database and populating it with data8. Logical data model9. Data dictionary for all tables in data model10. 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
