Computer Science Homework Help
Wk 1 – DreamHome Case Study [due July 15] Assignment Content Resource: Appendix A, “User Requirements Specification for DreamHome Case Study” of Database Systems: A Practical Approach to Design, Imple
Wk 1 – DreamHome Case Study [due July 15]
Get Your Custom Essay Written From Scratch
We have worked on a similar problem. If you need help click order now button and submit your assignment instructions.
Just from $13/Page
Assignment Content
-
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.
