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

Of all the following, the only category that you can not group CSS1 properties into is ____.

A. text properties B. table properties C. font properties D. box properties

Computer Science & Information Technology

A basic Word template can store macros. _________________________

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Before a mobile app can be coded using Java, it must be designed.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

The ability to step back from a troubleshooting situation and analyze one's own thinking process is called ____.

A. decision making B. problem solving C. metacognition D. creativity

Computer Science & Information Technology