Share
Explore BrainMass

Dependency Diagrams

Please refer to the attachment for mentioned figures and tables.

1. Given the dependency diagram shown in Figure 1, answer Questions b & c:

b. Create a database whose tables are at least in 2NF, showing the dependency diagrams for each table.
c. Create a database whose tables are at least in 3NF, showing the dependency diagrams for each table.

2. Using the INVOICE table structure shown in Table P5.1, draw its dependency diagram and identify all dependencies (including all partial and transitive dependencies). You can assume that the table does not contain repeating groups and that any invoice number may reference more than one product. (Hint: This table uses a composite primary key.)

3. Using the initial dependency diagram drawn in Problem 2, remove all partial dependencies, draw the new dependency diagrams, and identify the normal forms for each table structure you created.

4. To keep track of office furniture, computers, printers, and so on, the FOUNDIT company uses the table structure shown in Table P5.8.

Given this information, draw the dependency diagram. Make sure you label the transitive and/or partial dependencies.

5. Starting with the dependency diagram drawn for Problem 4, create a set of dependency diagrams that meet 3NF requirements. Rename attributes to meet the naming conventions, and create new entities and attributes as necessary.

6- Using the results of Problem 5, draw the Crow's Foot ERD.

Attachments

Solution Summary

This solution answers a set of questions based on the dependency diagram.

These questions include:

1. Given the dependency diagram shown in Figure 1, answer Questions b & c:

b. Create a database whose tables are at least in 2NF, showing the dependency diagrams for each table.
c. Create a database whose tables are at least in 3NF, showing the dependency diagrams for each table.

2. Using the INVOICE table structure shown in Table P5.1, draw its dependency diagram and identify all dependencies (including all partial and transitive dependencies). You can assume that the table does not contain repeating groups and that any invoice number may reference more than one product. (Hint: This table uses a composite primary key.)

3. Using the initial dependency diagram drawn in Problem 2, remove all partial dependencies, draw the new dependency diagrams, and identify the normal forms for each table structure you created.

4. To keep track of office furniture, computers, printers, and so on, the FOUNDIT company uses the table structure shown in Table P5.8.

Given this information, draw the dependency diagram. Make sure you label the transitive and/or partial dependencies.

5. Starting with the dependency diagram drawn for Problem 4, create a set of dependency diagrams that meet 3NF requirements. Rename attributes to meet the naming conventions, and create new entities and attributes as necessary.

6- Using the results of Problem 5, draw the Crow's Foot ERD.

$2.19