object oriented data model and sql

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:

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

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.