Give a set of functional dependencies for the relational schema R(A, B, C, D) with primary key AB under which R is in 2NF but not in 3NF.

What will be an ideal response?


Any (non-trivial) dependency X ? ?, with X not a proper subset of {A, B} and ? not
equal to A or B will violate 3NF but not 2NF.

Computer Science & Information Technology

You might also like to view...

One of the most fundamental elements of network operations is which of the following? (Select the best answer.

a. Certified cabling b. State of the art routers c. Multiple software systems d. Documentation

Computer Science & Information Technology

On a microcomputer, the responsibility for performing unique, device-specific tasks isassigned to a software routine called a(n) __________.

a. interface b. access method c. device driver d. control routine

Computer Science & Information Technology

When a media format will work on different operating systems, it is said to be ________ compatible

Fill in the blank(s) with correct word

Computer Science & Information Technology

What slider was added to the Smart Sharpen filter in Photoshop CC?

What will be an ideal response?

Computer Science & Information Technology