it is a database managment material

question 1

question 2

ffaasstttt

The patients given an appointment with a doctor. The patient ways visits the same clinic but the doctor works in different clinics. DocPatient Appointments Table DHID Dr Name Dr Rank PatID D18 John Smith Senior P70 POS D59 Ahmed Nasir Prof P93 POS P81 PatientName Abdulla Ali Qasim Ahmed Fatima Sami Qasim Ahmed Sameer Omar PatientAge ClinicID 12 Ci 35 C2 7 C3 35 C2 62 C3 CIBlock 1044 904 350 904 350 a) Why is the above table un-normalized? b) One way to transform the above table into 1NF is to flatten the table? Briefly explain how the flattening proce C) Identify all Functional Dependencies (FD) from the above table. Each of the FDs is going to represent a stand- sure none of the produced tables contains neither partial nor transitive dependencies. (Hint: there are 4 FDs). inutes remaining A Points Question 19 Consider the given figure then answer the following questions: Works IND C Tres room dan 1121 Nene Ange edica Margar www company Hand bonus A Doctor Nur degree pe