) A database for a university needs to store information about academic advisors (identified by adv id, with adv name as an attribute), students (identified by stu id, with stu name and major as attributes) and various grades (identified by grade id, with date, grade and course as attributes). A student has exactly one academic adisor. A grade is for only one student, however, it may be reviewed by multiple advisors (and advisors can review many grades). (a) Draw an E/R diagram that captures all of the above information. (b) Define tables using SQL that correspond to the E-R diagram in (a). You must define the smallest number of tables while ensuring that these tables are in BCNF (you do not need to prove that the resulting tables are in BCNF). For each table, specify primary and foreign keys. Add integrity constraints if needed. (c) List all of the nontrivial functional dependencies that you can find from the tables in (b). If there are attribute names that are newly introduced in (b), you may use these names. Please omit functional dependencies that are redundant (for example, if a b is included, do not add ac bc).