Question: Database question: The table below represents some sample data from a spreadsheet kept by a local car dealership for their inventory tracking. Review the table
Database question:


The table below represents some sample data from a spreadsheet kept by a local car dealership for their inventory tracking. Review the table and assumptions below, then answer the exercise questions that follow color yea msip make model Honda Accord | Red 1994 |?999 Toyota Camry Acura Integra Toyota Camry Toyota Camry LexusES 300 Silver 1993 8999 Subaru Legacy White 1992 4899 Toyota Camry Blue 1993 4366 Honda Civic 1994 5999 Green 1995 |6999 1994 5999 White 1994 5999 Blue Blue 1994 3999 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 The table below represents some sample data from a spreadsheet kept by a local car dealership for their inventory tracking. Review the table and assumptions below, then answer the exercise questions that follow color yea msip make model Honda Accord | Red 1994 |?999 Toyota Camry Acura Integra Toyota Camry Toyota Camry LexusES 300 Silver 1993 8999 Subaru Legacy White 1992 4899 Toyota Camry Blue 1993 4366 Honda Civic 1994 5999 Green 1995 |6999 1994 5999 White 1994 5999 Blue Blue 1994 3999 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
