Please create ER Diagram, using ER Assistant or another program of your choice (visio, draw io), for the project databases. You should create a reasonable set of attributes for all the entities and for the relationships. You may also add additional relationships and entities to make the database more complete.

You can submit this in a word file with a picture of your er diagram (from wherever you created it) in visio or ER assistant or other.

You should include in the word document any assumptions or thoughts you had while creating the ER diagram.

Ruto Car Rental Case This document summarizes the information you received when visiting with the Ruto Car Rental team. The Car Rental team is a startup organization that has asked for your help. Thanks for agreeing to help with the IT problem of the Car Rental Startup company. They are growing and until now have been able to operate using an Excel spreadsheet. Unfortunately, they had a number of errors recently because there were incorrect charges and angry customers. They can't afford to use a commercial system, so they have engaged you, students, to build a simple database system. The startup team believes they need something that is called a "database" to help them collect, store, organize and retrieve the data. Background The startup team are young and have trouble renting cars under 25 years of age. They have the idea like AirBnB where people can rent their cars when they are not in use. They know from experience that people who own cars in the city, it is a great expense and they often sit idle. The increased popularity of smartphones has enabled the growth of services such as shared taxis (uber), and the startup team thought that car sharing could be a viable business as well. Working with some friends and techies, they decided to create a sharing service to connect car owners with people who want to rent cars (at a cheaper rate than car rental companies and with a wider variety of cars (ie. motorcycles, SUVs, RV, sedans) for a short time. Before they can get funding for the business, however, they must prove to the investors that it will be successful. To prepare for their first meeting with potential investors, they need to create an ER diagram showing the database layout of how data will be stored. You met with the team to figure out how the business works and how to support it with a database system. The vision is that automobile owners will register with the business and provide information such as the type of car they want to rent out (SUV, Sedan, Convertible, Truck, Motorcycle, RV), its brand, and its seating capacity (numeric). The thinking is that the owner should set the price of the rental and that will be shared in the app with rentals available at a daily rate. For example, an SUV with three rows of seating can be $150 per day, where a sedan may be $50 per day. To make the business worthwhile, the team thinks the owner should give the business a cut of the rental income, but the percentage can vary by car. Potential renters can register with the business for free and then browse the selection of cars that are available for rent. The startup team is hoping that many people across the country will register as potential renters. Each renter's contact information will be recorded, along with information about the car they rent and the starting and ending dates of the rental. After the database is setup, queries and data updates will be required (part 4 of the project). The questions the database will answer will be developed over the project. These questions will become the queries you set up for demonstration purposes. First, drivers will have to provide their driver's license information in case the renter wants to check their driving history. The startup team believes that users of the database will want to search for cars in different ways. For example, car renters might be interested in number of passenger seats or type of car, motorcycles and RVs can also be rented. The startup team also thinks car owners may need to be able to change rental prices for different types of cars. This can be achieved with an update query (part 4 of the project) that changes the rental price of one type of car so investors comprehend the power of the database system. The investors need to know how much money car owners can make from the rentals (also a query in part 4 of the project). Later you will be tasked with creating a query that calculates the amount of money earned by each car owner. As additional support for the business, the startup team will want to include queries that list the number of days each car is rented and the number of times each car is rented. Finally, the team will be able to create a query that summarizes all car rentals (another query in part 4 of the project). Cars will have to be parked in Parking Garages so the transfer of keys can take place by a reliable source. Parking Garages and their location and contact details will also be stored in the system. Cars There will be cars that will be kept track of, they will have owners, there are different types and sizes of cars and different charges on a per day basis for the cars. Cars are parked in parking lots, but can be picked up in one lot and dropped at another parking lot. There will be a charge if pickup and drop off location is different. Type of vehicle (SUV, sedan, RV, motorcycle), rental price per day, where it is located for pickup, number of passenger seats in addition to driver will all have to be tracked. Owners There are owners of the cars. One owner can own many cars or vehicles (including motorcycles and RVs), they usually have a home parking lot location. Owners will agree with the startup company what their percentage will when a car is rented. This can vary by car. Example, if I own a Suburban SUV with a third row of seats and an Audi convertible two-seater, the suburban rents for $150 a day and the Audi rents for $75 a day. The percentage on the suburban may be 10% so I get $15, but the percentage on the Audi may be 15% so I get $15. The Owner will have a home base parking garage where they normally park their vehicles. Renters Renters can rent cars for any length of time. Their contact information will be recorded along with driver's license information. Rentals Rental activity will be recorded to keep track of length and frequency of car rentals. Rental information to be maintained will be location/Garage it is to be picked up and the location/Garage drop-off location, because there will be an additional charge for a different drop off location, thus need keep track of drop off location. In addition, length of car rental will be computed by the start date of the rental and end date of the rental, who rented it and what car or vehicle was rented. Parking Garages Car owners offering their cars on the app will be required to keep their cars in Parking Garages to ensure a safe transfer of keys and sign-out of vehicle with the parking garage attendant. There will be time where the renter will take the car to another Parking Garage for drop-off. The team is thinking they need to keep track of pickup and drop off locations of rental and the car will always have its location tracked with the car. Therefore, the system will maintain the name of the parking garages, the addresses including street, city, state, zip, and contact info email and phone. There will be an additional charge for pickup and drop-off in different city and higher charge for different state