• recategorized by
630 views

2 Answers

1 1 vote

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
Position:
Show:

Related questions

0 0 votes
1 answers 1 answer
606
606 views
gatecse asked Mar 2, 2018
606 views
A table space is further broken down into ______ .BlocksExtentsFilesSegments
0 0 votes
4 4 answers
983
983 views
gatecse asked Mar 2, 2018
983 views
Which of the following operation of relational algebra, selects certain columns from the table and discards the other columns?SELECTPROJECTDIVISIONNone of the above
0 0 votes
1 1 answer
402
402 views
gatecse asked Mar 2, 2018
402 views
In a sequential file records are maintained in the logical sequence of theirprimary key valuestorage locationprimary and secondary key valueNone of the above
0 0 votes
1 1 answer
509
509 views
gatecse asked Mar 2, 2018
509 views
Each row or record of a relational table is known asDomainAttributeTupleKey