Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Recent questions tagged functional-dependency
1
votes
1
answer
31
GO Classes 2024 | IIITH Mock Test 5 | Question: 1
Let $\mathrm{R}(a, b, c, d)$ be a RDBMS relation having the following set of functional dependencies (FD set) : FD Set $\mathrm{F}=\{b \rightarrow c ; c \rightarrow d ; ab \rightarrow d ; bc \rightarrow cd\}$ We apply some queries on a relational instance $r$ ... instance $r$? $\prod_a(r)$ $\prod_{a, c}(r)$ $\prod_{a, b}(r)$ $\prod_{a, b, d}(r)$
Let $\mathrm{R}(a, b, c, d)$ be a RDBMS relation having the following set of functional dependencies (FD set) :FD Set $$\mathrm{F}=\{b \rightarrow c ; c \rightarrow d ; a...
GO Classes
131
views
GO Classes
asked
Apr 30, 2023
Databases
goclasses2024-iiith-mock-5
goclasses
databases
database-normalization
functional-dependency
multiple-selects
1-mark
+
–
1
votes
1
answer
32
GO Classes 2024 | IIITH Mock Test 5 | Question: 40
Please mark the functional dependencies that are consistent with the following table. ... $\mathrm{AB} \rightarrow \mathrm{D}$ $\text{A} \rightarrow \mathrm{CD}$ $\mathrm{ABC} \rightarrow \mathrm{D}$
Please mark the functional dependencies that are consistent with the following table.$$\begin{array}{|l|l|l|l|}\hline \mathrm{A} & \mathrm{B} & \mathrm{C} & \mathrm{D} \\...
GO Classes
85
views
GO Classes
asked
Apr 30, 2023
Databases
goclasses2024-iiith-mock-5
goclasses
databases
functional-dependency
multiple-selects
1-mark
+
–
1
votes
1
answer
33
GO Classes 2024 | IIITH Mock Test 5 | Question: 43
Here's a relation $(\mathrm{R})$, its attributes and its functional dependencies $(\mathrm{F})$ ... $\mathrm{AE} \rightarrow \mathrm{B}$ $\text{A} \rightarrow \mathrm{A}$ $\mathrm{E} \rightarrow \mathrm{CD}$
Here's a relation $(\mathrm{R})$, its attributes and its functional dependencies $(\mathrm{F})$ :$$\begin{aligned}& \mathrm{R}(\mathrm{A}, \mathrm{B}, \mathrm{C}, \mathrm...
GO Classes
418
views
GO Classes
asked
Apr 30, 2023
Databases
goclasses2024-iiith-mock-5
goclasses
databases
functional-dependency
multiple-selects
1-mark
+
–
0
votes
2
answers
34
When is a group of attributes prime?
Given the candidate keys CD and DE and the functional dependency AB->CDE. Is CDE considered prime because all attributes (C, D and E) are prime? Or is it non-prime because CDE is not found in a candidate key as a whole? Therefore, my question is if a group of prime attributes is also prime due to its attributes or it has to be part of a candidate key as well.
Given the candidate keys CD and DE and the functional dependency AB->CDE. Is CDE considered prime because all attributes (C, D and E) are prime? Or is it non-prime becaus...
Mira67
742
views
Mira67
asked
Feb 20, 2023
Databases
functional-dependency
databases
+
–
0
votes
1
answer
35
Database | BCNF
Consider the following relation, R(A,B,C) and the following functional dependencies FD={ A→B, B→C, C→A }. Consider the following statements Statement I: The following relation is in BCNF, as A,B and C are key. Statement II: A prime attribute cannot be ... I and II both are correct. None of statement I and II is correct Only statement II is correct. Only statement I is correct.
Consider the following relation, R(A,B,C) and the following functional dependencies FD={ A→B, B→C, C→A }.Consider the following statementsStatement I: The following...
Souvik33
544
views
Souvik33
asked
Dec 10, 2022
Databases
databases
bcnf
functional-dependency
+
–
1
votes
1
answer
36
Gate@Zeal 2023
Please Explain ans is 8
Please Explainans is 8
SKMAKM
375
views
SKMAKM
asked
Sep 24, 2022
Databases
databases
functional-dependency
numerical-answers
zeal
+
–
1
votes
1
answer
37
#DBMS
Consider a relation schema r(A,B,C,D) with F as set of functional dependencies. F contain following functional dependencies: A -> B A -> D A -> C B -> D we decompose the relation r into two relation schemas r1(A,B,C) and r2(B,D). The statement (Functional dependency in r1) U (Functional dependency in r2) = F is correct ? #dbms #
Consider a relation schema r(A,B,C,D) with F as set of functional dependencies. F contain following functional dependencies:A - BA - DA - CB - Dwe decompose the relation ...
Manisha Jaishwal
649
views
Manisha Jaishwal
asked
Jul 2, 2022
Databases
databases
functional-dependency
+
–
Page:
« prev
1
2
3
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register