Week 1 – dreamhome case study | DAT380 Advanced Database Architecture | University of Phoenix

 

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

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>