wk-1-dreamhome-case-study-due-july-15-assignment-content-resource-appendix-a-u

Wk 1 – DreamHome Case Study [due July 15]

Assignment Content

1. Resource:

   • Appendix A, “User Requirements Specification for DreamHome Case Study” of Database Systems: A Practical Approach to Design, Implementation and Management(6th edition).

   Review the “User Requirements Specification for DreamHome Case Study” of Database Systems: A Practical Approach to Design, Implementation and Management.

   Design a distributed database for DreamHome and illustrate it in Microsoft® Visio®.

   Include the following in your database:

   • Models representing the conceptual, logical, and physical database designs
   • Annotations identifying the appropriate elements. For example, the Physical Model annotations would include design base relations; identification of primary keys, foreign keys, and alternate keys; some data definitions (NOT NULL); relational integrity constraints; and general constraints

   Note: The results of this assignment will be used in future DreamHome-related Individual Assignments in Weeks Two, Three, Four, and Five.

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now