consider a dependency diagram of relation R and normalize it upto third normal form.

2.0kviews

written 9.0 years ago by

teamques10 ★ 70k

modified 3.8 years ago by

pedsangini276 • 4.8k

enter image description here

Mumbai University > Information Technology > Sem 3 > Database Management System

Marks: 10M

Year: Dec 2013

database management systems

ADD COMMENT EDIT

1 Answer

76views

written 9.0 years ago by

teamques10 ★ 70k

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

enter image description here

Step 3: Converting into …

Create a free account to keep reading this post.

and 2 others joined a min ago.

ADD COMMENT EDIT

Please log in to add an answer.