Draw an e-r data model for the garden glory database schema

Assignment Help Database Management System

Reference no: EM132633601

Garden Glory wants to expand its database applications beyond the recording of prop-erty 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 subproperty descriptions of a property. Thus, a particu¬lar property might have subproperty 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 subproperties rather than to the overall property.

A. 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 cardinalities.

B. 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 cardinalities.

C. Describe how you would go about validating the model in part B.

Reference no: EM132633601

Questions Cloud

Relationship between negotiators affect negotiating process : Up to this point, we have described the negotiation process as though it occurred between two parties who had no prior relationship

What is special event security : Develop a paper on Special Event Security. What are the steps taken to secure a large-scale event? What is Special Event Security?

What are some effective arts-based strategies : What are some effective arts-based strategies for formatively and summatively assessing student learning?

Make journal entry to record the transfer of completed units : Make a Journal entry to record the transfer of completed units to the next department. How to Prepare Cost of Production Report.

Draw an e-r data model for the garden glory database schema : 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

Why is randomization important in clinical research : Why is randomization important in clinical research? How can researchers reduce the effect of bias?

Develop to enhance citizen participation in digital age : What policies might you develop to enhance citizen participation in the digital age?

What determines the amount deducted : In 130 Characters or more explain what determines the amount deducted from an employee's wages for Federal Income Taxes

Analysis of competing hypotheses process : This discussion looks at bias in the Analysis of Competing Hypotheses process. Do you agree that ACH cannot overcome bias?

User Account

All Pages