Car Rental Locations

Database Creation and SQL Queries

I created my own database for a fictional car rental company in order to practice my SQL queries.

In the database, I created 3 tables:

  • car – stores info about the car (VIN_number, make, model, etc.)
  • storeLocation – stores info. about the physical location (address, phoneNum, etc.)
  • employee – stores information about the employees (name, hire_date, etc.)

I utilized multiple sources to create the datasets for these tables.  You can find my sources below.

You can find my data model as well as my queries below.