Computer Sciences > GATE 2025 SET-2 > Normalization
Consider the following relational schema along with all the functional dependencies that hold on them.
R1(A,B,C,D,E):{D→E,EA→B,EB→C}
R2(A,B,C,D):{A→D,A→B,C→A}
Which of the following statement(s) is/are TRUE?
A
R1 is in 3NF
B
R2 is in 3NF
C
R1 is NOT in 3NF
D
R2 is NOT in 3NF

Correct : b

Similar Questions

A database of research articles in a journal uses the following schema. (VOLUME, NUMBER, STARTPGE, ENDPAGE, TITLE, YEAR, PRICE) The primary key is (VOLUME, NUM...
#128 MCQ
A database of research articles in a journal uses the following schema. (VOLUME, NUMBER, STARTPGE, ENDPAGE, TITLE, YEAR, PRICE) The primary key is (VOLUME, NUM...
#128 MCQ
A database of research articles in a journal uses the following schema. (VOLUME, NUMBER, STARTPGE, ENDPAGE, TITLE, YEAR, PRICE) The primary key is (VOLUME, NUM...
#128 MCQ

Related Topics

No tags found

Unique Visitor Count

Total Unique Visitors

Loading......