The relation shown in Figure 15.11 lists members of staff (staff Name) working in a given ward (ward Name) and patients (patient Name) allocated to a given ward. There is no relationship between members of staff and patients in each ward. In this example assume that staff name (staff Name) uniquely identifies each member of staff and that the patient name (patient Name) uniquely identifies each patient.
In Figure 15.11

(a) Describe why the relation shown in Figure 15.11 is in BCNF and not in 4NF.
(b) The relation shown in Figure 15.11 is susceptible to update anomalies. Provide examples of insertion, deletion, and update anomalies.
(c) Describe and illustrate the process of normalizing the relation shown in Figure 15.11 to 4NF.

Transcribed Image Text:

wardName staffName |patientName Pediatrics Kim Jones Claire Johnson Pediatrics Kim JonesBrian White Pediatrics Stephen Ball Claire Johnson Pediatrics Stephen Ball Brian White