a) Normalize the following table into first, second and third Normal form. Identify the primary key for each table and set the foreign key to link the table. (8 marks)

DINNER_MEMBER

Dinner No	Dinner Date	Dinner Time	Food Code	Food Description	Quantity	Member No	Member Name	Member Address	Member Phone
D10	12/12/2019	7 PM	EN1	Crab	4 2	200	Ali	Shinas	12345678
			EN3	Chocolate
D95	22/12/2019	8PM	EN5	Apple Pie	2	210	Ahmed	Sohar	56788989
			EN4	Pumpkin Soup	1
			EN1	Crab	2
D80	20/12/2019	9PM	EN4	Pumpkin soup	2	250	Khalid	Shinas	13574545
			EN2	Marinated Steak	2
D100	24/12/2019	7PM	EN5	Apple Pie	3	200	Ali	Shinas	12344545
			EN1	Crab	2

b) In the below given table, identify the correct table names & Keys after 3NF. (3 marks)

Table Name	Primary Key	Foreign Key (if any)

c) Draw the ERD after third normal form. (4 marks)

I want it in a hurry, please, I don't have time