3. NORMALIZATION Normalization: Consider the following relation: Scholarship Application(Application id Scholarship id, Scholarship_name, Percentage_Waiver, Student_ID, Student_name, Student_CGPA, total_credits, total_semester_fees, Application_Date, scholarship_status) Since a student can apply for many scholarships in the same application the primary key of the relation is {Application_id, Scholarship_id} to avoid any multi-valued attribute. The relation has the following additional functional dependencies: FD1: Application_ID Application_Date, Student_ID, Student_name, Student_cgpa, total_credits, total_semester_fees FD2: Student_ID - Student_name, Student_cgpa, total_credits, total_semester_fees FD3: Scholarship_ID Scholarship_name, Percentage_Waiver FD4: total_credits + total_semester_fees 1. Give reasons to explain if the above relation is in the first normal form (1NF) or not? If not, normalize the above relation to 1NF. 2. Give reasons to explain if the above relation is in second normal form (2NF) or not? If not, normalize to 2NF. 3. Give reasons to explain if the above relation is in third normal form (3NF) or not? If not, normalize to 3NF