Recent questions tagged database-normalization

3 votes
1 answer
393
Armstrong $(1974)$ proposed systematic approach to derive functional dependencies. Match the following w.r.t functional dependencies:$\begin{array}{} & \textbf{List-I} ...
4 votes
1 answer
396
3 votes
2 answers
399
0 votes
0 answers
401
2 votes
3 answers
402
10 votes
4 answers
403
Consider the following tableThe table is in which normal form?First Normal FormSecond Normal FormThird Normal Form but not BCNFThird Normal Form and BCNF
2 votes
2 answers
406
–1 votes
7 answers
407
Every BCNF decomposition is A)Dependency preservingB)not a dependency preservingC)Need not be dependency preservingD)None of the above
1 votes
1 answer
409
Which of the following is true?A relation in BCNF is always in 3NFA relation in 3NF is always in BCNFBCNF and 3NF are sameA relation in BCNF is not in 3NF
6 votes
2 answers
410
In functional dependency Armstrong inference rules refers toReflexive, Augmentation and DecompositionTransitive, Augmentation and ReflexiveAugmentation, Transitive, Refle...
2 votes
2 answers
411
4 votes
2 answers
412
BCNF is not used for cases where a relation hasTwo (or more) candidate keysTwo candidate keys and compositeThe candidate key overlapTwo mutually exclusive foreign keys
5 votes
2 answers
413
Armstrong’s inference rule doesnot determineReflexivityAugmentationTransitivityMutual dependency
0 votes
2 answers
414
1 votes
3 answers
417
A relation R={A,B,C,D,E,F,G} is given with following set of functional dependencies: F={AD→E, BE→F, B→C, AF→G}. Which of the following is a candidate key?AABABCAB...
2 votes
1 answer
418
A locked DB file can bea)accessed by only 1 userb)modified by user with correct passwordsc)used to hide sensitive informationd)Update by more than 1 user