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
RBR Normalisation example problem
In on of the examples shown by RBR sir, under Normalization I think he did this problem incorrectly, Given relation R(ABC) and fd: AB->C and C->A, convert it into 2NF For this question, the answer according to RBR sir was that the ... "BC", therefore we need to split the tables into AC and ABC is what my solution. Kindly correct me if I am wrong
In on of the examples shown by RBR sir, under Normalization I think he did this problem incorrectly, Given relation R(ABC) and fd: AB->C and C->A, convert it into 2NFFor ...
nareshit
39
views
nareshit
asked
Apr 15
Databases
database-normalization
rdbms
+
–
0
votes
0
answers
2
#dbms
Çșȇ ʛấẗẻ
90
views
Çșȇ ʛấẗẻ
asked
Feb 24
Databases
databases
database-normalization
+
–
0
votes
1
answer
3
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
880
views
Arjun
asked
Feb 16
Databases
gate-ds-ai-2024
databases
database-normalization
multiple-selects
+
–
6
votes
1
answer
4
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
360
views
GO Classes
asked
Feb 5
Databases
goclasses2024-mockgate-14
databases
database-normalization
functional-dependency
multiple-selects
2-marks
+
–
0
votes
1
answer
5
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
221
views
GO Classes
asked
Feb 4
Databases
gate2024-da-memory-based
goclasses
databases
database-normalization
functional-dependency
+
–
3
votes
2
answers
6
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
450
views
GO Classes
asked
Jan 21
Databases
goclasses2024-mockgate-12
goclasses
databases
database-normalization
functional-dependency
1-mark
+
–
8
votes
4
answers
7
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
1.0k
views
GO Classes
asked
Jan 13
Databases
goclasses2024-mockgate-11
goclasses
databases
database-normalization
functional-dependency
multiple-selects
2-marks
+
–
1
votes
2
answers
8
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.2k
views
admin
asked
Oct 21, 2023
Databases
gateda-sample-paper-2024
database-normalization
+
–
0
votes
6
answers
9
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
868
views
kaustubh7
asked
Sep 20, 2023
Databases
databases
superkeys
database-normalization
made-easy-test-series
+
–
0
votes
1
answer
10
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
271
views
Devil16
asked
Sep 17, 2023
Databases
database-normalization
+
–
0
votes
1
answer
11
#DBMS #Normalization
please can someone help with part (a) of this question.
please can someone help with part (a) of this question.
bhucho
265
views
bhucho
asked
Sep 13, 2023
Databases
databases
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