Question: Let a prime attribute be one that appears in at least one candidate key. Let and be sets of attributes such that

Let a prime attribute be one that appears in at least one candidate key. Let α and β be sets of attributes such that α → β holds but β → α do not hold. Let A be an attribute that is not in α, is not in β, and for which β → A holds. We say that A is transitively dependent on α. We can restate our definition of 3NF as follows: A relation schema R is in 3NF with respect to a set F of functional dependencies if there are no non prime attributes A in R for which A is transitively dependent on a key for R. Show that this new definition is equivalent to the original one.

Step by Step Solution

3.34 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Suppose R is in 3NF according to the textbook definition We show that it is in 3NF according to the ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

16-CS-DB (200).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!