Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Recent questions tagged functional-dependency
6
votes
1
answer
1
GO Classes Test Series 2024 | Mock GATE | Test 14 | Question: 50
Consider the following database relation: $\mathrm{R}=(\mathrm{SFLNGCRW} \mathrm{H})=(\mathrm{S}$ : SID, F: First Name, L: Last Name, N: Number of Units, G: GPA, C: Course (of teaching), R ... only one applied? SID determines Rating Rating determines Wage Rating determines Course Rating and First Name determine Wage and Hours of Work
Consider the following database relation: $\mathrm{R}=(\mathrm{SFLNGCRW} \mathrm{H})=(\mathrm{S}$ : SID, F: First Name, L: Last Name, N: Number of Units, G: GPA, C: Cours...
GO Classes
293
views
GO Classes
asked
Feb 5
Databases
goclasses2024-mockgate-14
databases
database-normalization
functional-dependency
multiple-selects
2-marks
+
–
0
votes
1
answer
2
Memory Based GATE DA 2024 | Question: 16
Consider a relation R: \[ \begin{aligned} & R(U, V, W, X, Y, Z) \\ & F=\left\{ \begin{array}{l} U \rightarrow V \\ U \rightarrow W \\ WX \rightarrow Y \\ WX \rightarrow Z \\ V \rightarrow X \end ... be deduced. Which of the following options is correct? $VW \rightarrow U$ $VW \rightarrow Y$ $VW \rightarrow YZ$ $WX \rightarrow YZ$
Consider a relation R:\[\begin{aligned}& R(U, V, W, X, Y, Z) \\& F=\left\{\begin{array}{l} U \rightarrow V \\ U \rightarrow W \\ WX \rightarrow Y \\�...
GO Classes
167
views
GO Classes
asked
Feb 4
Databases
gate2024-da-memory-based
goclasses
databases
database-normalization
functional-dependency
+
–
3
votes
2
answers
3
GO Classes Test Series 2024 | Mock GATE | Test 12 | Question: 23
An attribute $A$ is called prime if $A$ is in any of the candidate keys. Assume in the following statements, $\mathrm{A}$ is an attribute $\&\;\mathcal{X}$ is a set of attributes. Consider the following statements: Domain of each attribute is an ... $\text{A - BCNF, B - 3NF, C - 2NF, D - 1NF}$
An attribute $A$ is called prime if $A$ is in any of the candidate keys. Assume in the following statements, $\mathrm{A}$ is an attribute $\&\;\mathcal{X}$ is a set of at...
GO Classes
405
views
GO Classes
asked
Jan 21
Databases
goclasses2024-mockgate-12
goclasses
databases
database-normalization
functional-dependency
1-mark
+
–
8
votes
4
answers
4
GO Classes Test Series 2024 | Mock GATE | Test 11 | Question: 60
In a relational database relation, we say a non-empty set of attributes $\mathrm{X}$ is closed (with respect to a given set of functional dependencies FD) if $X^{+}=X$ (where $X^{+}$is the closure of $X).$ ... $2.$ $R$ is in $2 N F$. $R$ is in $3 N F$.
In a relational database relation, we say a non-empty set of attributes $\mathrm{X}$ is closed (with respect to a given set of functional dependencies FD) if $X^{+}=X$ (w...
GO Classes
932
views
GO Classes
asked
Jan 13
Databases
goclasses2024-mockgate-11
goclasses
databases
database-normalization
functional-dependency
multiple-selects
2-marks
+
–
0
votes
1
answer
5
Made Easy Test Series
Isn’t F$^{+}$ minimal cover? If C $\rightarrow$ A is already there, then why does augmented CD $\rightarrow$ A needs to be?
Isn’t F$^{+}$ minimal cover? If C $\rightarrow$ A is already there, then why does augmented CD $\rightarrow$ A needs to be?
Mrityudoot
128
views
Mrityudoot
asked
Jan 12
Databases
made-easy-test-series
databases
functional-dependency
+
–
0
votes
1
answer
6
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
+
–
Page:
1
2
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register