Discuss the below:
Q: 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
|
ACCEPT DATE
|
DINNER CODE
|
DINNER DESCRIPTION
|
ENTRÉE CODE
|
ENTREE DESCRIPTION
|
|
214
|
Alice Hanz
|
ah@com
|
8
|
2/23/04
|
2/27/04
|
D5
|
Sea Delight
|
E3
|
Stuffed crab
|
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 ENTREE CODE
2/27/04 D5 sea delight E3
ENTREE DESCRIPTION
Stuffed crab