DAT/380 Week 2 Individual Assignment Object-Oriented Data Model and SQL Query Definition for DreamHome Case
Consider any relevant feedback from your Week One Individual Assignment titled, “DreamHome Case Study” that will support the completion of this week’s assignment.
Create a data model for an object-oriented database in Microsoft Visio using the following resources:
The information presented in Appendix A, “User Requirements Specification for DreamHome Case Study” of Database Systems: A Practical Approach to Design, Implementation and Management (6th edition)
The distributed database created in the Week One Individual Assignment, “DreamHome Case Study”
Write a minimum of four queries for building the database structure and map to the data model.
Note: The results of this assignment will be used in future DreamHome-related Individual Assignments in Weeks Three, Four, and Five.
Compress the following files into a ZIP folder:
The Microsoft Visio file with the data model for an object-oriented database.
Microsoft Word file containing the SQL queries for building the database structure.