3A) (8 points) The table is already in First Normal Form, and its primary key is (Longitude. Latitude, Height). The schema for the table is: (Longitude, Latitude, Height, Address, Owner, Floor, Cost, InsuranceRate, CreditRating) You are given the following functional dependencies: Longitude, Latitude, Height Address, Owner, Floor, Cost, InsuranceRate, CreditRating Longitude, Latitude Address Height Floor CreditRating Insurance Rate 1. Remove any existing partial dependencies to create a set of linked relational schemas in Second Normal Form (2NF). 2. Remove any existing transitive dependencies to create a set of linked relational schemas in Third Normal Form (3NF). 3B) (8 points) Consider a table that stores information about students, student name, GPA, honors list and the credits that the student had completed so far. (StudentID, First, Last, GPA, Honor, Credits) You are given the following functional dependencies First, Last - StudentID, GPA, Honor, Credits GPA Honor a. Is this schema in Second Normal Form? If not, please state which FDs violate 2NF and decompose the schema accordingly. b. Having done part 3Ba), is this schema in Third Normal Form? If not, please state which FDs violate 3NF and decompose the schema accordingly