D1: DB Project Analysis & Query: 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. How could a well-managed database help the company better achieve its goals? Hint: refer to Text Chapter 1 for "Advantages of database approach " and apply that understanding to the GG project case 2. What are the modification problems that are likely to occur if Garden Glory attempts to maintain the list below in a spreadsheet? Street 123 Eastlake 4 East Eim 42 West 7th St Bellevue 123 Eastlake 123 Eastlake 4 East Elm 123 Eastlake Type ZIP ServiceDate Description Amount Prope Eastlake Building Office Elm St Jeferson Hill Eastlake Bui Eastlake S 42.50 S 123.50 98040 58/2008 Garden Service S53.00 S 42.50 S 42.50 S 123.50 42.50 Seattle 98119 55/2008 Lawn Mow 98223 5/8/2008 Lawn Mow artment Office Office Office Seattle Seattle 981 191 5/10/2008 Lawn Mow 98119 5/12/2008 Lawn Mow 98223 5/15/2008 Lawn Mow 981195/19/2008 Lawn Mow artment Office Eastlake Seattle Hint: refer to Text Chapter 1 for " Modific ms " and apply that understanding to the GG project case 3. 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?) ? Hint: refer to Text Chapter 2 for " Functional Dependency " and apply that technique to the GG project case 4. 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 Hint: refer to Text Chapter 2 for "Normalization Process" and apply that technique to the GG project case. You can also refer to the 9 possible designs provided in the GG Project Questions section at the end of Chapter 2 in Text book, on pp.129-130, and choose the best one you believe. D1: DB Project Analysis & Query: 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. How could a well-managed database help the company better achieve its goals? Hint: refer to Text Chapter 1 for "Advantages of database approach " and apply that understanding to the GG project case 2. What are the modification problems that are likely to occur if Garden Glory attempts to maintain the list below in a spreadsheet? Street 123 Eastlake 4 East Eim 42 West 7th St Bellevue 123 Eastlake 123 Eastlake 4 East Elm 123 Eastlake Type ZIP ServiceDate Description Amount Prope Eastlake Building Office Elm St Jeferson Hill Eastlake Bui Eastlake S 42.50 S 123.50 98040 58/2008 Garden Service S53.00 S 42.50 S 42.50 S 123.50 42.50 Seattle 98119 55/2008 Lawn Mow 98223 5/8/2008 Lawn Mow artment Office Office Office Seattle Seattle 981 191 5/10/2008 Lawn Mow 98119 5/12/2008 Lawn Mow 98223 5/15/2008 Lawn Mow 981195/19/2008 Lawn Mow artment Office Eastlake Seattle Hint: refer to Text Chapter 1 for " Modific ms " and apply that understanding to the GG project case 3. 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?) ? Hint: refer to Text Chapter 2 for " Functional Dependency " and apply that technique to the GG project case 4. 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 Hint: refer to Text Chapter 2 for "Normalization Process" and apply that technique to the GG project case. You can also refer to the 9 possible designs provided in the GG Project Questions section at the end of Chapter 2 in Text book, on pp.129-130, and choose the best one you believe