Develop a reasonable and realistic plan and outline the steps to accomplish the integrated project by the end of the course. You can also refer to Garden Glory project questions in §1~3 of the Textbook (at the end of each chapter).  

1. What are the modification problems that are likely to occur if Garden Glory attempts to maintain the list below in a spreadsheet?

2. Using these data presented in the list, state assumptions about functional dependencies among the columns of data. Justify your assumptions on the basis of these sample data and also on the basis of what you know about service businesses. Indicate what assumptions need to be checked with the users (GG) and what suggestions you may have about the determinants/keys (e.g., do you need a surrogate key?)

3. Based on the above analysis and assumptions, split the sample list into tables such that each has only one theme. Demonstrate that the modification problems you identified in E have been eliminated.

Transcribed Image Text:

PropertyName Eastlake Building Elm St Apts Type Office Apartment Office Office Office Apartment Office ZIP 98119 98223 Description Lawn Mow Lawn Mow Garden Service ServiceDate Amount 42.50 Street 123 Eastlake 4 East Elm 42 West 7th St 123 Eastlake 123 Eastlake 4 East Elm 123 Eastlake City Seattle Lynnwood Bellevue Seattle Seattle Lynnwood Seattle 5/5/2008 5/8/2008 123.50 Jeferson Hill 98040 5/8/2008 53.00 Eastlake Building. Eastlake Building Elm St Apts Eastlake Building 98119 98119 98223 5/10/2008 5/12/2008 5/15/2008 Lawn Mow Lawn Mow 42.50 42.50 Lawn Mow Lawn Mow 123.50 98119 5/19/2008 42.50 PropertyName Eastlake Building Elm St Apts Type Office Apartment Office Office Office Apartment Office ZIP 98119 98223 Description Lawn Mow Lawn Mow Garden Service ServiceDate Amount 42.50 Street 123 Eastlake 4 East Elm 42 West 7th St 123 Eastlake 123 Eastlake 4 East Elm 123 Eastlake City Seattle Lynnwood Bellevue Seattle Seattle Lynnwood Seattle 5/5/2008 5/8/2008 123.50 Jeferson Hill 98040 5/8/2008 53.00 Eastlake Building. Eastlake Building Elm St Apts Eastlake Building 98119 98119 98223 5/10/2008 5/12/2008 5/15/2008 Lawn Mow Lawn Mow 42.50 42.50 Lawn Mow Lawn Mow 123.50 98119 5/19/2008 42.50

Answer rating: 100% (QA)

1 Three types of modifications are likely to occur they are Updation of values in th... View the full answer