normalisation to 3nf. Illustrate a crow's foot ERD notation

Jadual/ Table 1 : LUNCHEON Sample Value Attribute Name MEMBER NUM MEMBER NAME MEMBER ADDRESS 214 Sample Value 235 Asni Tahir UCA3, Sepangar, 84000 Sample Value 214 Chin Pel Yee The Light Residences, 83000, Nosoon Hungab 3-Dec-1985 0109826556 8 23-Dec-2020 27-Dec-2020 Yes LU5 15-Jan-2021 Glowing sea delight EN3 Salmon, rice, and soup MEMBER DOB MEMBER HP INVITE NUM INVITE DATE INVITE ACCEPT INVITE ATTEND LUNCH CODE LUNCH DATE LUNCH DESCRIPTION ENTREE CODE ENTREE DESCRIPTION 21-June-1980 0123031234 9 24-Dec-2020 28-Dec-2020 Yes LU5 15-Jan-2021 Glowing sea delight EN3 Salmon, rice, and soup Suraya Allas Inanam Condominium, Inanam, 82304 10-May-1982 0164423333 10 25-Dec-2020 27-Dec-2020 No LUZ 12-Mar-2021 Ranch Superb EN5 Marinated steak, baked potato, and salad. RM42.90 DE2 Apple ple RM7.90 ENTREE_PRICE DESSERT CODE DESSERT DESCRIPTION DESSERT PRICE RM35.90 DE4 Chocolate mousse RM8.90 RM35.90 DE5 Cheese cake RM9.90 a) Kenalpasti dan tunjukkan proses normalisasi ke atas Jadual 1 LUNCHEON kepada Third Normal Form (3NF). Tuliskan skema relational bagi semua jadual yang telah dinormalisasikan, dengan menyatakan kekunci utama dan kekunci asing. Identify and demonstrate the normalisation process for the Table 1 LUNCHEON to Third Normal Form (3NF). Write the relational schema of the normalised tables, indicating the primary and foreign keys. 32 (18 markah/marks) b) Ilustrasikan gambarajah ERD notasi Crow's Foot menggunakan jawapan anda di (a). Illustrate a Crow's Foot ERD notation using your result in (a). (12 markah/marks)