DATABASE

Business rules:

• a member receives many invitations and each invitation is mailed to may members.
• a lunch is based on one main meal entree and one dessert entree but a main meal entree and a dessert entree may be used as the basis for many lunches
• each lunche serve many members and each member may attend many lunches

ATTRIBUTES NAME	SAMPLE VALUE	SAMPLE VALUE	SAMPLE VALUE
MEMBER_NUM	123	456	789
MEMBER_NAME	ALLY CHEN	JENNY STYLE	JEERY LIM
MEMBER_ADDRESS	20 ABC STREET	10 BEVERLY HILLS	10 CDE STREET
MEMBER_DOB	10-JAN-1999	9-MAR-1989	1-JAN-1990
MEMBER_HP	010987652	018765429	01863975
INVITE_NUM	10	11	12
INVITE_DATE	12-DEC-2020	13-DEC-2020	14-DEC-2020
INVITE_ACCEPT	20-DEC-2020	21-DEC-2020	20-DEC-2020
INVITE_ATTEND	YES	YES	NO
DINNER_CODE	KI1	KI1	KI6
DINNER_DATE	30-DEC-2020	30-DEC-2020	1-JAN-2021`
DINNER_DESCRIPTION	HAPPY DAY	HAPPY DAY	DELIGHT DAY
ENTREE_CODE	QA1	QA1	QW1
ENTREE_DESRIPTION	CHICKEN,RICE AND SOUP	CHICKEN RICE AND SOUP	SALMON RICE AND SALAD
ENTREE_PRICE	30 DOLLARS	30 DOLLARS	5O DOLLARS
DESSERT_CODE	ZA2	ZA3	CA2
DESSERT_DESCRIPTION	STRAWBERRY CAKE	STRAWBERRY CAKE	CHICKEN PIE
DESSERT_PRICE	20 DOLLARS	20 DOLLARS	30 DOLLARS

Identify and demonstrate the normalisation process for table 1 to one normal form(1NF), second normal form(2NF) and third normal form(3NF). write the relational schema of the normalised tables, indicating the primary and foreign keys. Then, ILLUSTRATE a Crow's Foot ERD notation using the answer above