Reference no: EM132398018

Resources:

- Completed Week One Individual Assignment "DreamHome Case Study"

- Completed Week Two Individual Assignment "Object Oriented Data Model and SQL Query Definition"

- Completed Week Three Individual Assignment, "Database Operations and Data Recovery"

- Appendix A, "User Requirements Specification for DreamHome Case Study" of Database Systems: A Practical Approach to Design, Implementation and Management(6th edition).

Update the following DreamHome assignments:

- Diagrams from the completed Week One Individual Assignment "DreamHome Case Study"

- Diagrams from the completed Week Two Individual Assignment "Object Oriented Data Model and SQL Query Definition"

- Completed Week Three Individual Assignment, "Database Operations and Data Recovery"

Diagram a distributed database environment in Microsoft® Visio® using the "DreamHome Case Study" in Appendix A of Database Systems:

A Practical Approach to Design, Implementation and Management (6th edition) and your completed DreamHome-related assignments from Weeks One, Two, and Three.

Include the following in your diagram:

- A production database

- A data warehouse

- Two data marts

- Security and maintenance elements annotated in your first diagram

Create a 3-page summary in Microsoft® Word that:

- Identifies and discusses the database tables used to create your distributed database environment

- Identifies and discusses three SQL queries to develop reports from the data query list in the case study

- Explains the typical operation of a data warehouse and data marts, along with operational considerations and constraints

- Discusses how DreamHome could benefit from data mining and how OLAP and data mining applications could be applied to the DreamHome data model.

- Includes the SQL statements for each of the required queries and screenshots showing the query results

- A thorough explanation of the process you used to determine the data types used in each table

- An explanation of the most difficult process in designing and building the data and how organizations can overcome these difficulties

Submit the Microsoft® Visio® file of your annotated diagram and the Microsoft® Word file of your summary.