State Park Cabin Reservation System. Draw an ER diagram for the following case. The E-R diagram should include entities, attributes, identifiers, and relationships. In the diagram, place a textbox at the top-left corner of your diagram and type Made by FirstName LastName in the textbox .
Overall, the system allows customers to reserve cabins from a list of state parks. A customer is identified by its customer ID. Other attributes of a customer include first name, last name, email address, and phone number. A state park has a state park ID, name, and address (street, city, state, and zip code). A state park has several cabins. Each cabin has its cabin ID, facility description, bedroom number, max capacity, and daily standard price. One customer may reserve several cabins; and one cabin may be reserved by several customers. Each reservation should contain the customer ID, the cabin ID, the reserve date, the reserve time, the start date, the end date, adult number, and child number. It is up to your choice to have a reservation ID for each reservation (you choose whether to add a reservation ID). Please note that you should add proper foreign keys and choose identifying/non-identifying relationships.