DAT/380 Week 1 Individual Assignment distributed database for DreamHome Case

DAT/380 Week 1 Individual Assignment distributed database for DreamHome Case

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.

Submit the Microsoft Visio files to the Assignment Files tab.