(Solved) : Figure 51 Dependency Diagram 5 Break Dependency Diagram Create 2 New Dependency Diagrams O Q27624674 . . .
Figure 5.1 Dependency diagram 5-a) Break up the dependency diagram above to create 2 new dependency diagrams, one in 3NF and one in 2NF 5-b) Modify the dependency diagrams you produced in 5-a to produce a set of dependency diagrams that are all in 3NF. To keep the entire collection of attributes together, copy the 3NF dependency diagram from 5-a and then show the new dependency diagrams that are also in 3NF. (Hint: One of your dependency diagrams will be in 3NF, but not in BCNF) 5-c) Modify the dependency diagrams in 5-b to produce a collection of dependency diagrams that are all in 3NF and BCNF. To ensure that all attributes are accounted for, copy the 3NF dependency diagrams you showed in 5-b and then show the new 3NF and BCNF diagrams. Show transcribed image text
Expert Answer
Answer to Figure 51 Dependency Diagram 5 Break Dependency Diagram Create 2 New Dependency Diagrams O Q27624674 . . .
OR