Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services. Figure 2-32 shows data that Garden Glory collects about properties and services. Suppose Garden Glory decid
Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services.
Figure 2-32 shows data that Garden Glory collects about properties and services.
- Suppose Garden Glory decides to add the following table:
SERVICE-FEE (PropertyID, ServiceID, Description, Amount)
Add this table to what you consider to be the best design in your answer to part B. Modify the tables from part B as necessary to minimize the amount of data duplication. Will this design work for the data in Figure 2-31? If not, modify the design so that this data will work. State the assumptions implied by this design.
![FIGURE 2-31
Employee Salary
64,000.00
70,000.00
70,000.00
64,000.00
64,000.00
58,000.00
70,000.00
58,000.00
ProjectID
100-A
EmployeeName
Eric Jones
Donna Smith
Donna Smith
Eric Jones
Eric Jones
Eric Parks
Donna Smith
Eric Parks
Sample Data for
Regional Labs
100-A
100-B
200-A
200-B
200-C
200-C
200-D](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F788dab94-01ba-414a-9745-8d14d9dc9223%2Fbf50852c-74ff-4df1-b215-d9aec6fa78f4%2Fkpysmlg_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)