Register

ISRO CSE 2011 | Question: 29

5,926 views

2 Answers

Best answer
15 15 votes
Functional dependency X --> Y is a full functional dependency if removal of any attribute A from X means that the dependency does not hold any more i.e. for any attribute A ϵ X, (X - {A}) does not functionally determine Y.

It is related to 2nd NORMAL FORM.
5 5 votes

Second normal form should not have partial dependency , only the it is in 2nf hence it has fully functional dependency.

Voting & Accepting an answer helps improve the community
Answer:
← Previous · ISRO CSE 2011 | Ques...Next → · ISRO CSE 2011 | Ques...
← Previous in category · In 2 Phase locking p...Next in category → · B+ tree database
Position:
Show:

Related questions

11 11 votes
2 answers 2 answers
9.6k
9.6k views
Isha Gupta asked Jun 15, 2016
9,631 views
ISRO CSE 2011 | Question: 53
In functional dependency Armstrong inference rules refers toReflexive, Augmentation and DecompositionTransitive, Augmentation and ReflexiveAugmentation, Transitive, Refle...
14 14 votes
4 answers 4 answers
6.2k
6.2k views
go_editor asked Jun 21, 2016
6,238 views
ISRO CSE 2011 | Question: 15
What is the equivalent serial schedule for the following transactions?TransactionT1T2T3  R(Y)  R(Z)R(X)  W(X)    W(Y)  W(Z) W(Z) R(Y)  W(Y)   R(Y)  W(Y)  R(X)  W(X)  $\te...
5 5 votes
2 answers 2 answers
4.8k
4.8k views
Isha Gupta asked Jun 15, 2016
4,758 views
ISRO CSE 2011 | Question: 21
Which type of DBMS provides support for maintaining several versions of the same entity?Relational Database Management SystemHierarchicalObject Oriented Database Manageme...
5 5 votes
4 answers 4 answers
4.3k
4.3k views
go_editor asked Jun 22, 2016
4,285 views
ISRO CSE 2011 | Question: 46
Which $\textsf{RAID}$ level gives block level striping with double distributed parity?$\textsf{RAID 10}$$\textsf{RAID 2}$$\textsf{RAID 6}$$\textsf{RAID 5}$