Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Slides
Recent questions tagged database-normalization
0
votes
0
answers
31
Finding minimum number of tables needed to represent ER diagram
Find minimum number of tables needed to represent following ER diagram? This question would have been relatively simple as we would implicitly convert the ERD to 3NF (asked in GATE 2008). But what if the questions asks us to find minimum tables needed to represent above ERD in 1NF or 2NF?. What would our approach will be in that case?
Find minimum number of tables needed to represent following ER diagram?This question would have been relatively simple as we would implicitly convert the ERD to 3NF (aske...
rexritz
501
views
rexritz
asked
Aug 29, 2023
Databases
er-diagram
databases
normal-forms
database-normalization
+
–
0
votes
1
answer
32
UGC NET CSE | June 2023 | Part 2: 19
Let $\text{R (A,B,C,D,E,F)}$ be a relational schema with following functional dependencies: $\mathrm{C} \rightarrow \mathrm{F}, \mathrm{E} \rightarrow \mathrm{A}, \mathrm{EC} \rightarrow \mathrm{D}, \mathrm{A} \rightarrow \mathrm{B}$. Which of the following is a key for $\mathrm{R}$ ? $\text{CD}$ $\text{EC}$ $\mathrm{AE}$ $\mathrm{AC}$
Let $\text{R (A,B,C,D,E,F)}$ be a relational schema with following functional dependencies:$\mathrm{C} \rightarrow \mathrm{F}, \mathrm{E} \rightarrow \mathrm{A}, \mathrm{...
admin
396
views
admin
asked
Jul 28, 2023
Databases
ugcnetcse-june2023-paper2
database-normalization
question-fixed
+
–
0
votes
1
answer
33
DBMS Functional Dependencies
Will a single attribute key considered as a prime attribute as well? I know If it is a compound key like (ABC) then my prime attribute set would be {A,B,C,AB,BC,AC} But if I have only 1 Candidate key in my relation (A) then will A ... or not? Also if multiple single attribute keys are there then what happens (Say {A}, {B} are both candidates) with the prime attributes?
Will a single attribute key considered as a prime attribute as well?I know If it is a compound key like (ABC) then my prime attribute set would be {A,B,C,AB,BC,AC}But if ...
Mrityudoot
316
views
Mrityudoot
asked
Jul 28, 2023
Databases
functional-dependency
databases
database-normalization
+
–
0
votes
1
answer
34
2NF DECOMPOSITION
ROMITDUTTA
218
views
ROMITDUTTA
asked
Jul 5, 2023
Databases
databases
database-normalization
decomposition
normal-forms
+
–
2
votes
1
answer
35
GO Classes 2023 | IIITH Mock Test 1 | Question: 46
Consider a relation schema $\mathrm{R}$ with attributes $(\mathrm{X}, \mathrm{Y}, \mathrm{Z}, \mathrm{U}, \mathrm{V}, \mathrm{W})$ and the functional dependency set $\mathrm{F}$ that holds on $\mathrm{R}:$ ... . Decomposition is dependency preserving. $\text{P}$ is in $3 \mathrm{NF}$. $\mathrm{S}$ is in $3 \mathrm{NF}$.
Consider a relation schema $\mathrm{R}$ with attributes $(\mathrm{X}, \mathrm{Y}, \mathrm{Z}, \mathrm{U}, \mathrm{V}, \mathrm{W})$ and the functional dependency set $\mat...
GO Classes
861
views
GO Classes
asked
Mar 26, 2023
Databases
goclasses2023-iiith-mock-1
goclasses
databases
database-normalization
lossless-decomposition
dependency-preserving
multiple-selects
1-mark
+
–
0
votes
1
answer
36
functional dependency
given an instance of relation R(ABC). find all non-trivial FDsare AB->C, AC->B, BC→ A true ??
given an instance of relation R(ABC). find all non-trivial FDsare AB->C, AC->B, BC→ A true ??
vivek1211
671
views
vivek1211
asked
Mar 12, 2023
Databases
database-normalization
+
–
0
votes
2
answers
37
Database Relations | Heighest normal form
MSQ A relation R(A,B,C,D) has only trivial functional dependencies of the form ( A→A, AB→AB,ABC→A, etc) Then consider the following options: The relation is surely in BCNF The relation is surely in 3NF The relation is surely in 2NF None of the above
MSQ A relation R(A,B,C,D) has only trivial functional dependencies of the form ( A→A, AB→AB,ABC→A, etc)Then consider the following options:The relation is surely in...
Souvik33
787
views
Souvik33
asked
Dec 17, 2022
Databases
database-normalization
databases
bcnf
normal-forms
multiple-selects
+
–
1
votes
0
answers
38
DRDO CSE 2022 Paper 2 | Question: 15 (a)
Answer the following. __________ is the operation that reverses the normalization to denormalization form.
Answer the following.__________ is the operation that reverses the normalization to denormalization form.
admin
454
views
admin
asked
Dec 15, 2022
Databases
drdocse-2022-paper2
databases
database-normalization
2-marks
fill-in-the-blanks
+
–
2
votes
2
answers
39
DRDO CSE 2022 Paper 2 | Question: 15 (b)
Answer the following. ___________ removes all the rows of the given table.
Answer the following.___________ removes all the rows of the given table.
admin
411
views
admin
asked
Dec 15, 2022
Databases
drdocse-2022-paper2
databases
database-normalization
2-marks
fill-in-the-blanks
+
–
1
votes
0
answers
40
DRDO CSE 2022 Paper 2 | Question: 15 (c)
Answer the following. Which of the following are not keys in the database? Compliment * Agreement Construct Supplement
Answer the following.Which of the following are not keys in the database?Compliment *AgreementConstructSupplement
admin
268
views
admin
asked
Dec 15, 2022
Databases
drdocse-2022-paper2
databases
database-normalization
1-mark
descriptive
+
–
2
votes
3
answers
41
#Self Doubt
A Relation R is in 3NF and have only 1 Candidate Key(may or may not be composite), then R is in BCNF. True or False??
A Relation R is in 3NF and have only 1 Candidate Key(may or may not be composite), then R is in BCNF. True or False??
Sunnidhya Roy
2.1k
views
Sunnidhya Roy
asked
Dec 13, 2022
Databases
database-normalization
bcnf
+
–
2
votes
1
answer
42
What should the answer be?
I think the answer should be (B) would be right, because lets say in R, there is a FD NPA -> CK, it won't qualify as BCNF even if CK is single attribute
I think the answer should be (B) would be right, because lets say in R, there is a FD NPA - CK, it won't qualify as BCNF even if CK is single attribute
h4kr
304
views
h4kr
asked
Dec 8, 2022
Theory of Computation
database-normalization
bcnf
+
–
1
votes
0
answers
43
self doubt
Any attribute(s) determining a prime attribute, automatically becomes a prime(s) attribute True or false
Any attribute(s) determining a prime attribute, automatically becomes a prime(s) attributeTrue or false
JAINchiNMay
443
views
JAINchiNMay
asked
Dec 1, 2022
Databases
self-doubt
databases
database-normalization
true-false
+
–
0
votes
1
answer
44
Normalisation
Consider a relation R with more than two attributes. Let A and B are sets of attributes from R and A$\cap$B = $\phi$. Functional dependency A → B holds on R. Which one of the following can be a correct possible situation for R? A and B contain prime and non-prime ... do we need to assume that all the functional dependencies holding on R are of type A → B such that A$\cap$B = $\phi$?
Consider a relation R with more than two attributes. Let A and B are sets of attributes from R and A$\cap$B = $\phi$. Functional dependency A → B holds on R. Which one ...
Chaitanya Kale
635
views
Chaitanya Kale
asked
Nov 1, 2022
Databases
database-normalization
made-easy-test-series
relational-model
+
–
0
votes
1
answer
45
UGC NET CSE | October 2022 | Part 1 | Question: 53
Match List I with List II : ... $\text{(A)-(II), (B)-(I), (C)-(IV), (D)-(III)}$
Match List I with List II :$\begin{array}{ll} \text{List I} & \text{List II} \\ \\\text {(A) BCNF } & \text { (I) It removes multivalued dependency } \\\text {(B) 3} \mat...
admin
427
views
admin
asked
Oct 23, 2022
Databases
ugcnetcse-oct2022-paper1
database-normalization
+
–
Page:
« prev
1
2
3
4
5
6
7
...
18
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register