Create a sample list of owners properties and services

Question

Assignment: Garden Glory

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.

Create the tables in SQL Server

PropertyName	PropertyType	Address	OwnerName	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
Samish	Park	EastPark	City	222-0030	City Hall
Westview	Park	WestPark	City	222-0030	City Hall

A. Create a sample list of 5 owners and 8 properties. Your list will be similar in structure to that in the Figure above. Use Excel to create the list.

B. Describe with data problems that are likely to occur if Garden Glory attempts to maintain the list in a spreadsheet as you have done in A.

C. 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.Use Excel to create the lists Create the same with SQL Server.

PropertyName	Type	Address	OwnerName	OwnerPhone	BillingAddress	Date	Desc	Charge
Jones Home	Residence	Elm St	E.J. Jones	223-1111	2nd Street	2/2/14	...	125.00
Eastlake Office	Office	Elm St	E.J. Jones	223-1111	2nd Street	2/7/14	...	78.44
Samish	Park	EastPark	City	222-0030	City Hall	2/2/14	...	99.50
Westview	Park	WestPark	City	222-0030	City Hall	3/7/14	...	224.99
Eastlake Office	Office	Elm St	E.J. Jones	223-1111	2nd Street	2/14/14	...	78.44
Eastlake Office	Office	Elm St	E.J. Jones	223-1111	2nd Street	2/22/14	...	100.00
Westview	Park	WestPark	City	222-0030	City Hall	3/14/14	...	224.99

D. Create a sample list of owners, properties, and services as shown above. Fill in the description for services as you create the list. Use Excel to create the lists.

E. Illustrate modification problems that are likely to occur if Garden Glory attempts to maintain the list from part D in a spreadsheet. Are these problems worse than what you found in B.

F. 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.Use Excel to create the lists and SQL Server to create the appropriate tables.

Format your assignment according to the following formatting requirements:

1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.

2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.

3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.