Consider the following relation Hero_Battles for a Superhero database: Hero_Battles (Battle_ID, Hero_ID, Villain_ID, Battle_Name, Hero_Name, Villain_Name,...

 

Transcribed Image Text:

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 (1NF)? Explain why. If not in 1 NF, normalize the above relation to 1NF. b. Is the above relation in the second normal form (2NF)? Explain why. If not in 2NF, then normalize to 2NF. C. 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. 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 (1NF)? Explain why. If not in 1 NF, normalize the above relation to 1NF. b. Is the above relation in the second normal form (2NF)? Explain why. If not in 2NF, then normalize to 2NF. C. 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.

Answer rating: 100% (QA)

Lets analyze the given relation Hero Battles and determine if its in the first second or third normal form 1NF 2NF or 3NF and normalize it as needed G... View the full answer