Please construct a Crows Foot EERD that is at least 3NF for the following business processes:

1.A university club wants to create a database to keep track of the members attending for dinner and their menu selection for each dinner. They will also like to keep track of the people that said that they are not attending.

2.The club has a list of members and sets out every year to construct and plan the years events. The member list contain name, address and phone.

3.Prior to each event, invitations are always sent to each member.

4.Members may RSVP with two choices, one that they will attend and another that they will not attend.

5.Members that decide to attend the event must RSVP with the number of total guests coming.

6.A member may decide not to attend even after sending a positive RSVP.

7.Each event has a menu and the same menu could be offered for another event.

8.A menu has of a list of dishes.

9.The kitchen decides the dishes served from choices of dishes already designed in advanced.

10.A dish is always composed of at least one and only one entre and one or many side possibilities.

11.The combination of entre and side possibilities are never repeated, they are given a dish name and no two sets of ingredients are the same.

12.Once the guests arrive, the invitation card most be presented. All attending members always present their invitations.

13.During the event a receiving person at the club collects the invitations and records names of guests along with their selection dish for dinner.

14.One guest can only select one dish for dinner.

15.One RSVP invitation may have one or many guests.