1) Does the below table violate first, second, or third normal form? Why, or why not? Propose a correct design if it violates the normal forms. (Don't forget to label primary and foreign keys.) FINES (Ticket No, License_Pl, Offense ID, Offense, Fine, Date) Ticket NoLicense Palortense ID offense Eine Date 1023 MVX 322 Parking 15.00 09/20/92 1025 RVX 287 2 Red Light 50.0009/21/92 397 MVX 322 Parking 15.0009/03/92 1027 TGY 832 Parking 15.00 09/22/92 225 KCE 654 3 Speeding 65.00 09/04/92 212 MVX 322 3 Speeding 65.00 09/06/92 2) Make sure the below tables are in third normal form. Appointment (App_no, Doc_ID, App_Date, App_Time, Pat_ID, Pat_name, Pat_address) Doctor (DOC_ID, Doc_name, cell phone)