### Draw an e- r data model

Assignment Help Basic Computer Science
##### Reference no: EM13306511

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, and services, 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 ­particular p­roperty 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 ­cardinality.

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 cardinality.

#### Questions Cloud

 Compute the final temperature and pressure of the gas : A tank is divided into two equal chambers by an internal diaphragm. One chamber containes methane at a pressure of 500 bar and a temperature of 20 C, and the other chamber is evacuated. Find the angular speed of the wheel at higher temperature : A steel bicycle wheel (without the rubber tire) is rotating freely with an angular speed of 14.9 rad/s. What is the angular speed of the wheel at the higher temperature Design a payroll class : Write the appropriate accessor and mutator methods and a constructor that accepts the employee's name and ID number as arguments. How far apart must two 18 m diameter tanks be placed : How far apart must two 18 m diameter tanks be placed such that their stress overlap is not greater than 10% of the contact stress at depths of 10, 20, and 30 m Draw an e- r data model : 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 ­cardinali.. Write a program that displays the number of students : Write a program that displays the number of students that can still enroll in a given class. Design your solution using a multidimensional array. The first column can hold the computer course number. Write a program that displays employees : Suppose the weekly hours for all employees are stored in a two-dimensional array. Each row records an employee's seven-day work hours with seven columns. Determine a composite scs runoff curve number for basin : determine a composite scs runoff curve number for a 600acre basin that is totally within soil group C. the land use is 40% contoured row crops in poor hydrologic condition. 60% native pasture in fair hydrologic condition. How many kilograms of suspended solids are removed : The influent suspended solids concentration to a primary settling tank is 435mg/L. The average flow rate is 0.050m3/s. If the suspended solids removal efficiency is 60 percent, how many kilograms of suspended solids are removed

### Write a Review

#### List the complete reference-source information

List the complete reference-source information for where you found the EIA standard resistor value and tolerance information. 2) How was this reference discovered and where?

#### Explain specific challenges facing the designer

Discuss the specific challenges of facing the designer, specifically with regard to the limitations of hardware, software and interface design two paragraph each.

#### What is the general solution to handle such game trees

The min max algorithm cannot handle some games (even-with alpha-beta pruning) because of the depth of the search trees involved. What is the general solution to handle such game trees?

#### Explaining quasi-legal activities over internet

Online gambling and buying of pharmaceutical drugs over the Internet are quasi-legal activities which can only take place as Internet allows the parties offering gambling.

#### What frequency of radio waves corresponds to wavelength

Radio amateurs are allowed to communicate on "10 meter band." What frequency of radio waves corresponds to wavelength of 20m?

#### Designing a game system

Suppose that you are designing a game system that responds to players' pressing buttons and toggling joysticks. The prototype system is failing to react in time to these input events.

#### Find the smallest number ina group of three integer numbers

Write a set detailed, step by step instructions, in english, to find the smallest number ina group of three integer numbers.

#### Develop a model that can be described

Develop a model that can be described in yes/no (boolean) terms. Use boolean algebra, truth tables, or logic gates to describe this model. Attach a diagram or drawing to explain your concept.

#### A graph is two-connected iff

A graph is two-connected iff, removal of any single vertex and the edges adjacent to that vertex, leaves the graph connected. How can we tell if a graph is two-connected? Explain your algorithm in English

#### Why are organizations important to continual learning

Why are professional organizations important to continual learning? What professional organizations benefit both the employee and the employer.

#### Reason for problem encounter in deleting path variables

Discuss some of the problems he may soon encounter and explain the reasons for these problems. How could he easily return path to its original value?

#### Write a usable code snippet that demonstrates an iterator

A client of K & R has come to you for information regarding loops, iterators, and arrays. He needs you to help him comprehend these concepts. To assist this client, briefly address the following in a 1-2 page Notepad document.