engineering recuitment GATE CSE 2023-24 Test Series DBMS Integrity Constraints and Normal Form Normal Form
Consider the following two relations
R1(ABCDE) with functional dependencies {AB → CDE}, AC → BDE, B → C, C → B, C → D, B → E}
R2(ABCD = {AB → C, AB → D, C → B}
The highest normal form of relations R1 and R2 respectively are:1
1NF, 2NF
2
2NF, 3NF
3
1NF, 3NF
4
2NF, 1NF