1. Consider the relation schema STUDENT_INFO(STUDENT#, NAME, BIRTHDAY, AGE, ADVISOR, DEPARTMENT, SEMESTER, COURSE, GRADE) with the key {STUDENT#, SEMESTER, COURSE} and the following functional dependencies: STUDENT# NAME, BIRTHDAY, AGE, ADVISOR, DEPARTMENT BIRTHDAY AGE ADVISOR DEPARTMENT (a) Show that STUDENT INFO is not in third normal form. (b) Give a decomposition of STUDENT_INFO into relations in third normal form such that the decomposition is lossless join and preserves dependencies. (c) Are the relations you obtained as the result of the decomposition in (b) in Boyce-Codd normal form? Prove your