Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
Dark Mode
Slides
Recent questions tagged database-normalization
0
votes
0
answers
1
#dbms
Çșȇ ʛấẗẻ
asked
in
Databases
Feb 24
by
Çșȇ ʛấẗẻ
58
views
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 ... derived from the above set? $V W \rightarrow Y Z$ $W X \rightarrow Y Z$ $V W \rightarrow U$ $V W \rightarrow Y$
Arjun
asked
in
Databases
Feb 17
by
Arjun
743
views
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
GO Classes
asked
in
Databases
Feb 5
by
GO Classes
270
views
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$
GO Classes
asked
in
Databases
Feb 5
by
GO Classes
157
views
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}$
GO Classes
asked
in
Databases
Jan 21
by
GO Classes
381
views
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$.
GO Classes
asked
in
Databases
Jan 13
by
GO Classes
896
views
goclasses2024-mockgate-11
goclasses
databases
database-normalization
functional-dependency
multiple-selects
2-marks
1
vote
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}$
admin
asked
in
Databases
Oct 22, 2023
by
admin
1.1k
views
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}$?
kaustubh7
asked
in
Databases
Sep 20, 2023
by
kaustubh7
783
views
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.
Devil16
asked
in
Databases
Sep 18, 2023
by
Devil16
245
views
database-normalization
0
votes
1
answer
10
#DBMS #Normalization
please can someone help with part (a) of this question.
bhucho
asked
in
Databases
Sep 13, 2023
by
bhucho
241
views
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?
rexritz
asked
in
Databases
Aug 29, 2023
by
rexritz
451
views
er-diagram
databases
normal-forms
database-normalization
Page:
1
2
3
4
5
6
...
18
next »
Subscribe to GATE CSE 2024 Test Series
Subscribe to GO Classes for GATE CSE 2024
Quick search syntax
tags
tag:apple
author
user:martin
title
title:apple
content
content:apple
exclude
-tag:apple
force match
+apple
views
views:100
score
score:10
answers
answers:2
is accepted
isaccepted:true
is closed
isclosed:true
Recent Posts
Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes
Subjects
All categories
General Aptitude
(3.5k)
Engineering Mathematics
(10.4k)
Digital Logic
(3.6k)
Programming and DS
(6.2k)
Algorithms
(4.8k)
Theory of Computation
(6.9k)
Compiler Design
(2.5k)
Operating System
(5.2k)
Databases
(4.8k)
CO and Architecture
(4.0k)
Computer Networks
(4.9k)
Artificial Intelligence
(79)
Machine Learning
(48)
Data Mining and Warehousing
(24)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(682)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
243k
comments
79.7k
users
Recent questions tagged database-normalization
Recent Blog Comments
Hlo I'm Rupesh I got AIR 3485 in gate CS and AIR...
@Ajay Sasank here is the direct link...
Thank you for the post didi My GATE 2023 & 2024...
I Hope it helps 😊
Today's best post I seen thank you for motivation