Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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)
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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