IT$201$Database Design Class Activity

$*$IMPORTANT NOTES:

Recommended to be completed as a team of up to $5$ students. All team members need to submit the same team project in Canvas $$all team members MUST be listed on all copies of the assignment. I will provide all group comments and grades to each team member. List all names at the top of this assignment worksheet.

Download this worksheet and enter all of your responses on this worksheet in red font in the spaces provided. Upload the completed worksheet to Canvas when done.

$*$Be prepared to discuss your design decisions in class.

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.

$$ Ensure all your team member names are listed on the document and submit your results through Canvas.