edited by
282 views

2 Answers

1 votes
1 votes

Second Normal Form or 2NF is based on the concept of full functional dependency.

Full Functional Dependency: 

In a relation R, an attribute Q is said to be fully functional dependent on attribute P, if it is functionally dependent on P and not functionally dependent on any proper subset of P. The dependency P → Q is left reduced, their being no extraneous attributes in the left hand side of the dependency.

If AD → C, is fully functional dependency, then we cannot remove A or D. i.e. C is fully functional dependent on AD. If we are able to remove A or D, then it is not full functional dependency.

edited by
0 votes
0 votes

A full functional dependency is a state of database normalization that equates to standard of Second Normal Form.

Ans B

Related questions

0 votes
0 votes
2 answers
1
gatecse asked Mar 2, 2018
737 views
Bluetooth uses ____ method in physical layer to avoid interference from other devices or other networksFHSSFDSSTDSNone of the above
0 votes
0 votes
1 answer
2
gatecse asked Mar 2, 2018
362 views
In which of the following search agent operates by interleaving computation and action?Offline searchOnline searchBreadth first searchDepth first search
0 votes
0 votes
1 answer
3
gatecse asked Mar 2, 2018
360 views
Which of the following deals with the precise model where accurate solutions are achieved quickly?Soft computingMobile computingHard computingNone of the above
0 votes
0 votes
1 answer
4
gatecse asked Mar 2, 2018
481 views
Supervised learning and unsupervised learning are two board category ofData warehouseDBMSNeural NetworkNone of the above