Given the following sheet $($APPOINTMENT$)$

staffNo dentistName patientNo patentName Appointment

Date$/$time surgeryNo Patient

insurance Co$-$pay

$1011$ Tony Smith P$100$ Gillian White $12/8/1910$:$00$ S$10$ UH $30$

$1011$ Tony Smith P$105$ Jill Bell $12/9/1910$:$00$ S$15$ BCBS $40$

$1024$ Helen Pearson P$108$ Ian Mackay $12/9/1910$:$00$ S$15$ UH $20$

$1024$ Helen Pearson P$108$ Ian macKey $2/9/2012$:$30$ S$10$ UH $25$

$1023$ Robin Plevin P$105$ Jill Bell $08/10/209$:$30$ S$15$ BCBS $40$

$1023$ Robin Plevin P$110$ John Walker $12/08/1910$:$00$ S$15$ ATNA $40$

$1040$ Kyle Lee P$111$ Jill Bell $11/1/1914$:$20$ S$20$ BCBS $10$

Suppose that the data of the above sheet shows all possible functional dependencies. Note surgeryNo is the code of treatment$/$procedure a patient receives for the appointment of visit. The co$-$pay for each visit$/$procedure received depends on the patients and their primary insurance policy.

$31$ List a set of functional dependencies based on your analysis on the information in the above table.

$32$ Based on your answer to $31,$ define the key of the table

APPOINTMENT $($StaffNo$,$ DentistName, patientNo, patientName, AppointmentDate$/$time$,$ SurgeryNo, PatientInsurance, Co$-$pay$)$

$33$ What normal form above table is in and WHY? $($Note you need to correctly answer questions $31$ and $32$ in order to answer this question correctly$)$

$34$ What modification anomalies this table suffers $($be as specific as possible, refer to the textbook$$s examples$)$

$35$ Normalize table APPOINTMENT based on FDs you listed. Show the result of normalization. Clearly indicate keys $($underline$)$ and foreign keys $($italicize$,$ if there is any$).$