28 votes 28 votes A table has fields $F_1, F_2, F_3, F_4, F_5$ with the following functional dependencies $F_1 \to F_3, F_2\to F_4, (F_1 . F_2) \to F_5$ In terms of Normalization, this table is in $1\;\text{NF}$ $2\;\text{NF}$ $3\;\text{NF}$ None of these Databases gateit-2005 databases database-normalization easy + – Ishrat Jahan asked Nov 3, 2014 • edited Oct 4, 2020 by gatecse Ishrat Jahan 7.4k views answer comment Share Follow See all 3 Comments See all 3 3 Comments reply Deepak Poonia commented Oct 25, 2022 i edited by Deepak Poonia Nov 7, 2023 reply Follow Share Find Detailed Video Solution Below:Detailed Video Solution 0 votes 0 votes shikhar500 commented Jan 23, 2023 reply Follow Share @Deepak Poonia sir this video is not opening kindly plz look into it 0 votes 0 votes Deepak Poonia commented Jan 23, 2023 reply Follow Share Link updated. 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes 1) F1->F3 2) F2->F4 3) F1F2->F5 Candidate key: F1F2 As F1, F2 are prime attributes, they showcase partial dependency which makes the decomposition not 2NF, so its 1NF Option (A) Kartavya Kothari answered Apr 24, 2018 Kartavya Kothari comment Share Follow See 1 comment See all 1 1 comment reply register_user_19 commented Nov 24, 2018 reply Follow Share 3) F1F2->F5 this is not a partial dependency 0 votes 0 votes Please log in or register to add a comment.