3

7.6kviews

Consider a dependency diagram of relation R and normalise it upto third normal form.

written 7.9 years ago by | modified 2.1 years ago by |

Normalise the dependency diagram of ER diagram

ADD COMMENT
EDIT

**1 Answer**

3

7.6kviews

Consider a dependency diagram of relation R and normalise it upto third normal form.

written 7.9 years ago by | modified 2.1 years ago by |

Normalise the dependency diagram of ER diagram

ADD COMMENT
EDIT

1

974views

written 7.9 years ago by |

**Step 1:** The relation R is already in 1NF, since all its values are atomic.

**Step 2:** Converting into 2NF form. A relation schema R is in second normal form (2NF) if every non-prime attribute A in R is fully functionally dependent on the primary key

**Step 3:** Converting into 3NF. A relation schema R is in third normal form (3NF) if it is in 2NF and no non-prime attribute A in R is transitively dependent on the primary key

This is the final solution in 3NF.

ADD COMMENT
EDIT

Please log in to add an answer.