A functional dependency is called a partial dependency if there is a proper subset

Question:

A functional dependency α → β is called a partial dependency if there is a proper subset γ of α such that γ → β.We says that β is partially dependent on α. A relation schema R is in second normal form (2NF) if each attributes A in R meets one of the following criteria:

• It appears in a candidate key.

• It is not partially dependent on a candidate key. Show that every 3NF schema is in 2NF.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  answer-question

Database System Concepts

ISBN: 978-0072554816

4th Edition

Authors: Henry F. Korth, S. Sudarshan

Question Posted: