Solve the below given examples to 3NF. Explain each normal form in detail by showing the resultant tables

Example2. Provides the details of order purchased.

OID O_Date CID C_Name C_State PID P_Desc P_Price Qty 1006 20/03/1 5 1 Tony QC 7,5,4 Laptop, phone, TV 1200, 2000 800 1,2,1 1007 20/03/1 6 2 Helen ON 10,6 Monitor TV 500, 800 3,4

Solve the below given examples to 3NF. Explain each normal form in detail by showing the resultant tables. Example1. Provides the details of the patients in a dental clinic. staffNo dentistName surgeryNo S1011 S1011 S1024 S1024 S1032 S1032 Tony Smith Tony smith Helen Pearson Helen Pearson Robin Plevin Robin Plevin patientNo patientName Appointment date P100 Gillian White 20-Mar-30 P105 Jill Bell 20-Mar-30 P108 lan Mackay 20-Mar-30 P108 lan Mackay 20-Mar-30 P105 Jill Bell 20-Mar-30 P110 John Walker 20-Mar-30 time 8:00 10:00 8:00 8:00 13:00 15:00 S10 S15 S10 S10 S15 S13 Example2. Provides the details of order purchased. OID 1006 O_Date CID 20/03/11 5 C_Name Tony C_State QC PID 7,5,4 Qty 1,2,1 P_Desc P_Price Laptop, 1200, phone, 2000 TV 800 Monitor 500, TV 800 1007 Helen ON 20/03/12 6 10,6 3,4