23-A. Normalize the following table into first, second, and third normal forms. Identify the primary key for each table and set the foreign key to link the table. (8 marks) FOOD COURIER FoodID FName Price PrepTime CourierID CName DateDelivered FoodType RestoID RestoName DM-1 Pepperoni 5.5 30 mins C1 Ahmed 1/12/2020 Pizza 1 Dominos C2 Abud 5/12/2020 KF-1 Zinger 10 20 mins C3 Hamood 2/12/2020 Meal 3 KFC C2 Abud 10/12/2020 C4 luan 20/12/2020 DM-5 Crownies 4.5 15 mins C5 Said 15/12/2020 Dessert 1 Dominos C2 Abud 18/12/2020 MD-8 Sundae 1.5 10 mins C3 Hamood 21/12/2020 Dessert 2 McDonalds C6 |Khalfan 21/12/2020 23-B. Using the format of the below-given table, identify the correct table/relation names & keys after 3NF. (3 marks) Table Name Primary key Foreign Key (if any) 23-C. Draw the ERD after the third normal form. (4 marks)