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
Ace Test Series: Databases - Functional Dependencies
Arnab Bhadra
asked
in
Databases
May 30, 2017
edited
Mar 7, 2019
by
Rishi yadav
1,185
views
2
votes
2
votes
Find what FD is violated by the Relation R = { } i.e. empty relation
a. All FD
b. Does not violate FD's
c. Cannot say
d. None of the Above
ace-test-series
databases
database-normalization
Arnab Bhadra
asked
in
Databases
May 30, 2017
edited
Mar 7, 2019
by
Rishi yadav
by
Arnab Bhadra
1.2k
views
answer
comment
Follow
share this
share
2 Comments
by
AnilGoudar
commented
May 30, 2017
reply
Follow
share this
Let us take by example,
let relation be R(A,B) and FD is X -> Y.
Now X can take { ∅, X, Y , XY} and Similarly Y can be { ∅, X, Y , XY}.
For Empty relation R( ), there is at least one FD which is ∅ -> ∅.
Correct me if i am wrong.
0
0
by
Angkit
commented
May 30, 2017
reply
Follow
share this
b. Does not violate FD's
//No relation exist.We can have no example to violating it...?
1
1
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
2
Answers
3
votes
3
votes
Best answer
b)does not violate any fd as there are no attributes so it is in Highest normal form possible . Plz correct me if I am wrong
aik138463
answered
May 31, 2017
selected
Jun 12, 2017
by
Arnab Bhadra
by
aik138463
comment
Follow
share this
2 Comments
by
akankshadewangan24
commented
Oct 16, 2017
reply
Follow
share this
What's the correct???
0
0
by
aik138463
commented
Oct 19, 2017
reply
Follow
share this
b is correct
0
0
Please
log in
or
register
to add a comment.
0
votes
0
votes
.We can have only 1 FD for the empty Relation which determines ∅.
∅ ->∅ . Therefore, it is not violating any FD’s.
Option B is correct.
Varun Raj Akula
answered
Mar 6, 2022
by
Varun Raj Akula
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
1
vote
1
vote
1
answer
1
shubhamdarokar
asked
in
Databases
Jan 18, 2017
499
views
Ace Test Series: Databases - Functional Dependencies
shubhamdarokar
asked
in
Databases
Jan 18, 2017
by
shubhamdarokar
499
views
databases
database-normalization
ace-test-series
2
votes
2
votes
3
answers
2
Shivam Kasat
asked
in
Databases
Jan 4, 2019
2,772
views
MadeEasy Test Series: Databases - Functional Dependencies
Consider the following relation R(A, B, C, D, E, F, G) and set of functional dependencies. F={BCD → A, BC → E, A → F, F → G, A→G, C → D} Which of the following is minimal cover of F? {BC → A, BC → E, A → F, C → D, A → G} {BC → A, B → E, A → F, F → G, C → D} {BC → A, BC → E, A → F, F → G, C → D} {BC → A, BC → E, A → F, C → D}
Shivam Kasat
asked
in
Databases
Jan 4, 2019
by
Shivam Kasat
2.8k
views
made-easy-test-series
databases
minimal-cover
database-normalization
4
votes
4
votes
1
answer
3
naveen bhatt
asked
in
Databases
Dec 7, 2018
1,415
views
MadeEasy Test Series: Databases - Functional Dependencies
Consider the relation R(A,B,C,D,E) with the functional dependencies : A → B, B → C, C → A, D → E, and E → D The Maximum possible super-keys of R is ______________?
naveen bhatt
asked
in
Databases
Dec 7, 2018
by
naveen bhatt
1.4k
views
made-easy-test-series
databases
database-normalization
superkeys
2
votes
2
votes
0
answers
4
Mk Utkarsh
asked
in
Databases
Aug 21, 2018
921
views
Testbook Test Series: Databases - Functional Dependencies
Consider a relation R(A,B,C,D,E,F,G) with set of functional dependencies F={AD->BF, CD->EGC, BD->F, E->D, F->C, D->F} The relation R is ... dependency preserving Decomposition is lossy and dependency preserving Decomposition is lossy and not dependency preserving Decomposition is lossless and not dependency preserving
Mk Utkarsh
asked
in
Databases
Aug 21, 2018
by
Mk Utkarsh
921
views
testbook-test-series
databases
database-normalization
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