Database design

Question # 00332021 Posted By: bigjane80 Updated on: 07/04/2016 02:51 PM Due on: 07/09/2016
Subject Computer Science Topic Programming Methods Tutorials:
Question
Dot Image

Garden Glory wants to expand its database applications beyond the recording of property services. The company still wants to maintain data on owners, properties, employees, services and the service work done at the properties, but it wants to include other data as well. Specifically, Garden Glory wants to track equipment, how it is used during services, and equipment repairs. In addition, employees need to be trained before they use certain equipment, and management wants to be able to determine who has obtained training on which equipment.

With regard to properties, Garden Glory has determined that most of the properties it services are too large and complex to be described in one record. The company wants the database to allow for many sub property descriptions of a property. Thus, a particular property might have sub property descriptions such as Front Garden, Back Garden, Second-Level Courtyard, and so on. For better accounting to the customers, services are to be related to the sub properties rather than to the overall property.

  1. Draw an E-R data model for the Garden Glory database schema shown in Chapter 3’s “Garden Glory Project Questions.” Use the IE Crow’s Foot E-R model for your E-R diagrams. Justify the decisions you make regarding minimum and maximum cardinality.
  2. Extend and modify the E-R data model to meet Garden Glory’s new requirements. Use the IE Crow’s Foot E-R model for your E-R diagrams. Create appropriate identifiers and attributes for each entity. Justify the decisions you make regarding minimum and maximum cardinality.
  3. Describe how you would go about validating the model in part B.

Present your results from parts A, B, and C in an illustrated narrative form, in a single Microsoft Word document.

Dot Image
Tutorials for this Question
  1. Tutorial # 00327577 Posted By: mac123 Posted on: 07/04/2016 02:55 PM
    Puchased By: 2
    Tutorial Preview
    The solution of Database design...
    Attachments
    Solution-00327577.zip (125 KB)

Great! We have found the solution of this question!

Whatsapp Lisa