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

What is the meaning of redundant associations, Adding Redundant Association... Adding Redundant Associations for Efficient Access The expression redundant association means using "duplicate association for proficient access". While analysis, it is not a

Explain the disadvantages of file oriented approach, Explain the disadvanta... Explain the disadvantages of file oriented approach? In the oriented approach Applications are designed in isolation. Design of application is optimized for one application. In

State the definition of association, State the definition of association ... State the definition of association An association is a structural relationship which specifies that objects of one thing are connected with objects of another. In UML, asso

Sql, sql is relationally complete-justify sql is relationally complete-justify

Difference between a composite key and attribute, Question: (a) Discuss... Question: (a) Discuss the difference between a composite key and a composite attribute. How would each be indicated in an E-R diagram? Support your answer with appropriate exam

Oracle/sql, can you create a database for me in oracle/sql can you create a database for me in oracle/sql

What is a phantom deadlock, What is a Phantom Deadlock? In distributed... What is a Phantom Deadlock? In distributed deadlock detection, the delay in propagating local information might cause the deadlock detection algorithms to recognize deadlocks

Define cascading rollback, Define Cascading rollback The phenomenon whe... Define Cascading rollback The phenomenon where a single transaction failure leads to a series of transaction rollbacks is known as Cascading rollback.

Issues relating to the design of the physical database files, The issues re... The issues relating to the Design of the Physical Database Files Physical File is a file as stored on the disk. The major issues relating to physical files are:  •      Cons

Consistency, what do you mean by consistency in rdbms? what do you mean by consistency in rdbms?