NEW
Font size
WorksheetsDBMS Quiz 2
Total questions: 7
Worksheet time: 2mins
AB -> A is an example of
Trivial FD
Non trivial FD
Semi non trivial FD
NOTA
Given A --> B, if tuples t1 and t2 have same value for A then ___
they may or may not have the same value in B
they must have the same value in B
both the above options are correct
NOTA
Armstrong's Inference rules include ___
Reflexive, Union, Composition
Reflexive, Transitive, Decomposition
Decomposition, Augmentation, Reflexive
Augmentation, Reflexive, Transitive
FDs = {A-->B, BC-->D, E-->C, D-->A}
(DEH) is a candidate key
True
False
Insufficient Information
Every candidate key is a super key but the reverse is untrue
True
False
Candidate key and Super key mean the same thing
NOTA
To find minimal cover, the second step to be performed is ___
Split the FDs such that the RHS contains single attribute
Find redundant attributes on LHS and delete them
Find redundant FDs and delete them from the set
NOTA
Every candidate key is primary key but reverse is untrue
True
False
Candidate key and Primary key are same
