Question

Can someone who knows how to draw data model on mySQL help me out?

Budget car rental company has offices located across the continental USA. They would like to track the local address ( all pieces address, state, city, zip),and the contact phone number for that office location. They would also like information about employees working at that office including their names, date of birth, start of employment, contract phone number, and roles. Offices typically have more than one employee and an employee works at a specific office location. Each office has a manager.

Budget would also track customer that rent cars from them. They would like to track the customer information such as name, address, contact info like phone and email, insurance info and payment( credit card info).

They also want to track their rental fleet which is rented out to the customer i.e. the cars being rented out. They wish to track info about the car make, manufature, model, year of car, date it was added to the fleet, VIN, license number, and state it was registered. They also wish to know the classification type of the car ( Economy, compact, intermedia, standard). Cars are typically associated with one and only one location and an office offers several cars to rent to the customers.

They wish to track the rental behavior of customers such as which car was rented out, the start date and time, end date and time of rental, the office location it was rented from and the office location it was returned to and the amount of payment on that rental. A car can be rented by many customers and customers can rent many cars from Budget.

During peak seasons Budget offers promotion on certain types of reservation allowing discount on the reservation for instance if it is made online 5% discount on the reservation price is offered. Budget would like to track the deal info such as promotion discount, promotion duration, and promotion name. Reservation can only have a single type of promotion apply to it but promotion apply to many reservations.

Draw a data model to accurately represent the situation.

Answer 1

PLEASE FIND THE ATTACHMENT BELOW