A hospital keeping track of patients, prescriptions, doctors

    Create an example of a relation (containing several [5-10] records) that is prone to update anomalies. The relation can be about one of the following: • University keeping track of records related to classes or students, etc. • A hospital keeping track of patients, prescriptions, doctors, rooms, etc. • An auto manufacturer keeping track of factories, raw material, makes, etc. 2. Using the relation created in #1 above, do the following: a) Describe an example that illustrates the insertion anomaly. b) Describe an example that illustrates the deletion anomaly. c) Describe an example that illustrates the modification anomaly. 3. Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the relation you created above. 4. Show the result of normalizing the relation you created in #1 to 2NF. 5. Show the result of normalizing the relation you created in #1 to 3NF.