Question: 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

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. What are the decisions you make regarding minimum and maximum cardinalities?

How would you validate the model in part B?

OWNED_PROPERTY PropertyID INT PropertyName CHAR(35) Property Type CHAR(25) Street CHAR(35) > City

OWNED_PROPERTY PropertyID INT PropertyName CHAR(35) Property Type CHAR(25) Street CHAR(35) > City CHAR(35) State CHAR(2) > ZIP CHAR(10) OwnerID INT Indexes EMPLOYEE EmployeeID INT LastName CHAR(35) FirstName CHAR(25) CellPhone CHAR(10) > Experience Level CHAR(25) Indexes HIT PROPERTY_SERVICE Property ServiceID INT > PropertyID INT ServiceID INT > ServiceDate DATE EmployeeID INT > HoursWorked DECIMAL(5,2) EMPLOYEE_EmployeeID INTO GG SERVICE_ServiceID INT OWNER_OwnerID INT Indexes OWNER OwnerID INT OwnerName CHAR(65) OwnerEmail Address VARCHAR(100) >OwnerType CHAR(25) Indexes GG_SERVICE ServiceID INT LH Service Description CHAR(35) CostPerHour DECIMAL (8,2) Indexes

Step by Step Solution

★★★★★

3.46 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Extend and modify the ER data model to meet Garden Glorys new requirements Use the IE Crows Foot ER model for your ER diagrams Create appropriate iden... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

A nurse mixes 50 cc of a 70% saline solution with a 30% saline solution to produce a 35% saline solution. How much of the 30% solution should he use?

The first production department in a process manufacturing system reports the following unit data. Beginning work in process inventory Units started and completed 30,400 units 45,600 units Units...

The Queen anne Curiosity Shop wants to expand its database applications beyond the current recording of sales. The company still wants to maintain data on customers, employees, vendors, sales, and...

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

WRITE THE full as if I had to start from scratch and create a new database using this data SQL SCRIPT FOR THIS USING MY PREV ER MODEL AND ALSO PROVIDE WHAT THE ER MODEL SHOULD LOOK LIKE WHEN ITS...

WRITE THE SQL SCRIPT FOR THIS USING MY PREV ER MODEL AND ALSO PROVIDE WHAT THE ER MODEL SHOULD LOOK LIKE WHEN ITS OUTPUTTED AND ANWER THE QUESTIONS property _ service PropertyServiceID INT PropertyID...

This case study assignment is based on (but not the same as) the Queen Anne Curiosity Shop (QACS) Case Questions at the end of Chapters 5 and 6. Since there are important differences between the...

James River Jewelry wants to expand its database applications beyond the recording of purchases and purchase awards. (See the description of the James River Jewelry Project done in part 01.) The...

After the last financial crisis, a company is obligated to make additional quarterly payments to an unfunded pension fund during the next 3 years. The future value of those payments is to be...

On January 1, 2012, Trikel, Corp., issued $600,000 of 8.375%, five-year bonds payable when the market interest rate was 10%. Trikel pays interest annually at year-end. The issue price of the bonds...

justo Ltd buys on terms 1.5/10, net 30 days. It does not take discounts, but it typically pays 20 days after the invoice date, instead of waiting until Day30. Justso can borrow from the bank at a...

Is this a correct option? B Taxpayer has a 4 5 7 plan from a former employer and has changed jobs. Taxpayer is unable to rollover the 4 5 7 plan into a Traditional IRA. This question may have more...

When Chinas clothing industry expands, the increase in world supply lowers the world price of clothing. a. Draw an appropriate diagram to analyze how this change in price affects consumer surplus,...

Suppose that in a year an American worker can produce 100 shirts or 20 computers, while a Chinese worker can produce 100 shirts or 10 computers. a. Graph the production possibilities curve for the...

Your firm wants to sell its product in each of several foreign countries, and you must decide whether to do so by exporting or by producing locally for that market through FDI. Suppose that in each...

E&Y is a defendant in Lehman-related lawsuits filed in both state and federal courts. Identify the factors that influence E&Ys legal exposure between lawsuits filed in state courts versus those filed...

The following are the financial statements for A. Tack for the years ended 30 June 20X3 and 20X2: Required Prepare a statement of cash flows in accordance with IAS 7 for A. Tack for the year ended 30...

5Draw a detailed flowchart that represents the sequence of operations in the described production and quality control process. The flowchart should include: All major production steps Decision points...

Reduce the decision table in Figure to the minimum number of rules. Conditions and Actions Rules 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Sufficient quantity on hand Quantity large enough Y Y Y Y N NN...

Cherry Jones owns a homeopathic medicine company called Faithhealers. She sells vitamins and other relatively nonperishable products for those who want choices regarding alternative medicine. Cherry...

Design a Web entry page for the Home Finders Realty Corporation display screen created in Problem 8.

What is reverse engineering? Give an example. Do you feel it is unethical?

Is designing products that are not refurbishable or recyclable, such as computers and electronics that end up in city garbage dumps, unethical? Discuss.

How has technology had an impact on product design?