Question

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.

1. Create a sample list of owners and properties. Your list will be similar in structure to that in Figure 1-34, but it will concern owners and properties rather than owners and pets. Your list should include, at a minimum, owner name, phone, and billing address, as well as property name, type, and address.
2. Describe modification problems that are likely to occur if Garden Glory attempts to maintain the list in a spreadsheet.
3. Split the list into tables such that each has only one theme. Create appropriate ID columns. Use a linking column to represent the relationship between a property and an owner. Demonstrate that the modification problems you identified in part B have been eliminated.
4. Create a sample list of owners, properties, and services. Your list will be similar to that in Figure 1-35. Your list should include the data items from part A as well as the date, description, and amount charged for each service.
5. Illustrate modification problems that are likely to occur if Garden Glory attempts to maintain the list from part D in a spreadsheet.
6. Split the list from part D into tables such that each has only one theme. Create appropriate ID columns. Use linking columns to represent relationships. Demonstrate that the modification problems you identified in part E have been eliminated.

Answer 1

Hey, I've already answered this with thorough explanation. No problem I will try to explain it again. PLEASE LIKE THIS ANSWER, THANK YOU!

(a)

Name	Type	Address	Owner	OwnerPhone	BillingAddress
Jones Home	Residence	Elm St	E.J. Jones	223-1111	2nd Street
Eastlake Office	Office	Elm St	E.J. Jones	223-1111	2nd Street
Sammish	Park	East Park	City	222-0030	City Hall
Westview	Park	West Park	City	222-0030	City Hall

(b)

If owner phone changes, this will require changing multiple rows. If change made incorrectly, one row can disagree with another. Phone numbers could be entered inconsistently (see phone for E.J. Jones, above). No place to record owner if have no property for him/her.

(c)

PROPERTY:

Name	Type	Address	OwnerID
Jones Home	Residence	Elm St	100
Eastlake Office	Office	Elm St	100
Sammish	Park	East Park	200
Westview	Park	West Park	200

            OWNER:

OwnerID	Owner	OwnerPhone	BillingAddress
100	E.J.Jones	223-1111	2nd Street
200	City	222-0030	City Hall

(d)

Name	Type	Address	Owner	OwnerPhone	BillingAddress	Date	Desc	Charge
Jones Home	Residence	Elm St	E.J. Jones	223-1111	2nd Street	2/2/02	…	125.00
Eastlake Office	Office	Elm St	E.J. Jones	223-1111	2nd Street	2/7/02	…	78.44
Sammish	Park	East Park	City	222-0030	City Hall	2/2/02	…	99.50
Westview	Park	West Park	City	222-0030	City Hall	3/7/02	…	224.99
Eastlake Office	Office	Elm St	E.J. Jones	223-1111	2nd Street	2/14/02	…	78.44
Eastlake Office	Office	Elm St	E.J. Jones	223-1111	2nd Street	2/22/02	…	100.00
Westview	Park	West Park	City	222-0030	City Hall	3/14/02	…	224.99

(note: Desc is omitted from above because there’s no room to enter it. Assume some legitimate description has been entered.)

(e)

Same as answer for B, except is even worse because can involve service items as well.

(f)

PROPERTY (PropertyID, Name, Type, Address, OwnerID)
OWNER (OwnerID, Owner, OwnerPhone, BillingAddress)
SERVICE (ServiceID, Date, Desc, Charge, OwnerID, PropertyID)