Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 2 [10 points] A relation R is given which is R(A,B,C,D,E). It has the following functional dependencies: AB-> C, C->E and B -> D.
Question 2 [10 points] A relation R is given which is R(A,B,C,D,E). It has the following functional dependencies: AB-> C, C->E and B -> D. Answer the following based on this information. 1. Find all the candidate keys and explain your answer [2 points] 2. Which normal form does this relation satisfy? Explain your answer. [3 points] 3. Decompose it until 3NF step by step. [5 points]
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started