Assignment Content
Top of Form
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.
Bottom of Form
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
