Need help for database problem. Will upvote if answered in 1 hour

Question 18 (10 points) ) Listen Consider the partial University ERD. In addition to the entities shown, we need to support the following information: Some of the professors took a leadership program and gained leadership certificates that enable them to be deans of faculties - we need to keep track of the certificate number and issuer organization that issued the certificate). We shall refer to such profs as leaders. (Hint: Use subtypes.) A leader (prof who took the leadership program) may be a dean of faculty, while a faculty has exactly one dean (leader who is a prof who took the leadership program). Students have a buddy system. We need to keep track of which students are buddies of which other students: A student may be a buddy of many other students, while a student may not have any buddies. Some employees may have dependants (e.g., for the purposes of calculating income tax), in which case we need to know their names (first and last) and date and time of birth. Date and time of birth are unique for dependants of one employee (e.g., twins cannot both be born at exactly the same time)