Assignment Content Resources: Completed Week One Individual Assignment "DreamHome Case Study"Completed Week Two Individual Assignment "Object Oriented Data Model and SQL Query Definition"Completed Wee

Assignment Content

1. 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.