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

Create a database schema, Consider a database schema consisting of four rel... Consider a database schema consisting of four relations, whose schemas are: Product (maker, model, type) PC (model, speed, ram, hd, price) Laptop (model, speed, ram, hd, s

Sequences-data control, Sequences Sequences: Automatically produ... Sequences Sequences: Automatically produce unique numbers Are sharable Are typically used to make a primary key value Replace application code Speed up t

Define hot swapping, Define hot swapping? Hot swapping permits the remo... Define hot swapping? Hot swapping permits the removal of faulty disks and changes it by new ones without turning power off. Hot swapping decreases the mean time to repair.

Data redundency, How to reduce data redundency How to reduce data redundency

What is the difference between primary key and a unique key, What's the dif... What's the difference between a primary key and a unique key? Both primary key and unique key enforces uniqueness of the column on which they are explained. But by default prim

Should i select imaging software that allows changes, Should I select imagi... Should I select imaging software that allows changes? An imaging system should not give features to edit or alter images. Images generally are formed as safe and secure records

Provide the steps involved in ethical analysis, Question : Mr. Smith Ha... Question : Mr. Smith Harry has a car manufacturing company which has recently integrated management information system. He wishes to obtain more information on ethics and socia

Explain the use of constraints in functional model, Explain the use of cons... Explain the use of constraints in functional model with suitable example. A constraint shows relationship between two objects at same time, or   among various values of the sam

What does the cardinality ratio specify, What does the cardinality ratio sp... What does the cardinality ratio specify? Mapping cardinalities or cardinality ratios state the number of entities to which another entity can be associated. Mapping cardinaliti

Give an example of enforcement in typing, Give an example of enforcement in... Give an example of enforcement in Typing. You can understand the idea of enforcement as it makes sure objects of dissimilar classes may not be interchanged as below:  Exampl