List all the functional dependencies found in the spreadsheet. List all the multi-valued dependencies found in the spreadsheet.
Assumptions
•No two makers produce a car with the same model
•The color does not play a part in the MSRP
•No two models within a make have the same price in a given year
•A given model in a given year may be offered in multiple colors
Spreadsheet Below:
Make Model Color Year Msrp
Honda Accord Red 1994 6999
Toyota Camry Silver 1994 5999
Acura Integra Green 1995 6999
Toyota Camry Blue 1994 5999
Toyota Camry White 1994 5999
Lexus ES 300 Silver 1993 8999
Subaru Legacy White 1992 4899
Toyota Camry Blue 1993 4366
Honda Civic Blue 1994 3999