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.
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
Pointing to an element in the Word window, such as a Ribbon button, displays a(n) _____.
A. filename B. ScreenTip C. flag D. menu
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)
The ____ is used in an assignment statement.
A. plus sign (+) B. equal sign (=) C. ampersand (&) D. percent sign (%)