Q. A 3 NF relation is split into 4 NF

(A) by removing overlapping composite keys
(B) by splitting into relations which do not have more than one independent multi valued dependency
(C) removing multivalued dependency
(D) by putting dependent non-key attribute in a separate table

💬 Discuss

✅ Correct Answer: (B) by splitting into relations which do not have more than one independent multi valued dependency

Published by Mr. Dubey ⭐ 111.54K Points at 16-Sep-2023 03:38 pm in Database Management System (DBMS)

You must be Logged in to update hint/solution

💬 Discussion

📊 Question Analytics

👁️

426

Total Visits

📽️

3 y ago

Published

🎖️

Mr. Dubey

Publisher

📈

92%

Success Rate