Dark Mode

Recent questions tagged database-normalization

0 votes

1 answer

1

functional dependency
given an instance of relation R(ABC). find all non-trivial FDsare AB->C, AC->B, BC→ A true ??

vivek1211 asked in Databases Mar 12

47 views

0 votes

2 answers

2

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

Souvik33 asked in Databases Dec 17, 2022

198 views

1 vote

0 answers

3

DRDO CSE 2022 Paper 2 | Question: 15 (a)
Answer the following. __________ is the operation that reverses the normalization to denormalization form.

admin asked in Databases Dec 15, 2022

by admin

94 views

2 votes

2 answers

4

DRDO CSE 2022 Paper 2 | Question: 15 (b)
Answer the following. ___________ removes all the rows of the given table.

admin asked in Databases Dec 15, 2022

by admin

109 views

1 vote

0 answers

5

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

admin asked in Databases Dec 15, 2022

by admin

64 views

2 votes

3 answers

6

#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??

Sunnidhya Roy asked in Databases Dec 13, 2022

by Sunnidhya Roy

205 views

2 votes

1 answer

7

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

h4kr asked in Theory of Computation Dec 9, 2022

by h4kr

90 views

1 vote

0 answers

8

self doubt
Any attribute(s) determining a prime attribute, automatically becomes a prime(s) attribute True or false

JAINchiNMay asked in Databases Dec 1, 2022

140 views

0 votes

1 answer

9

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$?

Chaitanya Kale asked in Databases Nov 1, 2022

by Chaitanya Kale

254 views

0 votes

0 answers

10

UGC NET CSE | October 2022 | Part 1 | Question:: 53
Match List I with List II : ... $\text{(A)-(II), (B)-(I), (C)-(IV), (D)-(III)}$

admin asked in Databases Oct 23, 2022

by admin

108 views

0 votes

0 answers

11

viral8702 asked in Databases Oct 15, 2022

12 views

Page:

1
2
3
4
5
6
...
16
next »

Recent questions tagged database-normalization