Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Spomenik Monument Database

Authors: Donald Niebyl, FUEL, Damon Murray, Stephen Sorrell

1st Edition

0995745536, 978-0995745537

More Books

Students also viewed these Databases questions