📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

Question

A table is in 2NF (Second Normal Form) if it is in 1NF

and:

A All non-key attributes are fully functionally dependent on the primary key.

B It has no multi-valued dependencies.

C It has no join dependencies.

D It has no join dependencies.

E It contains no partial dependencies on any candidate key.

Practice Next

More IT DBMS Questions

If all the digits of the number '759621384567' are written in decreasing order from the right end, then what is the product of third and sixth digit fro...
Statements : All aeroplanes are helicopters.

Some helicopters are kites.

All jets are kites.

Conclusions : I. Some kites not bein...
Statements:

Only a few Laptops are Notebooks.

No Notebook is Computer.

Only a few Notebooks are Bars.

Only a few Bars...
Read the given statements and conclusions carefully. You have to take the three given statements to be true even if they seem to be at variance from co...
Statements:

Only Short is Big.

No Short is Tallest.

Only a few Tallest is Shortest.

Few Heaviest is Short.

Conclusion...
In each question below are given two statements followed by two conclusions numbered I and II. You have to take the two given statements to be true eve...
In the question below there are three statements followed by three conclusions I, II and III. You have to take the three given statements to be true ev...
Statements:Some combs are boxes.

All boxes are mirrors.

Conclusions:I. Some boxes are combs.

II. Some mirrors are combs.
Statements:

Some Mountains are not Rivers.

All Rivers are Hills.

Only a few Hills are Oceans.

Conclusions:

I. Some ...
Statements:

Some Marble are Colour

Only a few Colour is Tile

Only Tile is Floor

Conclusions:

I. All Tile being Colour...

ask-question