Example of how it should look like https imgur com a PMw0r9z Instructions (READ) Use Microsoft Visio or Draw io to draw the diagram Diagrams made by any other tools will not be graded Use IE (crow's foot) notation Diagrams with any other notations will not be graded The diagram should specify entities, keys, attributes, relationship types (identifying or non identifying), and cardinalities (MAX and min on each side) Divide an attribute further into simple attributes when appropriate All many to many relationships, if any, should be converted into associative entities (the answer should not have many to many relationship) Relationship labels are not needed Use a specialization hierarchy when appropriate Grading is based on the completeness of the diagram 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 (5 points) 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

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on May 18, 2024

Example of how it should look like: https://imgur.com/a/PMw0r9z Instructions (READ): Use Microsoft Visio or Draw.io to draw the diagram. Diagrams made by any other tools

Example of how it should look like: https://imgur.com/a/PMw0r9z

Instructions (READ):

Use Microsoft Visio orDraw.io to draw the diagram. Diagrams made by any other tools will not be graded.
Use IE (crow's foot) notation. Diagrams with any other notations will not be graded.
The diagram should specify entities, keys, attributes, relationship types (identifying or non-identifying), and cardinalities (MAX and min on each side). Divide an attribute further into simple attributes when appropriate. All many-to-many relationships, if any, should be converted into associative entities (the answer should not have many to many relationship). Relationship labels are not needed. Use a specialization hierarchy when appropriate. Grading is based on the completeness of the diagram.

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 (5 points).

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.