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...

The size, shape, color and weight of an object are considered ______________of the object’s class.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Time Estimation Techniques

What will be an ideal response?

Computer Science & Information Technology

When using automation with the Audio Mixer, where do the keyframes appear?

What will be an ideal response?

Computer Science & Information Technology

Which of the following certifications is not administered by (ISC)2?

A. CISSP B. CEH C. SSCP D. CSSLP

Computer Science & Information Technology