Question: Consider the dependency diagram shown in the following figure Candidate Key FD 1 FD 2 A FD 3 B T D E F FD
Consider the dependency diagram shown in the following figure Candidate Key FD 1 FD 2 A FD 3 B T D E F FD 4 i. Write Primary and Candidate key and List of all functional dependencies present in the above dependency diagram. ii. Decompose the relation into 2NF. Write dependency diagrams after decomposing into 2NF with mention of keys and functional dependencies. iii. (a.) Decompose the relation into 3NF using the functional dependency diagrams generated in sub question (b.) Write dependency diagrams after decomposing into 3NF with mention of keys and functional dependencies
Step by Step Solution
3.46 Rating (153 Votes )
There are 3 Steps involved in it
Based on the given dependency diagram lets tackle each of the requested items i Write Primary and Candidate key and List of all functional dependencie... View full answer
Get step-by-step solutions from verified subject matter experts
