1- Discuss insertion, deletion, and modification anomalies. What update anomalies occur in the following relation BOOK_PUBLISHER? 2- What is a functional dependency? What are the possible sources of the information that defines the functional dependencies that hold among the attributes of a relation schema? 3- Define first (1NF), second (2NF), third (3NF), and Boyce-Codd normal forms. 4- Consider the following relation:
R
(Doctor\#, Patient\#, Date, Diagnosis, Treat code, Charge) In the above relation, a tuple describes a visit of a patient to a doctor along with a treatment code and daily charge. Assume that diagnosis is determined (uniquely) for each patient by a doctor. Assume that each treatment code has a fixed charge (regardless of patient). Is this relation in 2 NF? Justify your answer and decompose if necessary. Then argue whether further normalization to
3NF
is necessary, and if so, perform it.