Q. Given the following relation it is not 3 NF because Student (roll no, name, course no, course max. marks, year of study, address)

(A) it is not in 2 NF
(B) it does not have composite key
(C) non-key attributes course no and course max. marks are functionally dependent
(D) it has more than 3 non-key attributes

💬 Discuss

✅ Correct Answer: (C) non-key attributes course no and course max. marks are functionally dependent

Published by Mr. Dubey ⭐ 104.82K 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

👁️

663

Total Visits

📽️

3 y ago

Published

🎖️

Mr. Dubey

Publisher

📈

92%

Success Rate