Explore BrainMass
Share

Dependency Diagrams

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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.

© BrainMass Inc. brainmass.com October 25, 2018, 2:50 am ad1c9bdddf
https://brainmass.com/computer-science/software-development/dependency-diagrams-316804

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
See Also This Related BrainMass Solution

Dependence Diagram

The following table shows a table called Grade Report for a university. The existing functional dependencies are described as follows:

Student_ID -> Student_Name, Major
Course_ID -> Course_Title, Instructor_Name, Instructor_Location
Student_ID, Course_ID -> Grade
Instructor_Name -> Instructor_Location
Deliverable:

Draw a dependence diagram. There are examples in the reading assignments of dependence diagrams.
In what normal form is this table? Explain why.
Decompose the table into a set of 3NF tables. Describe the process to decompose the table.
Draw an ER diagram based on the decomposed tables (in Chen model).

Look at attached grade report...

View Full Posting Details