Q. A relation project guidance Project Guidance(professor, project, student no. st-name, dept) A professor can give many projects to many students A project will have many students A project may be guided by many professors The 4 NF relation corresponding to this are

  • (A) Prof_Project (professor, st_name, dept) Proj_stud (project, student no.)
  • (B) Prof_stud (professor, student no) Proj_stud (project, student no)
  • (C) Student (student no, st_name, dept) Student (student no, st_name, dept)
  • (D) by putting dependent non-key attribute in a separate table
πŸ’¬ Discuss
βœ… Correct Answer: (B) Prof_stud (professor, student no) Proj_stud (project, student no)

You must be Logged in to update hint/solution

πŸ’¬ Discussion

πŸ“Š Question Analytics

πŸ‘οΈ
825
Total Visits
πŸ“½οΈ
2 y ago
Published
πŸŽ–οΈ
Vikash Gupta
Publisher
πŸ“ˆ
96%
Success Rate