Week 2 – Object-Oriented Data Model and SQL Query Definition

/in /by

Refer to the Week 1 – Required Learning Activity: Appendix A, Database Systems.

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:

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now
  • 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, “DreamHomeCase 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.

Submit the ZIP file.

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"
[promo2]