E-R Modeling Problem

Hi there, I need to solve the following problem in visio please. E-R Modeling Problem 1). Draw an E-R diagram for the following scenario using either the textbook or Visio notation. You should include all minimum and maximum cardinalities, all attributes described, and specify identifying attributes for all entities. All composite attributes should be decomposed. No derived attributes should be included in your diagram. (Worth 25 points). Reliable Rentals, a car rental company in Glasgow, Scotland, has hired you to design and develop a database. Reliable Rentals has various outlets throughout Glasgow. Each outlet has an outlet number, address, phone number, and fax number. Each site is allocated at least one vehicle to rent out and each vehicle is always assigned to one outlet. The registration number uniquely identifies each vehicle. Information stored on the rental vehicles includes: the vehicle registration number, model, make, and engine size. A lease agreement is recorded for each vehicle rental. A lease number uniquely identifies each lease agreement. The data stored on a lease agreement includes the lease number, lease start date, lease end date, lease amount, beginning mileage, and ending mileage. A lease agreement describes the rental of one car. If a customer rents more than one car, then a separate lease agreement is created for each car. Some rental vehicles have been leased many times while others have never been leased. Reliable Rentals also needs to store information about their customers. The data stored on customers includes the customer number, name, address, and phone number. The customer number uniquely identifies each customer. Sometimes customer information is stored before the customer actually leases a vehicle, and a customer can agree to many leases. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Visio 2000,2002,2003