Database Design Scenarios:

Your team will be required to design a database for one of the following scenarios:

a$)$ Car Dealership $$selling both new and used cars.

b$)$ Commercial Parking Lot $$provides both long term and short term parking by the airport.

c$)$ Car Museum $$displays rare, vintage, and famous race cars.

d$)$ RideShare Car Inventory $-$provides leased cars to drivers and keeps track of driver owned cars available for rides.

e$)$ Race Track $$keeps track of participants$$ vehicles for different races and any garaging requirements.

Required:

For your team$$s database scenario:

$1.$ Identify what major items of data needs to be stored inside each database.

$2.$ Classify the data into separate groupings or category of data.

$3.$ Design a separate database table to hold each separate data grouping complete with column headings.

For example:

$1.$ Data Items: customer name, customer outstanding balance, car color, and car make.

$2.$ Data Groupings: Customer, Car

$3.$ Customer $($customer$\_$name, customer$\_$balance$)$

Car $($car$\_$color, car$\_$make$)$

Put Your Design Here:

$1.$ Data Items: list your data items here

$2.$ Data Groupings: list your data groupings here

$3.$ Table Designs: list your table designs here

LAB CHECKLIST:

$$ Make it clear to which question in the assignment your answer lines up with $$put your answers in the locations indicated on the worksheet.