Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Slides
Recent questions tagged database-normalization
3
votes
1
answer
91
Applied Test Series
A multi-cuisine restaurant maintains the database of ingredients that are most commonly used in their dishes. The Schema of the relation Dishes is given as: Dishes (Food_item, Taste_of_food, Type_of_cuisine, Ingredient1, Ingredient2, Ingredient3); ... are {Food_item, Taste_of_food}, {Food_item, Type_of_cuisine}. The possible super keys for the given relation are ________
A multi-cuisine restaurant maintains the database of ingredients that are most commonly used in their dishes. The Schema of the relation “Dishes” is given as:Dishes (...
LRU
514
views
LRU
asked
Nov 11, 2021
Databases
test-series
databases
database-normalization
+
–
1
votes
2
answers
92
gradeup quiz question
please explain the question
please explain the question
ajay_rajpurohit
398
views
ajay_rajpurohit
asked
Oct 4, 2021
Databases
rdbms
database-normalization
+
–
0
votes
0
answers
93
Random Question paper
Consider schedules S3, S4, and S5 below. Determine whether each schedule is strict, cascadeless, recoverable, or nonrecoverable. (Determine the strictest recoverability condition that each schedule satisfies). S3: r1 (X); r2 (Z); r1 (Z); r3 (X); r3 (Y); w1 (X); c1; w3 (Y); c3; r2 (Y); w2 (Z); w2 ... ); r3 (X); r1 (Z); r2 (Y); r3 (Y); w1 (X); c1; w2 (Z); w3 (Y); w2 (Y); c3; c2;
Consider schedules S3, S4, and S5 below. Determine whether each schedule is strict, cascadeless, recoverable, or nonrecoverable.(Determine the strictest recoverability co...
SidX
1.3k
views
SidX
asked
Sep 26, 2021
Databases
databases
database-normalization
+
–
0
votes
1
answer
94
Random college question paper
Given a relation R(A, B, C, D, E, F, G, H) with keys BD and C and functional dependencies D→G, E→F and H→C, decompose the R into the highest normal form possible.
Given a relation R(A, B, C, D, E, F, G, H) with keys BD and C and functional dependenciesD→G, E→F and H→C, decompose the R into the highest normal form possible.
SidX
493
views
SidX
asked
Sep 26, 2021
Databases
databases
database-normalization
tbb-dbms-2
+
–
0
votes
0
answers
95
DBMS, School Assignment
Consider an EMPLOYEE file with 10000 records where each record is of size 80 bytes. The file is sorted on employee number (15 bytes long), which is the primary key. Assuming un-spanned organization, block size of 512 bytes and block pointer size of 5 ... for retrieving an employee record based on employee number if (i) No index is used (ii) Multi-level primary index is used.
Consider an EMPLOYEE file with 10000 records where each record is of size 80 bytes. The file is sorted on employee number (15 byteslong), which is the primary key. Assumi...
SidX
666
views
SidX
asked
Sep 26, 2021
Databases
databases
database-normalization
+
–
18
votes
3
answers
96
GATE CSE 2021 Set 2 | Question: 40
Suppose the following functional dependencies hold on a relation $U$ with attributes $P,Q,R,S$, and $T$: $P \rightarrow QR$ $RS \rightarrow T$ Which of the following functional dependencies can be inferred from the above functional dependencies? $PS \rightarrow T$ $R \rightarrow T$ $P \rightarrow R$ $PS \rightarrow Q$
Suppose the following functional dependencies hold on a relation $U$ with attributes $P,Q,R,S$, and $T$:$P \rightarrow QR$$RS \rightarrow T$Which of the following functio...
Arjun
7.5k
views
Arjun
asked
Feb 18, 2021
Databases
gatecse-2021-set2
multiple-selects
databases
database-normalization
2-marks
+
–
27
votes
5
answers
97
GATE CSE 2021 Set 1 | Question: 33
Consider the relation $R(P,Q,S,T,X,Y,Z,W)$ with the following functional dependencies. $PQ\rightarrow X;\quad P\rightarrow YX;\quad Q\rightarrow Y; \quad Y\rightarrow ZW$ Consider the decomposition of the relation $R$ into the ... $D_2$ is a lossless decomposition Both $D_1$ and $D_2$ are lossless decompositions Both $D_1$ and $D_2$ are lossy decompositions
Consider the relation $R(P,Q,S,T,X,Y,Z,W)$ with the following functional dependencies.$$PQ\rightarrow X;\quad P\rightarrow YX;\quad Q\rightarrow Y; \quad Y\rightarrow ZW$...
Arjun
13.8k
views
Arjun
asked
Feb 18, 2021
Databases
gatecse-2021-set1
databases
database-normalization
2-marks
+
–
2
votes
1
answer
98
NIELIT Scientific Assistant A 2020 November: 72
Let $\text{R=(A,B,C,D,E)}$ having following $\text{FDs}.\;\text{F}=\{\text{A}\rightarrow \text{BC, CD} \rightarrow \text{E, B}\rightarrow \text{D, E}\rightarrow \text{A}\}.$ Which of the following is not a Candidate key? $\text{A}$ $\text{B}$ $\text{E}$ $\text{BC}$
Let $\text{R=(A,B,C,D,E)}$ having following $\text{FDs}.\;\text{F}=\{\text{A}\rightarrow \text{BC, CD} \rightarrow \text{E, B}\rightarrow \text{D, E}\rightarrow \text{A}\...
gatecse
446
views
gatecse
asked
Dec 9, 2020
Databases
nielit-sta-2020
databases
database-normalization
candidate-key
+
–
1
votes
1
answer
99
NIELIT Scientific Assistant A 2020 November: 73
Anomalies are avoided by splitting the offending relation into multiple relations, is also known as __________. Accupressure Decomposition Precomposition Both decomposition & precomposition
Anomalies are avoided by splitting the offending relation into multiple relations, is also known as __________.AccupressureDecompositionPrecompositionBoth decomposition &...
gatecse
497
views
gatecse
asked
Dec 9, 2020
Databases
nielit-sta-2020
databases
database-normalization
+
–
2
votes
1
answer
100
NIELIT Scientific Assistant A 2020 November: 86
A minimal super key (i.e, one of the super keys for which no proper subset is a superkey) is called: Super Key Candidate Key Primary Key Both Candidate and Primary Key
A minimal super key (i.e, one of the super keys for which no proper subset is a superkey) is called:Super KeyCandidate KeyPrimary KeyBoth Candidate and Primary Key
gatecse
496
views
gatecse
asked
Dec 9, 2020
Databases
nielit-sta-2020
databases
database-normalization
candidate-key
+
–
1
votes
2
answers
101
NIELIT Scientific Assistant A 2020 November: 97
Domain constraints, functional dependency and referential integrity are special forms of _______ Foreign key Primary key Assertion Referential constraint
Domain constraints, functional dependency and referential integrity are special forms of _______Foreign keyPrimary keyAssertionReferential constraint
gatecse
530
views
gatecse
asked
Dec 9, 2020
Databases
nielit-sta-2020
databases
database-normalization
referential-integrity
+
–
2
votes
2
answers
102
NIELIT 2017 OCT Scientific Assistant A (IT) - Section B: 16
For a database relation $R(a,b,c,d)$ where the domains of $a,b,c$ and $d$ include only atomic values, only the following functional dependencies and those that can be inferred from them hold. $a \rightarrow c$ ... form but not in second normal form Second normal form but not in third normal form Third normal form None of the above
For a database relation $R(a,b,c,d)$ where the domains of $a,b,c$ and $d$ include only atomic values, only the following functional dependencies and those that can be inf...
admin
856
views
admin
asked
Apr 1, 2020
Databases
nielit2017oct-assistanta-it
databases
database-normalization
+
–
4
votes
3
answers
103
NIELIT 2016 MAR Scientist B - Section C: 43
Let $R=(A,B,C,D,E,F)$ be a relation scheme with the following dependencies: $C\to F,E\to a,EC\to D, A\to B$. Which of the following is a key for $R$? $CD$ $EC$ $AE$ $AC$
Let $R=(A,B,C,D,E,F)$ be a relation scheme with the following dependencies:$C\to F,E\to a,EC\to D, A\to B$.Which of the following is a key for $R$?$CD$$EC$$AE$$AC$
admin
988
views
admin
asked
Mar 31, 2020
Databases
nielit2016mar-scientistb
database-normalization
candidate-key
+
–
2
votes
3
answers
104
NIELIT 2016 MAR Scientist B - Section C: 44
For a database relation $R(a,b,c,d)$ where the domains of $a,b,c,d$ include only atomic values, only the following functional dependencies and those that can be inferred from them hold: $a\to c\\b\to d$ the relation is in first normal form but not in second normal form. second normal form but not in third normal form. third normal form. none of these.
For a database relation $R(a,b,c,d)$ where the domains of $a,b,c,d$ include only atomic values, only the following functional dependencies and those that can be inferred ...
admin
1.1k
views
admin
asked
Mar 31, 2020
Databases
nielit2016mar-scientistb
databases
database-normalization
+
–
0
votes
2
answers
105
NIELIT 2016 DEC Scientist B (IT) - Section B: 14
Normalization from which is based on transitive dependency is classified as: First normal form. Second normal form. Fourth normal form. Third normal form.
Normalization from which is based on transitive dependency is classified as:First normal form.Second normal form.Fourth normal form.Third normal form.
admin
934
views
admin
asked
Mar 31, 2020
Databases
nielit2016dec-scientistb-it
databases
database-normalization
+
–
0
votes
2
answers
106
NIELIT 2016 DEC Scientist B (IT) - Section B: 40
In functional dependency between two sets of attribute $A$ and $B$ then set of attributes $A$ of database is classified as: top right side down left side left hand side right hand side
In functional dependency between two sets of attribute $A$ and $B$ then set of attributes $A$ of database is classified as:top right sidedown left sideleft hand sideright...
admin
3.5k
views
admin
asked
Mar 31, 2020
Databases
nielit2016dec-scientistb-it
databases
database-normalization
+
–
2
votes
2
answers
107
NIELIT 2016 DEC Scientist B (IT) - Section B: 44
Which one of the following statements about normal forms is FALSE? BCNF is stricter than $3$NF. Lossless, dependency-preserving decomposition into BCNF is always possible. Lossless, dependency-preserving decomposition into $3$NF is always possible. Any relation with two attributes is BCNF.
Which one of the following statements about normal forms is FALSE?BCNF is stricter than $3$NF.Lossless, dependency-preserving decomposition into BCNF is always possible.L...
admin
1.5k
views
admin
asked
Mar 31, 2020
Databases
nielit2016dec-scientistb-it
databases
database-normalization
bcnf-decomposition
+
–
1
votes
2
answers
108
NIELIT 2016 DEC Scientist B (IT) - Section B: 57
If attribute of relation schema $R$ is member of some candidate key then this type of attributes are classified as: atomic attribute candidate attribute non-prime attribute prime attribute
If attribute of relation schema $R$ is member of some candidate key then this type of attributes are classified as:atomic attributecandidate attributenon-prime attributep...
admin
4.7k
views
admin
asked
Mar 31, 2020
Databases
nielit2016dec-scientistb-it
databases
database-normalization
+
–
1
votes
2
answers
109
NIELIT 2016 DEC Scientist B (CS) - Section B: 2
Process of analyzing relation schemas to achieve minimal redundancy and insertion or update anomalies is classified as: normalization of data. denomination of data. isolation of data. de-normalization of data.
Process of analyzing relation schemas to achieve minimal redundancy and insertion or update anomalies is classified as:normalization of data.denomination of data.isolatio...
admin
4.0k
views
admin
asked
Mar 31, 2020
Databases
nielit2016dec-scientistb-cs
databases
database-normalization
+
–
4
votes
3
answers
110
NIELIT 2016 DEC Scientist B (CS) - Section B: 31
Rule which states that addition of same attributes to right side and left side will result in other valid dependency is classified as referential rule inferential rule augmentation rule reflexive rule
Rule which states that addition of same attributes to right side and left side will result in other valid dependency is classified asreferential ruleinferential ruleaugme...
admin
2.8k
views
admin
asked
Mar 31, 2020
Databases
nielit2016dec-scientistb-cs
databases
database-normalization
+
–
1
votes
2
answers
111
NIELIT 2016 DEC Scientist B (CS) - Section B: 47
If every functional dependency in set $E$ is also in closure of $F$ then this is classified as $FD$ is covered by $E$ $E$ is covered by $F$ $F$ is covered by $E$ $F$ plus is covered by $E$
If every functional dependency in set $E$ is also in closure of $F$ then this is classified as$FD$ is covered by $E$$E$ is covered by $F$$F$ is covered by $E$$F$ plus is ...
admin
1.8k
views
admin
asked
Mar 31, 2020
Databases
nielit2016dec-scientistb-cs
databases
database-normalization
+
–
2
votes
2
answers
112
NIELIT 2016 DEC Scientist B (CS) - Section B: 49
Considering relational database, functional dependency between two attributes $A$ and $B$ is denoted by $A\to B$ $B\gets A$ $AB\to R$ $R\gets AB$
Considering relational database, functional dependency between two attributes $A$ and $B$ is denoted by$A\to B$$B\gets A$$AB\to R$$R\gets AB$
admin
2.5k
views
admin
asked
Mar 31, 2020
Databases
nielit2016dec-scientistb-cs
databases
database-normalization
+
–
4
votes
5
answers
113
NIELIT 2017 DEC Scientist B - Section B: 1
Which one of the following statements are not correct? $S1$: $3$NF decomposition is always lossless join and dependency preserving. $S2$: $3$NF decomposition is always lossless join but may or may not be dependency preserving. $S3$: BCNF decomposition is always ... may not be dependency preserving. Only $S1$ Only $S4$ Both $S1$ and $S4$ Both $S2$ and $S3$
Which one of the following statements are not correct?$S1$: $3$NF decomposition is always lossless join and dependency preserving.$S2$: $3$NF decomposition is always loss...
admin
3.6k
views
admin
asked
Mar 30, 2020
Databases
nielit2017dec-scientistb
database-normalization
bcnf-decomposition
+
–
3
votes
2
answers
114
NIELIT 2017 DEC Scientist B - Section B: 24
Which of the following is TRUE? Every relation in $3$NF is also in BCNF A relation R is in $3$NF if every non-prime attribute of R is fully functionally dependent on every key of R Every relation in BCNF is also in $3$NF No relation can be in both BCNF and $3$NF.
Which of the following is TRUE?Every relation in $3$NF is also in BCNFA relation R is in $3$NF if every non-prime attribute of R is fully functionally dependent on every ...
admin
1.2k
views
admin
asked
Mar 30, 2020
Databases
nielit2017dec-scientistb
database-normalization
bcnf
+
–
0
votes
4
answers
115
NIELIT 2017 DEC Scientist B - Section B: 25
Consider the relational schema $R(A B C D)$ with following $FD$ set $F=\{A \to CE, B \to D, AE \to D\}$. Identify the highest normal form satisfied by the relation $R$. $2$NF BCNF $3$NF $1$NF
Consider the relational schema $R(A B C D)$ with following $FD$ set $F=\{A \to CE, B \to D, AE \to D\}$. Identify the highest normal form satisfied by the relation $R$.$2...
admin
5.1k
views
admin
asked
Mar 30, 2020
Databases
nielit2017dec-scientistb
databases
database-normalization
+
–
3
votes
4
answers
116
NIELIT 2017 DEC Scientist B - Section B: 55
Consider the relational schema $\text{R(A B C D)}$ with following functional dependency set $F=\{A\rightarrow BC,C\rightarrow D\};$ The relation $\text{R}$ is in $2$NF BCNF $3$NF $1$NF
Consider the relational schema $\text{R(A B C D)}$ with following functional dependency set $F=\{A\rightarrow BC,C\rightarrow D\};$ The relation $\text{R}$ is in $2$NFBCN...
admin
3.9k
views
admin
asked
Mar 30, 2020
Databases
nielit2017dec-scientistb
database-normalization
bcnf
+
–
Page:
« prev
1
2
3
4
5
6
7
8
9
...
18
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register