Database

2. Refer to E 4.9 on textbook page 123 and answer the following questions (3pts each) Using HEALTH CENTER table, describe an example that illustrates the insertion anomaly a. Using HEALTH CENTER table, describe an example that illustrates the deletion anomaly b. Using HEALTH CENTER table, describe an example that illustrates the modification anomaly. c. Depict full key functional dependencies, partial functional dependencies (if any) and transitive functional dependencies (if any) in the HEALTH CENTER table. d. oW thE result of normalizing the LANGUAGE SCHOOL Table to 3NF E4.9 Consider the following relation with sample data. HEALTH CENTER TABLE DocID DocName PatientiD PatientName InsuranceColD Insurance CoName NextAppointmentDate Dr Joe 111 ACME Insurance 1-Dec ACME Insurance 2-Dec Purple Star Purple Star Tower Block ACME Insurance 3-Dec All Protect 1 Dr. Joe 222 Mia Dr. Joe333 Dr. Sue 333 Dr. Kim 555 Dr. Kim 111 Dr. Joe 666 Pam 12 3-Dec 7-Dec 2-Dec Max Alen 1 4 9-Dec E4.9a Depict full key functional dependencies, partial The HEALTH CENTER Table captures the data about pa- tients'appointments with doctors . functional dependencies (if any), and transitive functional dependencies (if any) in the HEALTH CENTER Table ach patient has a unique Patient ID and a Patient Name. Each doctor has a unique Doc ID and a Doc Name Each patient has one insurance company . E E4.9b Show the result of normalizing the HEALTH E4.9c Show the result of normalizing the HEALTH CENTER Table to 2NF e Ea ch insurance company has a unique Insurance Co ID and Insurance Co Name. Each appointment is scheduled between one patient and one CENTER Table to 3NF * doctor Each patient can have many appointments scheduled (but only one appointment scheduled with one particular doctor)