Register

KPGCET-CSE-2019-8

• retagged by
718 views
0 0 votes

 Couple of the good database design principles suggest that preservation and minimization of functional dependencies. These issues can be resolved by

  1. Eliminating transitive functional dependencies
  2. Eliminating all interrelationship between all attributes
  3. Minimizing candidate keys
  4. None of these 

1 Answer

Voting & Accepting an answer helps improve the community
← Previous · KPGCET-CSE-2019-9Next → · KPGCET-CSE-2019-7
← Previous in category · KPGCET-CSE-2019-9Next in category → · KPGCET-CSE-2019-6
Position:
Show:

Related questions

0 0 votes
0 0 answers
257
257 views
gatecse asked Aug 4, 2019
257 views
KPGCET-CSE-2019-44
The decomposition of a relation R of relational DBMS into two relations $RI(X)$ & $R2(Y)$ is lossless if$X \cap Y X-Y \text{ or } X \cap Y Y-X \text{ is in }F^+$$X – Y ...
0 0 votes
1 1 answer
705
705 views
soujanyareddy13 asked Jan 9, 2022
705 views
NIELIT 2021 Dec Scientist A - Section B: 57
Consider a relation $\text{R}$ with attributes $\{ \text{A, B, C} \}$ and functional dependency set $\text {S= \{ A} \rightarrow \text{B, } \text{A} \rightarrow \text{C} ...
0 0 votes
1 1 answer
638
638 views
gatecse asked Aug 4, 2019
638 views
KPGCET-CSE-2019-4
The schema for the entire database is designed using Data definitional languageStructured query languageData manipulation language Schema structure language
0 0 votes
1 1 answer
582
582 views
gatecse asked Aug 4, 2019
582 views
KPGCET-CSE-2019-9
The normalization is a way to implementGood software engineering principlesGood database design principlesStructured Query LanguageDatabase Schema