Computer Science Engineering (CSE) Exam > Computer Science Engineering (CSE) Questions > In a schema with attributes A, B, C, D and E ...
Start Learning for Free
In a schema with attributes A, B, C, D and E following set of functional dependencies are given
A → B A → C CD → E B → D E → A
Q. Which of the following functional dependencies is NOT implied by the above set?
- a)CD → AC
- b)BD → CD
- c)BC → CD
- d)AC → BC
Correct answer is option 'B'. Can you explain this answer?
| FREE This question is part of | Download PDF Attempt this Test |
Verified Answer
In a schema with attributes A, B, C, D and E following set of function...
option (b)
For every options given, find the closure set of left side of each FD. If the closure set of left side contains the right side of the FD, then the particular FD is implied by the given set.
Option (a): Closure set of CD = CDEAB. Therefore CD->AC can be derived from the given set of FDs.
Option (c): Closure set of BC = BCDEA. Therefore BC->CD can be derived from the given set of FDs.
Option (d): Closure set of AC = ACBDE. Therefore AC->BC can be derived from the given set of FDs.
Option (b): Closure set of BD = BD. Therefore BD->CD cannot be derived from the given set of FDs.
Most Upvoted Answer
In a schema with attributes A, B, C, D and E following set of function...
Given Information
In a schema with attributes A, B, C, D, and E, the following set of functional dependencies are given:
A B
A C
CD E
B D
E A
The question asks to identify the functional dependency that is NOT implied by the above set.
Solution
To identify the functional dependency that is NOT implied by the given set, we need to check each option one by one and see if it can be derived from the given set of functional dependencies.
Option A: CD AC
To derive CD AC, we can use the transitive rule of functional dependency. Since we have the functional dependency A C and CD E, we can derive CD AC as follows:
CD E (given)
A C (given)
Therefore, CD AC (by transitive rule)
Option B: BD CD
To derive BD CD, we need to have a functional dependency between B and C. However, there is no such dependency given in the set. Therefore, option B is NOT implied by the given set.
Option C: BC CD
To derive BC CD, we can use the transitive rule of functional dependency. Since we have the functional dependency CD E and E A, we can derive BC AD as follows:
CD E (given)
E A (given)
Therefore, CD A (by transitive rule)
A B (given)
Therefore, BC CD (by transitive rule)
Option D: AC BC
To derive AC BC, we can use the transitive rule of functional dependency. Since we have the functional dependency A C and C D, we can derive AC BD as follows:
A C (given)
C D (given)
Therefore, A D (by transitive rule)
B D (given)
Therefore, AC BD (by transitive rule)
Therefore, the correct answer is option B: BD CD.
In a schema with attributes A, B, C, D, and E, the following set of functional dependencies are given:
A B
A C
CD E
B D
E A
The question asks to identify the functional dependency that is NOT implied by the above set.
Solution
To identify the functional dependency that is NOT implied by the given set, we need to check each option one by one and see if it can be derived from the given set of functional dependencies.
Option A: CD AC
To derive CD AC, we can use the transitive rule of functional dependency. Since we have the functional dependency A C and CD E, we can derive CD AC as follows:
CD E (given)
A C (given)
Therefore, CD AC (by transitive rule)
Option B: BD CD
To derive BD CD, we need to have a functional dependency between B and C. However, there is no such dependency given in the set. Therefore, option B is NOT implied by the given set.
Option C: BC CD
To derive BC CD, we can use the transitive rule of functional dependency. Since we have the functional dependency CD E and E A, we can derive BC AD as follows:
CD E (given)
E A (given)
Therefore, CD A (by transitive rule)
A B (given)
Therefore, BC CD (by transitive rule)
Option D: AC BC
To derive AC BC, we can use the transitive rule of functional dependency. Since we have the functional dependency A C and C D, we can derive AC BD as follows:
A C (given)
C D (given)
Therefore, A D (by transitive rule)
B D (given)
Therefore, AC BD (by transitive rule)
Therefore, the correct answer is option B: BD CD.
Attention Computer Science Engineering (CSE) Students!
To make sure you are not studying endlessly, EduRev has designed Computer Science Engineering (CSE) study material, with Structured Courses, Videos, & Test Series. Plus get personalized analysis, doubt solving and improvement plans to achieve a great score in Computer Science Engineering (CSE).
|
Explore Courses for Computer Science Engineering (CSE) exam
|
|
Similar Computer Science Engineering (CSE) Doubts
Top Courses for Computer Science Engineering (CSE)View all
In a schema with attributes A, B, C, D and E following set of functional dependencies are givenA → B A → C CD → E B → D E → AQ. Which of the following functional dependencies is NOT implied by the above set?a)CD → ACb)BD → CDc)BC → CDd)AC → BCCorrect answer is option 'B'. Can you explain this answer?
Question Description
In a schema with attributes A, B, C, D and E following set of functional dependencies are givenA → B A → C CD → E B → D E → AQ. Which of the following functional dependencies is NOT implied by the above set?a)CD → ACb)BD → CDc)BC → CDd)AC → BCCorrect answer is option 'B'. Can you explain this answer? for Computer Science Engineering (CSE) 2024 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about In a schema with attributes A, B, C, D and E following set of functional dependencies are givenA → B A → C CD → E B → D E → AQ. Which of the following functional dependencies is NOT implied by the above set?a)CD → ACb)BD → CDc)BC → CDd)AC → BCCorrect answer is option 'B'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for In a schema with attributes A, B, C, D and E following set of functional dependencies are givenA → B A → C CD → E B → D E → AQ. Which of the following functional dependencies is NOT implied by the above set?a)CD → ACb)BD → CDc)BC → CDd)AC → BCCorrect answer is option 'B'. Can you explain this answer?.
In a schema with attributes A, B, C, D and E following set of functional dependencies are givenA → B A → C CD → E B → D E → AQ. Which of the following functional dependencies is NOT implied by the above set?a)CD → ACb)BD → CDc)BC → CDd)AC → BCCorrect answer is option 'B'. Can you explain this answer? for Computer Science Engineering (CSE) 2024 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about In a schema with attributes A, B, C, D and E following set of functional dependencies are givenA → B A → C CD → E B → D E → AQ. Which of the following functional dependencies is NOT implied by the above set?a)CD → ACb)BD → CDc)BC → CDd)AC → BCCorrect answer is option 'B'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for In a schema with attributes A, B, C, D and E following set of functional dependencies are givenA → B A → C CD → E B → D E → AQ. Which of the following functional dependencies is NOT implied by the above set?a)CD → ACb)BD → CDc)BC → CDd)AC → BCCorrect answer is option 'B'. Can you explain this answer?.
Solutions for In a schema with attributes A, B, C, D and E following set of functional dependencies are givenA → B A → C CD → E B → D E → AQ. Which of the following functional dependencies is NOT implied by the above set?a)CD → ACb)BD → CDc)BC → CDd)AC → BCCorrect answer is option 'B'. Can you explain this answer? in English & in Hindi are available as part of our courses for Computer Science Engineering (CSE).
Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.
Here you can find the meaning of In a schema with attributes A, B, C, D and E following set of functional dependencies are givenA → B A → C CD → E B → D E → AQ. Which of the following functional dependencies is NOT implied by the above set?a)CD → ACb)BD → CDc)BC → CDd)AC → BCCorrect answer is option 'B'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of
In a schema with attributes A, B, C, D and E following set of functional dependencies are givenA → B A → C CD → E B → D E → AQ. Which of the following functional dependencies is NOT implied by the above set?a)CD → ACb)BD → CDc)BC → CDd)AC → BCCorrect answer is option 'B'. Can you explain this answer?, a detailed solution for In a schema with attributes A, B, C, D and E following set of functional dependencies are givenA → B A → C CD → E B → D E → AQ. Which of the following functional dependencies is NOT implied by the above set?a)CD → ACb)BD → CDc)BC → CDd)AC → BCCorrect answer is option 'B'. Can you explain this answer? has been provided alongside types of In a schema with attributes A, B, C, D and E following set of functional dependencies are givenA → B A → C CD → E B → D E → AQ. Which of the following functional dependencies is NOT implied by the above set?a)CD → ACb)BD → CDc)BC → CDd)AC → BCCorrect answer is option 'B'. Can you explain this answer? theory, EduRev gives you an
ample number of questions to practice In a schema with attributes A, B, C, D and E following set of functional dependencies are givenA → B A → C CD → E B → D E → AQ. Which of the following functional dependencies is NOT implied by the above set?a)CD → ACb)BD → CDc)BC → CDd)AC → BCCorrect answer is option 'B'. Can you explain this answer? tests, examples and also practice Computer Science Engineering (CSE) tests.
|
|
Explore Courses for Computer Science Engineering (CSE) exam
|
|
Suggested Free Tests
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
|
© EduRev
|
Education Revolution
|
Follow Us
|
Signup to see your scores
go up within 7 days!
Access 1000+ FREE Docs, Videos and Tests
Takes less than 10 seconds to signup