Please answer parts A, B, and C

Post by **answerhappygod** » Mon Jul 11, 2022 9:54 am

: Please Answer Parts A B And C 1 (174.02 KiB) Viewed 23 times

← Course: 2022 Summer ISDS (C) 30 x → !!!! (0) Ơ G ED A₁ 2022 Second Summer ISDS 3003 × P Garden Glory Project Questions X + C ☐ plus.pearson.com/products/bc2f4b6c-7822-46a1-a4d4-5604765046d8/pages/urn:pearson:entity:321eba5c-1dac-47c1-99cf-309f647c4232?user PreferredType=read&ticsCode=RfJRpxv19z X 83"F Partly sunny 129 Garden Glory Project Questions Figure 2-34 shows data that Garden Glory collects about properties and services. FIGURE 2-34 Sample Data for Garden Glory Eastlake Building Elm St Apts PropertyName Property Type Office Apartment Office Jeferson Hill Office Office Apartment Office Summary: The Relational Model Eastlake Building Eastlake Building Elm St Apts Eastlake Building H 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 ZIP ServiceDate Description 98119 5/5/2018 Lawn Mow 98223 5/8/2018 Lawn Mow 98040 5/8/2018 Garden Service 99119 5/10/2018 Lawn Mow 98119 5/12/2018 Lawn Mow 98223 5/15/2018 Lawn Mow 98119 5/19/2018 Lawn Mow A. Using these data, 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. B. Given your assumptions in part A, comment on the appropriateness of 129 Amount $ 42.50 $123.50 S 53.00 S 42.50 $ 42.50 $ $ $ 123.50 42.50 $ ^of B □ C CC 1:21 PM 7/10/2022 X ⠀
co Course: 2022 Summer ISDS (C) 3 63 2022 Second Summer ISDS 3003 X P Garden Glory Project Questions X → C ☐ plus.pearson.com/products/be2f4b6c-7822-46a1-a4d4-5604765046d8/pages/urn:pearson:entity:321eba5c-1dac-47e1-99cf-309f647c4232?userPreferredType=read&ticsCode=RfJRpxv19z U ED 83°F Partly sunny summary: The Real M Úwow sample date and also on the basis of what you know about service businesses. B. Given your assumptions in part A, comment on the appropriateness of the following designe 1. PROPERTY (Propertie, PropertyType, Street, City, ZIP, ServiceDate, Description, Amount) 2. PROPERTY (Propertyliame, Property Type, Street, City, 71P, Servicellate, Description, Amount) 3. PROPERTY (Propertyflame, Property Type, Street, City, ZIP, ServiceDate. Description, Amount) 4. PROPERTY (PropertID PropertyName, Property Type, Street, City, ZTP, ServiceDate, Description, Amount) 5. PROPERTY (Property, Propertylane, Property Type, Street, City, 21P, ServiceDate, Description, Amount) 6. PROPERTY (Property ID, Property Name, Property Type, Street, City, ZTP, ServiceDate) And SERVICE (ServiceDate, Description, Amount) 7. PROPERTY (Property, Property, Property Type, Street, City, ZIP, ServiceDate) SINGL SERVICE (Serviceto, ServiceDate, Description, Amount) 8. PROPERTY (Pre PropertyName, Property Type, Street, City, ZIP, ServiceDate) and: SERVICE (Serviceto, ServiceDate, Description, Amount, Property10) 9. PROPERTY (Property10, Propertyfame, Property Type, Street, City, IP) ATE SERVICE (Serviceto, Servicete, Description, Apunt, Property10) C. Suppose Garden Glory decides to add the following table: SERVICE FEE (Property10, ServiceID, Description, 4x □ C 1:22 PM 7/10/2022
← Course: 2022 Summer ISDS (C) 30 x G!!!! <0> 0 = 1 A4 X 2022 Second Summer ISDS 3003 × P Garden Glory Project Questions X + C ☐ plus.pearson.com/products/bc2f4b6c-7822-46a1-a4d4-5604765046d8/pages/urn:pearson:entity:321eba5c-1dac-47c1-99cf-309f647c4232?userPreferredType=read&ticsCode=RfJRpxv19z 83"F Partly sunny 130 Summary: The Relational Model Amount, Property ID) 9. PROPERTY (Property ID, Property Name, Property Type, Street, City, ZIP) and: SERVICE (ServiceID, ServiceDate, Description, Amount, Property ID) C. 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-34? If not, modify the design so that this data will work. State the assumptions implied by this design. H 130 (DALL ^? D c сс 1:22 PM 7/10/2022 X T