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 

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

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!