A relation is said to be in 3 NF if (i) it is in 2 NF (ii) non-key attributes are independent of one another (iii) key attribute is not dependent on part of a composite key (iv) has no multi-valued dependency

Vinay

🎓 Mover ⭐ 28.75K Points

📊 Database Management System (DBMS)

Q. A relation is said to be in 3 NF if (i) it is in 2 NF (ii) non-key attributes are independent of one another (iii) key attribute is not dependent on part of a composite key (iv) has no multi-valued dependency

(A) i and iii
(B) i and iv
(C) i and ii
(D) it has more than 3 non-key attributes

💬 Discuss

✅ Correct Answer: (C) i and ii

You must be Logged in to update hint/solution

💬 Discussion

📊 Question Analytics

👁️

835

Total Visits

📽️

1 y ago

Published

🎖️

Vinay

Publisher

📈

99%

Success Rate

Vinay

💬 Discussion

Related MCQs

📊 Question Analytics