To keep track of students and majors offered by different schools, Millennium College, a new college on the East coast, uses the table structure shown below. a) (15 points) Assuming that the sample data are representative, draw a dependency diagram in Visio that shows all functional dependencies including both partial and transitive dependencies. Make sure you label each dependency as full dependency (FD), partial dependency (PD), or transitive dependency (TD) (Hint: Look at the sample values to determine the nature of the relationships.) b) (15 points) Using what you completed in Part A, remove all partial dependencies and re-draw the new dependency diagram in Visio, showing and labeling all full dependencies and transitive dependencies. c) (15 points) Using what you completed in Part B, remove all transitive dependencies and re-draw the new dependency diagram in Visio, showing and labeling all full dependencies. d) (15 points) Using what you completed in Part C, draw a fully labeled Crow's Foot E-R Diagram in Visio, including all entities, attributes, primary keys, foreign keys, and relationships, clearly labeled, using best practices. e) (16 points) Using what you completed in Part D, write out the relational schema. Bold and underline primary key attributes and italicize foreign key attributes