wk 1 dreamhome case study due mon 1
* Needs to be completed in 2 days already overdue.
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 forDreamHome Case Study” ofDatabase Systems: A Practical Approach to Design, Implementation and Management.Design a distributed database forDreamHome 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 futureDreamHome-related Individual Assignments in Weeks Two, Three, Four, and Five.Submit the Microsoft® Visio® files.
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”