zp ServiceDate Desc 98119 652014 awn Mow 8223 582014 Lawn Mow Eastake 9uidng 123
ID: 3747424 • Letter: Z
Question
zp ServiceDate Desc 98119 652014 awn Mow 8223 582014 Lawn Mow Eastake 9uidng 123 E astlake Seattle 73 Eastlake Seate 123 Eastlake Sealtle S42 50 123 50 8119 5/102014 Lawn Mow 12/2014 98223 51/2014 Lawn Mow 4250 ast Em Lywwood 981191 5/192014 Lawn Mo 123 42.50 data shown in the above table, state 2 functional dependencies that exist among the columns of data. Justify your assumptions EXAMPLE, page 85-86 is discusses how ObjectColor Shape and ObjectColor-> weight. B.) Given your assumptions in part A comment on the appropriateness of each design listed below (1-8) EXAM ANSWER: The above design is NOT GOOD. PropertyName does not determine the ServiceDate (REMINDER: Columns underlined are identified as the Primary Keys, columns that are italicized are foreign keys.) PLE - Question 1: PROPERTY (PropertyName Property Type, Street, City, Zip. ServiceDate, Description, Amount) 1. PROPERTY (PropertyName. PropertyType, Street, City, Zip, ServiceDate, Description, Amount) 2. PROPERTY (PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount) 3 PROPERTY (PropertyName PropertyType, Street, City, Zip.ServiceDate Description Amount) 4 PROPERTY (PropertylD. PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount) 5. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount) 6. PROPERTY (PropertylD. PropertyName, PropertyType, Street, City. Zip, ServiceDate) and SERVICE (ServiceDate. Description, Amount) 7. PROPERTY Propety D PropertyName PropertyType, Street, City. Z p ServiceDateland SERVCE Servic ID se ceo re Description, Amount, 8. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, Servicedate jand SERVICE (ServicelD, ServiceDate. Description, Amount, PropertylD 9. PROPERTY (PropertylD, PropertyName, PropertyType, Street, City, Zipjand SERVICE (ServicelD. ServiceDate, Description Amount PropertylD) C) Suppose Garden Glory decides to add the following table: SERVICE-FEE (PropertylD, ServicelD, Description, Amount) Choose which design you feel is best from above (question 8 1.9), Add the SERVICE FEE table to what you consider to be the best design in your answer to part B. Show the updated design. will the design you chose work for the data shown in Figure 2-34 above?Explanation / Answer
1) Zip->City.
Every City has certian Zips assigned to it. The Zip determines in which city that particular location is located. From data, we can see Settle has 98119 zip, Lyrewood has 98223 and Belluve has 98040 zip.
Property Name-> Office
Property names ending with Apts corresponds to Apartments and the rest correspond to Office.
2)
c)Number 9 will be most apt as both the keys ProperyId and ServiceId are present in SERVICE-FFE.
Updated Design:
PROPERTY(PropertyID, PropertyName, PropertyType, Street,City,Zip) SERVICE(ServiceID, ServiceDate) and SERVICE-FEE(PropertyID, ServiceID,Description, Amount)
We will remoce Description, Amount and PropertyID from the SERVICE table.
The design will work with the above data if we add ProperertyID and ServiceID
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.