Please answer all problems, a single image of the UML diagrams is sufficient. Thank you!

Homework 4: We Talkin 'Bout Practice In this homework, you will identify redundancies in several example data models, and eliminate those redundancies as taught in class. Office Visits Identify a functional dependency in this table, which represents a log of visits to faculty office hours. Fix the functional dependency as shown in lecture, and draw a UML diagram showing your solution. Do not identify and fix other redundancies that do not involve a functional dependency (unless you are simply looking to practice those skills). Babysitters Identify a functional dependency in this table, which represents a log of babysitting jobs. Fix the functional dependency as shown in lecture, and draw a UML diagram showing your solution. Do not identify and fix other redundancies that do not involve a functional dependency (unless you are simply looking to practice those skills). Programming Languages The "languages known" column is implemented as a multi-value string attribute of a Programmer class, which also has attributes for User ID and Name. The user's proficiency with each language is indicated, and is always one of "beginner", "intermediate", "advanced", or "expert". Eliminate the redundancies in the table known column by fixing the multi-value attribute and any other redundancy that you recognize, and draw a UML diagram showing your solution. [I made up the language proficiencies. Please don't tell Claus Jergensen that he's only an intermediate Prolog programmer.] Pizza Choices This is a table of pre-built pizza choices at a pizza restaurant. Identify the data integrity and redundancy issues with this table, using vocabulary from this course, and draw a UML diagram showing your solution