Give an example of a schema that is not in 3NF and has just two attributes.

What will be an ideal response?


(AB; {} ? A, B ? A). Here B is a key, but {} ? A does not satisfy the 3NF requirements.

Computer Science & Information Technology

You might also like to view...

What is the output of the following code?

int a = 1; int c = 0; while (c < 4) { a = a + 1; cout << a; c = c + 1; } a) 2345 b) 1234 c) 23456 d) 12345

Computer Science & Information Technology

Those with knowledge of threats & attacks help the groups defending systems as a part of a community risk assessment model to secure systems

a. true b. false

Computer Science & Information Technology

List five different services you would expect a user support center to provide.

What will be an ideal response?

Computer Science & Information Technology

What type of sub-query is an embedded SELECT expression that returns one or more columns and zero to many rows?

a. Row sub-query b. Table sub-query c. Scalar sub-query

Computer Science & Information Technology