Consider the following relation "Hero_Battles" for a Superhero database: Hero_Battles (Battle_ID, Hero_ID, Villain_ID,Battle_Name, Hero_Name, Villain_Name, Battle_Date, Location, Hero_Team_Name, Team_Location, Hero_Gender, Villain_Gender, Hero_Points_Earned) The primary key of the relation is (Battle_ID, Hero_ID) The relation has some additional functional dependencies given below. FD1: Battle_ID-> Battle_Name, Battle_Date, Location FD2: Hero_ID -> Hero_Name, Hero_Gender, Hero_Team_Name, Team_Location FD3: Villain_ID -> Villain_Name, Villain_Gender FD4 Hero_Team_Name> Team_Location Is the above relation in the first normal form (INF)? Explain why. If not in 1 NF, normalize the above relation to INF. b Is the above relation in the second normal form (2NF)? Explain why. If not in 2NF, then normalize to 2NF. Is the relation now in the third normal form (3NF)? Explain why. If not in 3NF yet, then normalize to 3NF. DO NOT assume any multivalued composite attributes. Everything is clearly mentioned in question answer accordingly. a c