Question: How to make a ERD Diagram with information provided below? Heavenly Moon Ski Rentals Scenario Heavenly Moon Ski Rentals in Lake Tahoe, California, is located
How to make a ERD Diagram with information provided below?
Heavenly Moon Ski Rentals Scenario Heavenly Moon Ski Rentals in Lake Tahoe, California, is located in one of the best places in North America for skiing. Since 2108. Heavenly Moon Ski Rentals has been the up and coming location for the largest selection of skis, boots, snowboards, clothing, helmets, eye wear, and a variety of other accessories needed for the slopes. You have been employed by the company for the past three winters. 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 drivers 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 customers. OVERVIEW After completion of this graded activity, you should be able to understand the connections among entities, attributes, and relationships. This is a great way to better understand the basics as to how databases are designed - this is an assignment of your effort toward learning this important and one of the most challenging aspects of designing a database!! INSTRUCTIONS GRADED ACTIVITY HWB. Your job is to analyze the scenario above and demonstrate that you understand the process of ER modeling by developing your Entity Relationship Diagram (ERD) from the business rules mentioned in the scenario. Remember vour ERD should include Entities, its attributes, and the relationships between the Entities

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
