What is the primary key in this problem and the dependencies? I am trying to normalise the database.

The following business rules form the basis of the database design.

·         A member receives many invitations, and each invitation is sent to many members.

·         An invitation may be sent to different members on different dates. The date a member accepts an invitation is recorded.

·         Each invitation includes a dinner of a type, and a dinner type may apply to many invitations.

·         A dinner is based on a single entrée, but an entrée may be used as the basis for many dinners. For example, a dinner may be composed of a fish entrée, rice, tossed salad, and mixed vegetables. Or the dinner may be composed of a fish entrée, baked potato, vegetable soup, corn, and string beans.



The following table gives the attributes and sample values.

MEMBER NUM   MEMBER NAME   EMAIL ADDR  INVITE NUM  INVITE DATE
214                   Alice Hanz          ah@com                 8            2/23/04

ACCEPT DATE   DINNER CODE  DINNER DESCRIPTION ENTRà‰E CODE
   2/27/04                  D5                 sea delight                    E3


ENTREE DESCRIPTION
Stuffed crab

The attatched file shows the table.

Attached file(s):

table for database.doc  View File