Give a set of functional dependencies for the relational schema R(A, B, C, D) with primary key AB under which R is in 1NF but not in 2NF.
What will be an ideal response?
Any (non-trivial) dependency X ? ?, with X = A or X = B and ? not equal to A or B will violate 2NF.
Computer Science & Information Technology
You might also like to view...
If malware is installed and then run on your computer, your computer is said to have a(n):
A) security hole B) infection C) hive D) cookie
Computer Science & Information Technology
Why would you save search criteria as a saved search?
What will be an ideal response?
Computer Science & Information Technology