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

Relational database, write on the various type of relationalkey write on the various type of relationalkey

Prepare an erd for the scenario, Question: (a) Prepare an ERD for the s... Question: (a) Prepare an ERD for the scenario given below. (b) Convert the ER diagram produced in (a) above into its physical design. You have to choose an appropriate Pri

Types of attributes, Attributes attached to an entity can be of various typ... Attributes attached to an entity can be of various types. Simple The attribute that cannot be further separated into smaller parts and shows the basic meaning is known as a

Update opreation, notes about update opreation notes about update opreation

What is cardinality ratio, What is Cardinality Ratio? Cardinality Rati... What is Cardinality Ratio? Cardinality Ratios - The cardinality ratios for relationship kinds specifies the maximum number of relationship instances in which an entity can pa

What are decision support systems, Question: (a) What are decision sup... Question: (a) What are decision support systems, and what role do they play in the business environment? (b) Data mining is a knowledge discovery process of automated extr

Differance between ddl and sdl, Differance between DDL and SDL? DDL and... Differance between DDL and SDL? DDL and SDL - The data definition language (DDL) is used through DBA and database designers to describe internal schema, conceptual schema, and

Design of a database, Ask questioYou are the database administrator in a un... Ask questioYou are the database administrator in a university. You have been tasked to come up with a new database for the University. Using the stages in Database Life Cycle come

How nulls are treated in comparison operator, How nulls are treated in comp... How nulls are treated in comparison operator? Along with comparison (relational) operators, the null values are ignored as we cannot derive the relation along with the given op

What is the archtetype pattern, What is the archtetype/instance pattern? ... What is the archtetype/instance pattern? The archetype/instance pattern happens when one entity tracks occurrences of another entity. A common example is the relationship among