Question: Database: Ch6 (Normalization) In-Class Practice Problem#1 Use the dependency diagram shown in Figure P6.3 to work problems 8a-8c. FIGURE P6.S Initial Dependency Diagram for Problems
Database: Ch6 (Normalization) In-Class Practice Problem#1 Use the dependency diagram shown in Figure P6.3 to work problems 8a-8c. FIGURE P6.S Initial Dependency Diagram for Problems 8a, Sb, and Sc Sa). Break up the dependency diagram to create two new dependency diagrams, one in 3NF and one in 2NF 8b). Modify the dependency diagrams you created in Problem 8a to prod BCNF.) Sc). Modify the dependency diagrams in Problem Sb to produce a collection of dependency dependency diagrams that are all in 3NF. (Hint. One of your dependency diagrams wil be in 3NF, but not in diagrams that are all in 3NF and BCNF
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
