A Zoo currently tracks its membership using a spreadsheet and wants to upgrade to using a relational database. You have been tasked with this conversion, and need to convert this flat field design into a relational database design.

The Zoo has given you its current spreadsheet design, which contains the following fields (columns).

• Member ID
• Member Name
• Member Address
• Member City
• Member State
• Member Zip
• Member Phone
• Membership Level Name
• Membership Level Description
• Membership Price
• Price w/tax
• Paid Until Date
• Member Since
• Event 1 Name
• Event 1 Description
• Event 1 Attended
• Event 2 Name
• Event 2 Description
• Event 2 Attended
• Event 3 Name
• Event 3 Description
• Event 3 Attended

The zoo has also given you the following business rules, which are incomplete and are not all necessarily structural.

• Members purchase a yearly membership.
• The memberships are one of three levels: Basic, Zoo Friend, and Zoo Star.
• Memberships are generally paid once a year.
• Three special events are offered each year, and attendance is tracked for each member.

Create a complete list of entities that you will need to include in your relational database design. This list should make provision for all data and business rules given to you by the Roger Williams Zoo, and there are many solutions that will correctly do so.