Question
Construct a Crows Foot EERD (Enhanced Entity Relationship Diagram) that is at least 3NF (Third Normal Form) for the following business processes: 1. A university
Construct a Crows Foot EERD (Enhanced Entity Relationship Diagram) that is at least 3NF (Third Normal Form) 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 dinner choices (dishes).
9. A dish is always composed of at least one and only one entre and two or many side possibilities.
10. The combination of entre and side possibilities are never repeated, they are given a dish name and no two sets of entres and sides are the same.
11. Once the guests arrive, the invitation card most be presented. All attending members always present their invitations.
12. During the event a receiving person at the club collects the invitations and records names of guests along with their selection for dinner. One guest or member can only select one dinner selection for dinner.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started