Databse class. I need an ERD diagram done on visio using crows feet notation of the following scenerio listed . Please answer the following questions
FARMS Scenario Fry Properties, Inc owns 3 boutique hotels located in Northern Utah. So far, the company has managed to keep guest reservations and accounting "on the books using a manual spreadsheet system (see sample data below). However, the company would like to upgrade to a computerized database to keep better records and track reservation information for all their properties simultaneously. The new database will eventually be integrated into a new software package called The FARM (Fry's Accommodation and Reservation Management) System. Eventually the owners would like to host the FARM on the cloud, and offer online reservations. The web site will let guests browse the hotel information (including ratings, amenities, and a single picture of the front of the hotel), view room information (type, descriptions and rates), and make (or edit or cancel a reservation from the web. Before they can do this, however, they need to move away from their old manual spreadsheet way of doing things Here is more information about Fry Properties' business rules (which may or may not impact your data database storage design). Note some rules may have to be enforced with programming). That's not your job. You are to focus on (scalable data storage needs by designing the best relational database possible 8. Each reservation detail will have its own status (R", "A", "C" or "X). "R", the default, will mean reserved only, "A" for active (the reservation and room is active and the guest is currently checked-in), "C" for when the guest checks out OR when a cancellation penalty needs to be applied (#11), and "X" for cancelled without penalty when the cancellation occurs more than 48 hours prior to check-in (#11 9. The master reservation (which, remember can have multiple details see #6) will also have its own status (R", "A", "C" or "X") and comments. If any of its reservation details are still reserved (not yet active or compete) then the master reservation status will remain "R". When there is at least one Active reservation detail, and all the other details are complete or cancelled C" or "X") then the Master Reservation status will change to "A" for Active as well. If a master reservation is "X" cancelled, then all its R" reservations details are also automatically "X" cancelled or "C" Checked out with a penalty applied. If all details are (X" or "C"), hen the master reservation status changes to "C" 10. An additional discount may be applied to the quoted rate used in the reservation details There are many discounts to choose from. Some discounts have a percentage (like military 10%) and some have fixed rates (like coupons for $10 off). All discounts have an expiration date and comments (restrictions). The Default Discount "No Discount Applied", has a rate of 0% and an amount of $0
