Question: solve the questions. NOTE the question 6.3 convert the relations you obtained in step 6.2 not 5.2 there is a mistake on the question. (Draw
6) Consider the following Second Normal Form (INF) Aaw. answer the questions that e1 6.1 Identify all partial and transitive dependencies by labeling each the 3 empty boxes in the diagram above with either PARTIAL or TRANSITIVE. (1 point) 6.2 Convert the relation to Second Normal Form ( 2NF ) and draw the dependency diagrams. (2 points) 0.3 Convert the relations you obtained in step 5.2 to Third Normal Form (3NF) and draw the dependency diagrams. ( 2 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
