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
Memory Based GATE DA 2024 | Question: 16
GO Classes
asked
in
Databases
Feb 4
recategorized
Feb 4
by
Lakshman Bhaiya
177
views
0
votes
0
votes
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{array}
\right.
\end{aligned}
\]
From the above set of functional dependencies, determine which additional functional dependency can be deduced. Which of the following options is correct?
$VW \rightarrow U$
$VW \rightarrow Y$
$VW \rightarrow YZ$
$WX \rightarrow YZ$
gate2024-da-memory-based
goclasses
databases
database-normalization
functional-dependency
GO Classes
asked
in
Databases
Feb 4
recategorized
Feb 4
by
Lakshman Bhaiya
by
GO Classes
177
views
answer
comment
Follow
share this
share
0 Comments
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
1
Answer
1
vote
1
vote
$(VW)^+ = (V , W , X ,Y, Z )$
$(WX)^+ = (W , X, Y, Z)$
So options B, C, D are correct.
Lakshmi Narayana404
answered
Feb 6
by
Lakshmi Narayana404
comment
Follow
share this
0 Comments
Please
log in
or
register
to add a comment.
← Previous
Next →
← Previous in category
Next in category →
Related questions
0
votes
0
votes
0
answers
1
GO Classes
asked
in
Databases
Feb 4
151
views
Memory Based GATE DA 2024 | Question: 17
Consider the following SQL query: \[ \begin{aligned} &\text{SELECT * FROM Raider, Team} \\ &\text{WHERE Raider.id = Team.id} \\ &\text{AND City = 'Jaipur'} \\ &\text{AND Raid_points \textgreater 200; ... {aligned} \] Determine the number of rows returned by the SQL query, given the conditions specified for the City and Raid points.
GO Classes
asked
in
Databases
Feb 4
by
GO Classes
151
views
gate2024-da-memory-based
goclasses
databases
sql
numerical-answers
0
votes
0
votes
0
answers
2
GO Classes
asked
in
Databases
Feb 4
112
views
Memory Based GATE DA 2024 | Question: 47
You are given three tables: `team`, `table1`, and `table2`. To find the names of all players in the team who are either present in `table1` or `table2`, consider the following relational algebra queries: \(\Pi_{\text{{PlayerName}}}(\text{{team}}) \,/\, \ ... text{{Name}}}(\text{{table1}} \cap \text{{table2}}) \,/\, \Pi_{\text{{PlayerName}}}(\text{{team}})\)
GO Classes
asked
in
Databases
Feb 4
by
GO Classes
112
views
gate2024-da-memory-based
goclasses
databases
relational-algebra
0
votes
0
votes
0
answers
3
GO Classes
asked
in
Databases
Feb 4
116
views
Memory Based GATE DA 2024 | Question: 58
DBMS question: One SQL query is given. Based on the query which data structure can be used involving hashing, B+ tree, etc?
GO Classes
asked
in
Databases
Feb 4
by
GO Classes
116
views
gate2024-da-memory-based
goclasses
databases
sql
b-tree
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
(25)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(684)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
244k
comments
80.0k
users
Recent Blog Comments
category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...
Twitter
WhatsApp
Facebook
Reddit
LinkedIn
Email
Link Copied!
Copy