Answer Happy

Page 3 Question 3.(12 points) Read the following scenario and draw a correct Entity. Relationship Diagram. Your ERD must include all entities and attributes mentioned in the scenario. Do not create new attributes, but you may create keys if necessary. Use the correct symbols and rules for entities, attributes, identifier (key) attributes, relationship line(s), minimum cardinality, and maximum cardinality Evo is a Vancouver-based mobile car rental business with a fleet of over two hundred Toyota Prius vehicles. Only members can rent a car from Evo. Members enjoy the ability to start and end a rental easily, and many members find it so convenient they rent an Evo several times per month. Members give their name, address, and driver's license number when registering with Evo Each Evo vehicle is identified by its Vehicle_ID number because the license plate number might change. The model year and odometer reading are recorded for each vehicle. A rental can be as short as one minute or as long as several days (assume the rate is charged per minute). Since most rentals last less than one hour, each vehicle can be rented multiple times in a day. When a member rents a vehicle, the date, start time, and rental duration are recorded. A rental can only be associated with one member and one vehicle at a time. Draw your ERD below the line. Please ensure it is neat and legible.