Please Help

Given the following COLLEGE STUDENTS table and Assumptions: COLLEGE STUDENTS (SNum, S LastName, S FirstName, HSNum, HSName, ANum, A LastName, A FirstName) Assumptions: 1- A college student has one college advisor. 2- A college student graduated from one high school before enrolling in college. 3- A college student is identified by a unique SNum. 4- A college advisor is identified by a unique ANum. 5- A high school is identified by a unique HSNum. There are no multivalued dependencies. Using single-arrow notation, formally state any functional dependencies (FD). For each FD, identify one or more of the assumptions above that leads to the FD. Answers in Bold. What is the key of COLLEGE STUDENTS? The key is Use the normalization process below to normalize the COLLEGE STUDENTS table to BCNF. If there is a functional dependency with a determinant that is not a candidate key: Begin A. Move the columns of that functional dependency into a new relation. B. Make the determinant of that functional dependency the primary key of the new relation. C. Leave a copy of the determinant as a foreign key in the original relation. D. Create a referential integrity constraint between the original relation and the new relation. Repeat until every determinant of every relation is a candidate key. Show your work using the proper table notation. Answers in Bold