2) Figure 2 shown the table of Big Patient. Convert that table into 3NF. The functional dependencies are shown in table 2 can be use as your reference. Draw the functional dependency diagram, and show...

Hi please help me with this database question thankyou so much

Extracted text: 2) Figure 2 shown the table of Big Patient. Convert that table into 3NF. The functional dependencies are shown in table 2 can be use as your reference. Draw the functional dependency diagram, and show the result of each step in the normalization process. VisitNo VisitDate PatNo PatAge PatCity ProvNo ProvSpecialty Diagnosis V10020 1/13/2007 DENVER INTERNIST EAR INFECTION PI 35 DI NURSE PRACTIONER NURSE PRACTIONER V10020 1/13/2007 PI 35 DENVER D2 INFLUENZA V93030 1/20/2007 P3 17 ENGLEWOOD D2 PREGNANCY V82110 1/18/2007 P2 60 BOULDER D3 CARDIOLOGIST MURMUR Figure 2: Sample Data for the Big Patient table


Extracted text: Lab 6 Exercise Normalization 1) An agency called MegaSupply supplies part-time/temporary staff to hotels throughout Melaka. The table shown in Figure 1 lists the time spent by agency staff working at two hotels. The National Insurance Number (NIN) is unique for employee. NIN 113567WD | hoteINo contractNo hoursPerWeek eName hotelLocation John Smith Diane Hocine Sarah White John Smith C1024 16 H25 Edinburgh 234111XA C1024 24 H25 Edinburgh | 712670YD C1025 28 Н4 Glasgow 113567WD C1025 16 H4 Glasgow Figure 1: Employees of MegaSupply and their contracts to work at hotels (a) The table shown in Figure 1 is susceptible to update anomalies. Briefly explain and provide examples of insertion, deletion, and modification anomalies. (b) Describe and illustrate (by using dependency diagram) the process of normalizing the table shown in Figure 1 to 3NF. State any assumptions you make about the data shown in this table.