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) student (roll no, name, address) course (course no, course max. marks, year of study)
πŸ’¬ Discuss
βœ… Correct Answer: (B) it does not have composite key

You must be Logged in to update hint/solution

πŸ’¬ Discussion

πŸ“Š Question Analytics

πŸ‘οΈ
292
Total Visits
πŸ“½οΈ
2 y ago
Published
πŸŽ–οΈ
Shiva Ram
Publisher
πŸ“ˆ
83%
Success Rate