Register

Recent questions tagged database-normalization

5 votes
12 answers
123
ISRO2020-50
If every non-key attribute functionally dependent on the primary key, then the relation will be in First normal form Second normal form Third normal form Fourth Normal form
If every non-key attribute functionally dependent on the primary key, then the relation will be inFirst normal formSecond normal formThird normal formFourth Normal form
User Avatar
2 votes
0 answers
124
KPGCET-CSE-2019-3
The process of normalization is used to Enhance the number of relations Determine the relationship between different relations Minimize the redundancies & eliminate anomalies Ease the computational work.
The process of normalization is used toEnhance the number of relations Determine the relationship between different relations Minimize the redundancies & eliminate anomal...
User Avatar
0 votes
2 answers
125
KPGCET-CSE-2019-74
The multivalued dependencies (MVDs) can be eliminated using ______ normal form on _____ normal form relations. $1$st, $2$nd $2$nd, $3$rd $3$rd, BCNF $4$th, BCNF
The multivalued dependencies (MVDs) can be eliminated using ______ normal form on _____ normal form relations.$1$st, $2$nd$2$nd, $3$rd$3$rd, BCNF$4$th, BCNF
User Avatar
5 votes
5 answers
126
UGC NET CSE | June 2019 | Part 2 | Question: 34
In relational databases, if relation R is in BCNF, then which of the following is true about relation R? R is in 4NF R is not in 1NF R is in 2NF and not in 3NF R is in 2NF and 3NF
In relational databases, if relation R is in BCNF, then which of the following is true about relation R?R is in 4NFR is not in 1NFR is in 2NF and not in 3NFR is in 2NF an...
User Avatar
4 votes
4 answers
127
Doubt on database normalization for relation having all prime attributes
In a relation, if every attribute is prime but key may not be simple then the relation is in ______. A. 1NF B. 2NF C. 3NF D. BCNF
In a relation, if every attribute is prime but key may not be simple then the relation is in ______.A. 1NFB. 2NFC. 3NFD. BCNF
User Avatar
1 votes
2 answers
131
Molina Exercise-3.3 BCNF decomposition
Decompose into BCNF R(A, B, C, D, E) FD: AB->C, C->D, D>B, D->E
Decompose into BCNFR(A, B, C, D, E)FD: AB->C, C->D, D>B, D->E
User Avatar
1 votes
1 answer
133
Doubt
Do we need to find closure of functional dependencies of original relation to check whether the decomposed tables are in 2NF . I know that we have to do the above process for 3NF and BCNF . If yes , please give a example where we need to do it
Do we need to find closure of functional dependencies of original relation to check whether the decomposed tables are in 2NF .I know that we have to do the above process ...
User Avatar
4 votes
2 answers
137
#MadeEasyTestSeries
S: If a relation R is in 3NF but not in BCNF then relation R must consist atleast 2 overlapped candidate keys. True/False
S: If a relation R is in 3NF but not in BCNF then relation R must consist atleast 2 overlapped candidate keys.True/False
User Avatar
1 votes
1 answer
146
Applied Course | Mock GATE | Test 1 | Question: 46
Consider the relation Parts $\text{(Partno, SupplierID, Partname, Model)}$, with $\text{{Partno, SupplierID}}$ ... $3NF$ Relation Parts is in $3NF$ but not in $BCNF$ Relation Parts is in $BCNF$ but not in $4NF$
Consider the relation Parts $\text{(Partno, SupplierID, Partname, Model)}$, with $\text{{Partno, SupplierID}}$ as the primary key. Suppose the following functional depend...
User Avatar
2 votes
1 answer
147
Ace 2019
Dependency preserving/Lossless ?
Dependency preserving/Lossless ?
User Avatar
1 votes
0 answers
148
Self-doubt | DBMS | Functional Dependency
Can someone explain the paragraph marked based on relation $r$ given in Figure 7.2? Reference: Database System Concepts by Silberschatz, Korth, Sudarshan 4th Edition. ​​​​​
Can someone explain the paragraph marked based on relation $r$ given in Figure 7.2?Reference: Database System Concepts by Silberschatz, Korth, Sudarshan 4th Edition. ​�...
User Avatar
0 votes
1 answer
150
UPPCL AE 2018:63
We have a database table with relational schema $\text{R(XYZPQ)}:$ ... dependency. $\text{Y} \rightarrow \text{X}$ is a functional dependency. None of the above $\text{YZ} \rightarrow \text{P}$ is a functional dependency.
We have a database table with relational schema $\text{R(XYZPQ)}:$$$\begin{array}{|c|c|c|c|c|} \hline \text{X} & \text{Y} & \text{Z} & \text{P} & \text{Q} \\\hline \text{...
User Avatar
Page: