1. Use the Invoice table structure shown below to answer the following questions:

a)  Draw the dependency diagram and identify the primary key and 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.)

b)  Remove all partial dependencies, re-draw the new dependency diagrams, and identify the normal form for the table structure you created.

c)  Remove all transitive dependencies, and draw the new dependency diagrams. Also identify the normal form for the table structure you created.

d)  Include the relational schema for the final database table structure.  Identify all primary keys.

 

 

Posted Date: 3/23/2013 4:15:47 AM | Location : United States

Ask an Expert

Related Discussions:- Remove all transitive dependencies - dependency diagram, Assignment Help, Ask Question on Remove all transitive dependencies - dependency diagram, Get Answer, Expert's Help, Remove all transitive dependencies - dependency diagram Discussions

Write discussion on Remove all transitive dependencies - dependency diagram
Your posts are moderated

Write your message here..

Related Questions

Implementing a data mining algorithm, i need to implememnt a treee based mi... i need to implememnt a treee based mining algorithm. do you have an expert that can do that?

Functional Dependencies, What exactly is the concept of Functional Dependen... What exactly is the concept of Functional Dependencies? And how do we associate this concept with the logic of Super-keys, Candidate Keys, etc? Given Relation R(A,B,C,D,E) with de

Abap/4 statements to access internal tables without header, What should be ... What should be declared explicitly in the corresponding ABAP/4 Statements to access internal tables without header lines & why? Work Area. This is needed as the Work Area is

Database problem in wordpress, Project Description: I am having a random... Project Description: I am having a random problem with my Wordpress site. If I click on "Publish" and "Add new", it takes me to a 404 page not found of /wp-admin/post.php (th

Benefits abd drawback of hashed file organisation, Benefits of Hashed file ... Benefits of Hashed file Organisation 1.      Insertion or search on hash-key is quick. 2.      Best if equality search is required on hash-key. Drawbacks of Hashed file

Determine the benefits of object oriented design, Determine the benefits of... Determine the benefits of Object oriented design OOD also gives reusability, which saves time, costs and productivity gains through direct mapping to properties of Object-Orie

Er diagram of textile industry, complete er diagram of textile industry man... complete er diagram of textile industry management

BOGUS VS GENUINE EMPOWERMENT, what is bogus empowerment. And what is genuin... what is bogus empowerment. And what is genuine empowerment

What are composite objects, What are composite objects? Objects that ha... What are composite objects? Objects that have other objects are known as complex objects or composite objects.

Determine the steps of path in association network, Determine the steps of ... Determine the steps of path in association network You can analyse use of paths in association network in the following steps:  Examine every operation and see what asso