Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Slides
Recent questions tagged database-normalization
0
votes
1
answer
31
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
379
views
admin
asked
Jul 28, 2023
Databases
ugcnetcse-june2023-paper2
database-normalization
question-fixed
+
–
0
votes
1
answer
32
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
291
views
Mrityudoot
asked
Jul 28, 2023
Databases
functional-dependency
databases
database-normalization
+
–
0
votes
1
answer
33
2NF DECOMPOSITION
ROMITDUTTA
214
views
ROMITDUTTA
asked
Jul 5, 2023
Databases
databases
database-normalization
decomposition
normal-forms
+
–
2
votes
1
answer
34
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
672
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
35
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
648
views
vivek1211
asked
Mar 12, 2023
Databases
database-normalization
+
–
0
votes
2
answers
36
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
744
views
Souvik33
asked
Dec 17, 2022
Databases
database-normalization
databases
bcnf
normal-forms
multiple-selects
+
–
1
votes
0
answers
37
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
440
views
admin
asked
Dec 15, 2022
Databases
drdocse-2022-paper2
databases
database-normalization
2-marks
fill-in-the-blanks
+
–
2
votes
2
answers
38
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
393
views
admin
asked
Dec 15, 2022
Databases
drdocse-2022-paper2
databases
database-normalization
2-marks
fill-in-the-blanks
+
–
1
votes
0
answers
39
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
262
views
admin
asked
Dec 15, 2022
Databases
drdocse-2022-paper2
databases
database-normalization
1-mark
descriptive
+
–
2
votes
3
answers
40
#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.0k
views
Sunnidhya Roy
asked
Dec 13, 2022
Databases
database-normalization
bcnf
+
–
2
votes
1
answer
41
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
293
views
h4kr
asked
Dec 8, 2022
Theory of Computation
database-normalization
bcnf
+
–
1
votes
0
answers
42
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
402
views
JAINchiNMay
asked
Dec 1, 2022
Databases
self-doubt
databases
database-normalization
true-false
+
–
0
votes
1
answer
43
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
597
views
Chaitanya Kale
asked
Nov 1, 2022
Databases
database-normalization
made-easy-test-series
relational-model
+
–
0
votes
1
answer
44
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
399
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