adplus-dvertising
frame-decoration

Question

Match the following:

(i) 5 NF              (a) Transitive dependencies eliminated
(ii) 2 NF             (b) Multivalued attribute removed
(iii) 3 NF            (c) Contains no partial functional dependencies
(iv) 4 NF            (d) Contains no join dependency

a.

i-a, ii-c, iii-b, iv-d

b.

i-d, ii-c, iii-a, iv-b

c.

i-d, ii-c, iii-b, iv-a

d.

i-a, ii-b, iii-c, iv-d

Answer: (b).i-d, ii-c, iii-a, iv-b

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Match the following: (i) 5 NF              (a) Transitive dependencies eliminated (ii) 2 NF             (b) Multivalued attribute removed (iii) 3 NF            (c) Contains no...

Similar Questions

Discover Related MCQs

Q. The normalization of 1NF relations to 2NF involves:

Q. Tuple in relational algebra refers to:

Q. A relation R on a set X is said to be a partial ordering if R is

Q. An attribute or set of attributes within one relation that matches the candidate key of some(possibly the same) relation:

Q. With QBE, inserting records from one or more source tables into a single target table can be achieved by:

Q. SQL command to delete a column from an existing table:

Q. Data Scrubbing is

Q. An attribute A of datatype varchar(20) has the value ‘xyz’, and the attribute B of datatype char(20) has the value “lmnop”, then the attribute A has ............... spaces and attribute B has ............... spaces.

Q. Data warehouse contains ............... data that is never found in operational environment.

Q. .................. command is used to remove a relation from SQL database.

Q. Which of the following statement/s is/are true?

(i) Facebook has the world’s largest Hadoop Cluster.
(ii) Hadoop 2.0 allows live stream processing of Real time data.

Choose the correct answer from the code given below:

Q. Consider the relation schema R = (A,B,C,D,E,F) on which the following functional dependencies hold:

A → B
B, C → D
E → C
D → A

What are the candidate keys of R?

Q. Consider the following sequence of two transactions on a bank account (A) with initial balance 20,000 that transfers 5,000 to another account (B) and then apply 10% interest.

(i) T1 start
(ii) T1 A old = 20,000 new 15,000
(iii) T1 B old = 12,000 new = 17,000
(iv) T1 commit
(v) T2 start
(vi) T2 A old = 15,000 new = 16,500
(vii) T2 commit

Suppose the database system crashes just before log record (vii) is written. When the system is restarted, which one statement is true of the recovery process?

Q. A clustering index is defined on the fields which are of type:

Q. In RDBMS, which type of Join returns all rows that satisfy the join condition?

Q. In a Hierachical database, a hashing function is used to locate the .................

Q. Relations produced from E - R Model will always be in ..............

Q. Consider the following schedules involving two transactions.

S1 : r1(X) ; r1(Y) ; r2(X) ; r2(Y) ; w2(Y) ; w1(X)
S2 : r1(X) ; r2(X) ; r2(Y) ; w2(Y) ; r1(Y) ; w1(X)

Which one of the following statements is correct with respect to above?

Q. For a database relation R(a, b, c, d) where the domains of a, b, c and d include only atomic values, and only the following functional dependencies and those that can be inferred from them hold:

a → c
b → d

The relation is in ...............

Q. A many-to-one relationship exists between entity sets r1 and r2. How will it be represented using functional depedencies if Pk(r) denotes the primary key attribute of relation r?