Categories
Writers Solution

DreamHome Case Study

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: