Remove all transitive dependencies - dependency diagram, Database Management System

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.)

135_Remove all transitive dependencies - dependency diagram.png

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







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
Related Questions
Describe the functions and features of foreign key? Foreign Key : The primary key of one file or table that is implanted in another file or table to implement the relationships

What is the difference between SQL Server 2000 clustered and nonclustered indexes? With a clustered index, the data are kept in the bottom level of the index and in the similar

What is Index? An index is a physical structure having pointers to the data. Indices are created in an existing table to locate rows more quickly and efficiently. It is possibl

An ideal data dictionary should have everything a DBA wants to know about the database. 1 Conceptual, External, and internal database descriptions. 2.    Descriptions of attr

Multi-list file Organisation Multi-list file organisation is a multi-index linked file organisation. A linked file organisation is a logical organisation where physical orderin

Determine the Disadvantages of file based systems Some of the disadvantages of file based systems are like this: Data redundancy and inconsistency: the dissimilar applic

Explain the term- Query. Queries are used to repossess and show specific records in a table. They can also be used to show specific fields of specific records, which meet the co

Creating views with Replace option : This option is used to alter the definition of the view without recreating and dropping it or regranting object privileges previously granted o

Explain the following functions of Oracle with suitable examples: (i) To_Char( ) (ii) Count( ) (iii) Trim( ) (iv) Length( ) Ans: (i) To_char( ): The TO_CHAR function conver