Dependency Diagrams
Not what you're looking for?
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.
Purchase this Solution
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.
Purchase this Solution
Free BrainMass Quizzes
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
Javscript Basics
Quiz on basics of javascript programming language.
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.