Use the following information to draw an entity relationship diagram. You must label all entities and relationships including primary keys(which should be underlined), indicate cardinality for all relationships and clearly define any assumptions. Your ERD should fit on an 8 by 11 sheet of paper. On a second page, write each entity and below it list all of the fields. Any relationships that have data associated with them should also be listed. You should use a drawing program of some sort and turn in a pdf of your assignment on Blackboard. Any handwritten or illegible assignments will not be graded and will receive a 0. Design a database for a car rental company. You must include information about the cars, the people who rent cars and the dates of each rental. Additional information cars come in different size categories, for example sub-compact, compact, mid-size and so on cars have different makes, models and colors year car must have a model year and store current mileage all cars have basic things like (but not limited to) radio, cd player, air conditioning, power steering, anti-lock brakes if a car has any extra amenities, like a navigation system, that should be noted a user should be able to search for a size, a make, a model and any combination of those customers must include a name and phone number and a mailing address, additionally they should also be allowed to provide an email address, a cell phone, and be able to store credit card information each month all the cars that have more than 25,000 miles, and are not currently rented to someone are offered for sale to all customers who have provided an email address once a year (typically in the spring) all customers will be mailed a flyer reminding them the company sells the cars after they have 25,000+ miles on them