Modify this picture to answer the question.

PROBLEM 1A:

Now assume that you wish to modify the ER diagram you created in Problem 1A above so that it includes the following:

Professors may advise one or more students

Students may have at most ONE advisor

Add a new relationship to the diagram to account for this information. Make sure to account for minimum and maximum cardinality as indicated by the new statements. HINT: you only need to add a relationship to the original diagram to complete this problem.

Class name Class Offers Course id Last_name Duration taught by Professor Course CourseNam lled By Professor SSN First name Student Student ID First_name Last_name