Consider the following relational design of a Car Rental Service (the primary key of the relations have been underlined.Car (car_id, brand, rate, color, year)Driver (driver_id, driver_name, address, city, phone)Rental (rental_id, car_id, driver_id, rentaldate, rentedhours)
The relation Car stores the id of the car, brand of the car, per hour rate of the car and the color/year of the car. The relation Driver stores the id, name and address information of each driver registered with the Car rental service. The relation Rental stores the information when a driver rents a car. It stores the id of the car, id of the driver, the date when car is rented and the number of hours the car is rented.
Assume that there are 1,000 different cars, 1,000 drivers, and 1,000 rental records. The maximum rate is 1000 dollars and the minimum rent is 100 dollars.Create three new tables in your MySQL database for this scenario.https://internalservices.fit.edu/itresources/ (Links to an external site.)Populate them with junk data from https://www.mockaroo.com/ (Links to an external site.)Note: To limit the range of numbers, use a number data type and select a range. For primary keys, always use the row number type. For primary keys that are also a foreign key, use the number type within the set range (Rental will need this).
Looking for the best essay writer? Click below to have a customized paper written as per your requirements.