Describe the concept of transitive dependency and describe how this concept relates to 3NF. Provide an example to illustrate your answer.

What will be an ideal response?


Transitive dependency A condition where A, B, and C are attributes of a relation such that
if A ? B and B ? C, then C is transitively dependent on A via B (provided that A is not
functionally dependent on B or C)
Third Normal Form (3NF) is a relation that is in first and second normal form in which no non-
primary-key attribute is transitively dependent on the primary key.

Computer Science & Information Technology

You might also like to view...

In Project 2013, a project can only be scheduled by Start date or Finish date, not by both

Indicate whether the statement is true or false

Computer Science & Information Technology

Pointing to an element in the Word window, such as a Ribbon button, displays a(n) _____.

A. filename B. ScreenTip C. flag D. menu

Computer Science & Information Technology

When importing a Personal Web Package, Expression Web allows you to choose which files and folders you want to import.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

The ____ is used in an assignment statement.

A. plus sign (+) B. equal sign (=) C. ampersand (&) D. percent sign (%)

Computer Science & Information Technology