Slopeside Ski Rentals Vail Resort in Vail, Colorado, is internationally known as one of the best places in North America for skiing. Since 1973, Slopeside Ski Rentals has been a tradition in the area. At Slopeside Ski Rentals, customers will find the largest selection of skis, boots, snowboards, clothing, helmets, eyewear, and a variety of other accessories needed for the slopes. You have been employed for the past three winters by the company.
Recently, there has been a surge in business, and the owners need a more accurate way to manage the rental business. You have decided to create a database to help the owners keep track of the ski rentals, who the customers are, amount paid, and any damage to the skis when they are rented. The skis and snowboards vary in type, size, and bindings.
When customers rent equipment, they are required to leave their driver's license number and to give a home address, phone number, and credit card number. A few business rules that you are aware of include:
¦ A customer can rent one or more skis or snowboards at one time.
¦ Skis and snowboards can be rented by many customers.
¦ A ski or snowboard need not be assigned to any customer. Your job is to develop an ERD from the business rules mentioned here.