Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Slides
Recent questions tagged database-normalization
3
votes
4
answers
121
UGC NET CSE | January 2017 | Part 3 | Question: 10
For 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 are: $A \rightarrow C$ $B \rightarrow D$ ... normal form Second normal form but not in third normal form. Both in second normal form as well as in third normal form.
For 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 infer...
go_editor
1.0k
views
go_editor
asked
Mar 24, 2020
Databases
ugcnetcse-jan2017-paper3
databases
database-normalization
+
–
17
votes
3
answers
122
GATE CSE 2020 | Question: 36
Consider a relational table $R$ that is in $3NF$, but not in BCNF. Which one of the following statements is TRUE? $R$ has a nontrivial functional dependency $X \rightarrow A$, where $X$ is not a superkey and $A$ is a prime attribute. $R$ has a ... a non-prime attribute and $X$ is a proper subset of some key A cell in $R$ holds a set instead of an atomic value.
Consider a relational table $R$ that is in $3NF$, but not in BCNF. Which one of the following statements is TRUE?$R$ has a nontrivial functional dependency $X \rightarrow...
Arjun
6.8k
views
Arjun
asked
Feb 12, 2020
Databases
gatecse-2020
databases
database-normalization
2-marks
+
–
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
Satbir
9.2k
views
Satbir
asked
Jan 13, 2020
Databases
isro-2020
databases
database-normalization
easy
+
–
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...
gatecse
321
views
gatecse
asked
Aug 4, 2019
Databases
kpgcet-cse-2019
databases
database-normalization
+
–
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
gatecse
484
views
gatecse
asked
Aug 4, 2019
Others
kpgcet-cse-2019
database-normalization
databases
+
–
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...
Arjun
3.2k
views
Arjun
asked
Jul 2, 2019
Databases
ugcnetcse-june2019-paper2
database-normalization
+
–
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
Tuhin Dutta
2.4k
views
Tuhin Dutta
asked
May 27, 2019
Databases
databases
database-normalization
rdbms
+
–
2
votes
2
answers
128
Made Easy Test Series: Database-Normalization
Consider the relation $R\left ( A,B,C,D,E \right )$ with functional dependencies $F=${ $A\rightarrow B$ $BC\rightarrow E$ $ED\rightarrow A$ } Number of additional relation required to convert it into lossless , dependency preserving $3NF$ decomposition is _____________ What is meaning of additional relation (Here no table mentioned previously)??
Consider the relation $R\left ( A,B,C,D,E \right )$ with functional dependencies$F=${$A\rightarrow B$$BC\rightarrow E$$ED\rightarrow A$}Number of additional relation requ...
srestha
1.3k
views
srestha
asked
May 19, 2019
Databases
databases
made-easy-test-series
database-normalization
+
–
1
votes
2
answers
129
dbms normalization - 2nf/bcnf query
Consider the following relational schemes: R(A, B, C, D, E, F) and S(A, B, C) with in the following functional dependencies: I. AB --> C II. C --> ABDE III. ADE --> F Assume {A,B} is the key for both schemes. Which of the ... C is the relation for the S table, which satisfies BCNF properties. (So S is in BCNF) Please let me know if it is correct or not.
Consider the following relational schemes: R(A, B, C, D, E, F) and S(A, B, C) with in the following functional dependencies:I. AB CII. C ABDEIII. ADE FAssume {A,B} ...
pritam946
1.1k
views
pritam946
asked
May 10, 2019
Databases
database-normalization
databases
+
–
6
votes
5
answers
130
Made Easy Test Series:DBMS-Functional Dependency
Consider a relation $R\left ( A,B,C,D,E \right )$ and functional dependencies are $F=\left \{ AC\rightarrow B,C\rightarrow D,A\rightarrow E,C\rightarrow B \right \}$ Relation $R$ ... Then Is it a lossless decomposition? I am getting doubt, how it can be not lossless decomposition?
Consider a relation $R\left ( A,B,C,D,E \right )$ and functional dependencies are $F=\left \{ AC\rightarrow B,C\rightarrow D,A\rightarrow E,C\rightarrow B \right \}$Relat...
srestha
1.5k
views
srestha
asked
Apr 28, 2019
Databases
database-normalization
databases
lossless-decomposition
+
–
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
aditi19
1.9k
views
aditi19
asked
Apr 14, 2019
Databases
database-normalization
databases
bcnf-decomposition
bcnf
+
–
1
votes
1
answer
132
made easy test series - lossless join and dependency preserving
How is A answer?
How is A answer?
amitqy
1.0k
views
amitqy
asked
Apr 7, 2019
Databases
lossless-decomposition
databases
dependency-preserving
database-normalization
+
–
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 ...
ashunimbz
442
views
ashunimbz
asked
Mar 30, 2019
Databases
database-normalization
relational-model
+
–
2
votes
1
answer
134
self-doubt
Consider 2 tables R1 and R2 . If we perform a cross product between them the condition that should be satisfied for not generating spurious tuples is both should have a common element which should be a 1>primary key 2>candidate key 3>super key In one of the tables which of the three is correct??
Consider 2 tables R1 and R2 .If we perform a cross product between them the condition that should be satisfied for not generating spurious tuples is both should have a co...
Doraemon
398
views
Doraemon
asked
Mar 19, 2019
Databases
databases
database-normalization
+
–
2
votes
2
answers
135
Gate: Normalization
Consider a relation $R (A, B, C, D, E, F, G, H) $ where each attribute is atomic, and following functional dependencies exist. Following relation is in $1 NF, $ I help me to decompose relation into $BCNF$ $CH\rightarrow G$ $A\rightarrow BC$ $B\rightarrow CFH$ $E \rightarrow A$ $F\rightarrow EG$
Consider a relation $R (A, B, C, D, E, F, G, H) $ where each attribute is atomic, and following functional dependencies exist.Following relation is in $1 NF, $ I help...
anusuccess
1.5k
views
anusuccess
asked
Feb 11, 2019
Databases
database-normalization
+
–
24
votes
2
answers
136
GATE CSE 2019 | Question: 32
Let the set of functional dependencies $F=\{QR \rightarrow S, \: R \rightarrow P, \: S \rightarrow Q \}$ hold on a relation schema $X=(PQRS)$. $X$ is not in BCNF. Suppose $X$ is decomposed into two schemas $Y$ and $Z$ ... and $Z$ is dependency preserving and lossless Which of the above statements is/are correct? Both I and II I only II only Neither I nor II
Let the set of functional dependencies $F=\{QR \rightarrow S, \: R \rightarrow P, \: S \rightarrow Q \}$ hold on a relation schema $X=(PQRS)$. $X$ is not in BCNF. Suppose...
Arjun
13.4k
views
Arjun
asked
Feb 7, 2019
Databases
gatecse-2019
databases
database-normalization
2-marks
+
–
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
Reshu $ingh
2.0k
views
Reshu $ingh
asked
Jan 28, 2019
Databases
databases
database-normalization
made-easy-test-series
+
–
1
votes
1
answer
138
MadeEasy Workbook: Databases - Database Normalization
Find the highest normal form. AB - - > CE E - - >AB C-->D Doubt AB, E are the candidate key. The answer given is 2NF In 2NF, there should be no partial dependency which is PRIME ATTRIBUTE - - >NON PRIME ATTRIBUTE But it is there in AB-->CE, I think CE is non prime attribute. Or bcoz of E we consider them as prime attribute.
Find the highest normal form.AB - - CEE - - >ABC >DDoubtAB, E are the candidate key.The answer given is 2NFIn 2NF, there should be no partial dependency which isPRIME AT...
Jyoti Kumari97
510
views
Jyoti Kumari97
asked
Jan 25, 2019
Databases
made-easy-booklet
databases
database-normalization
+
–
1
votes
1
answer
139
MadeEasy Workbook: Databases - Database Normalization
Jyoti Kumari97
743
views
Jyoti Kumari97
asked
Jan 23, 2019
Databases
databases
made-easy-booklet
database-normalization
+
–
2
votes
1
answer
140
Normal forms
Select the ‘False’ statement from the following statements about Normal Forms: 1. BCNF is stronger than 3NF 2. Lossless preserving decomposition into BCNF is always possible 3. Any Relation with two attributes is in BCNF 4. Lossless preserving decomposition into 3NF is always possible
Select the ‘False’ statement from the following statements about Normal Forms:1. BCNF is stronger than 3NF2. Lossless preserving decomposition into BCNF is always po...
Hardik Vagadia
1.1k
views
Hardik Vagadia
asked
Jan 21, 2019
Databases
databases
database-normalization
+
–
2
votes
0
answers
141
Ace Test Series: DBMS - Functional Dependency
Na462
905
views
Na462
asked
Jan 21, 2019
Databases
database-normalization
databases
ace-test-series
+
–
0
votes
0
answers
142
self doubt - NO. of tables after normalizing
Are 3NF decompostions and BCNF decompostions unique? Are 4NF important for GATE (since I've left them :( ) See, I am asking this question because I want to know whether they'll ask about no. of tables we get after normalizing upto 3nf or bcnf. Now ... I am in a bit hurry to search for that.. so please forgive me if it has been already asked.) Thank you.
Are 3NF decompostions and BCNF decompostions unique? Are 4NF important for GATE (since I’ve left them :( )See, I am asking this question because I want to know whethe...
Harsh Kumar
385
views
Harsh Kumar
asked
Jan 21, 2019
Databases
databases
relational
database-normalization
bcnf-decomposition
3nf-decomposition
+
–
1
votes
1
answer
143
GATE 1997-2.7 Small change in given data
Consider the schema R = (S T U V) and the dependencies S → T, T → U, U → V and V → S. Let R = (R1 and R2) be a decomposition such that R1 ∩ R2 = ϕ. (In the actual gate question it was R1∩R2 ≠ ϕ) The decomposition is:- not in 2NF in 2NF but not 3NF in 3NF but not in 2NF in both 2NF and 3NF
Consider the schema R = (S T U V) and the dependencies S → T, T → U, U → V and V → S. Let R = (R1 and R2) be a decomposition such that R1 ∩ R2 = ϕ. (In the act...
Sukhbir Singh
1.2k
views
Sukhbir Singh
asked
Jan 21, 2019
Databases
usergate-1997
database-normalization
databases
+
–
0
votes
1
answer
144
MadeEasy Test Series 2019: Databases - Database Normalization
A3 also deriving {A1,A2,A3} from FD’s...why it is still neglecting BCNF? Is solution wrong or I am misunderstanding?
A3 also deriving {A1,A2,A3} from FD’s...why it is still neglecting BCNF? Is solution wrong or I am misunderstanding?
Naveen Muralidhar
546
views
Naveen Muralidhar
asked
Jan 20, 2019
Databases
database-normalization
databases
made-easy-test-series
+
–
0
votes
0
answers
145
Ace Material
Business Rules : An employee may work in many departments. Each employee has a unique employee number. Each departments has many managers. An employee has only one manager for each department Each manager can manage only one department. Each employee has only one Name. ... HOW? NOTE : according to the solution eid should be the primary key. BUT how can you find manager with only eid?
Business Rules : An employee may work in many departments.Each employee has a unique employee number.Each departments has many managers.An employee has only one manager f...
OneZero
282
views
OneZero
asked
Jan 17, 2019
Databases
database-normalization
databases
+
–
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...
Applied Course
519
views
Applied Course
asked
Jan 16, 2019
Databases
applied-course-2019-mock1
databases
database-normalization
+
–
2
votes
1
answer
147
Ace 2019
Dependency preserving/Lossless ?
Dependency preserving/Lossless ?
balchandar reddy san
591
views
balchandar reddy san
asked
Jan 9, 2019
Databases
gb2019-gt-dbms
databases
database-normalization
+
–
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. �...
zeeshanmohnavi
433
views
zeeshanmohnavi
asked
Jan 5, 2019
Databases
database-normalization
databases
+
–
3
votes
3
answers
149
MadeEasy Test Series: Databases - Database Normalization
Consider a database with the following relation: Shipping (ShipName, ShipType, TripId, Cargo, Port. Date) With the following functional dependencies: sorry for not typing ,i will type it later my doubt is-isn’t partial dependency $ShipName\rightarrow ShipType$ present in new database??
Consider a database with the following relation:Shipping (ShipName, ShipType, TripId, Cargo, Port. Date)With the following functional dependencies:sorry for not typing ,i...
Prateek Raghuvanshi
2.5k
views
Prateek Raghuvanshi
asked
Jan 5, 2019
Databases
databases
database-normalization
made-easy-test-series
+
–
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{...
admin
477
views
admin
asked
Jan 5, 2019
Databases
uppcl2018
databases
database-normalization
functional-dependency
+
–
Page:
« prev
1
2
3
4
5
6
7
8
9
10
...
18
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register