Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Slides
Recent questions tagged database-normalization
0
votes
0
answers
1
#dbms
Çșȇ ʛấẗẻ
63
views
Çșȇ ʛấẗẻ
asked
Feb 24
Databases
databases
database-normalization
+
–
0
votes
1
answer
2
GATE DS&AI 2024 | Question: 36
Given the relational schema $R=(U, V, W, X, Y, Z)$ and the set of functional dependencies: \[ \{U \rightarrow V, U \rightarrow W, W X \rightarrow Y, W X \rightarrow Z, V \rightarrow X\} \] Which of the following functional dependencies can be derived from the above set? $V W \rightarrow Y Z$ $W X \rightarrow Y Z$ $V W \rightarrow U$ $V W \rightarrow Y$
Given the relational schema $R=(U, V, W, X, Y, Z)$ and the set of functional dependencies:\[\{U \rightarrow V, U \rightarrow W, W X \rightarrow Y, W X \...
Arjun
782
views
Arjun
asked
Feb 16
Databases
gate-ds-ai-2024
databases
database-normalization
multiple-selects
+
–
6
votes
1
answer
3
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
292
views
GO Classes
asked
Feb 5
Databases
goclasses2024-mockgate-14
databases
database-normalization
functional-dependency
multiple-selects
2-marks
+
–
0
votes
1
answer
4
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
5
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
404
views
GO Classes
asked
Jan 21
Databases
goclasses2024-mockgate-12
goclasses
databases
database-normalization
functional-dependency
1-mark
+
–
8
votes
4
answers
6
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
928
views
GO Classes
asked
Jan 13
Databases
goclasses2024-mockgate-11
goclasses
databases
database-normalization
functional-dependency
multiple-selects
2-marks
+
–
1
votes
2
answers
7
GATE Data Science and Artificial Intelligence 2024 | Sample Paper | Question: 26
Given the following relation instances $\text{X}$ $\text{Y}$ $\text{Z}$ $1$ $4$ $2$ $1$ $5$ $3$ $1$ $4$ $3$ $1$ $5$ $2$ $3$ $2$ $1$ ... $\mathrm{Y} ->>\mathrm{X}$ $\mathrm{XZ}->\mathrm{Y}$ and $\mathrm{Y}->\mathrm{X}$
Given the following relation instances$\text{X}$$\text{Y}$$\text{Z}$$1$$4$$2$$1$$5$$3$$1$$4$$3$$1$$5$$2$$3$$2$$1$Which of the following conditions is/are TRUE?$\mathrm{XY...
admin
1.1k
views
admin
asked
Oct 21, 2023
Databases
gateda-sample-paper-2024
database-normalization
+
–
0
votes
6
answers
8
made easy test series
Consider a relation $R(ABCDEFGH)$. How many superkeys will be there in relation $R$ if the candidate keys for relation are ${A, BC, CDE, EF}$?
Consider a relation $R(ABCDEFGH)$.How many superkeys will be there in relation $R$ if the candidate keys for relation are ${A, BC, CDE, EF}$?
kaustubh7
805
views
kaustubh7
asked
Sep 20, 2023
Databases
databases
superkeys
database-normalization
made-easy-test-series
+
–
0
votes
1
answer
9
selft doubt
can we consider , proper subset of candidate key union proper subset of another candidate key as a proper subset of candidate key.
can we consider , proper subset of candidate key union proper subset of another candidate keyas a proper subset of candidate key.
Devil16
253
views
Devil16
asked
Sep 17, 2023
Databases
database-normalization
+
–
0
votes
1
answer
10
#DBMS #Normalization
please can someone help with part (a) of this question.
please can someone help with part (a) of this question.
bhucho
250
views
bhucho
asked
Sep 13, 2023
Databases
databases
database-normalization
+
–
0
votes
0
answers
11
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
462
views
rexritz
asked
Aug 29, 2023
Databases
er-diagram
databases
normal-forms
database-normalization
+
–
Page:
1
2
3
4
5
6
...
18
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register