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 (Solved)
1. Prof_Project (professor, st_name, dept) Proj_stud (project, student no.)
2. Prof_stud (professor, student no) Proj_stud (project, student no)
3. Student (student no, st_name, dept) Student (student no, st_name, dept)
4. Professor(professor, project) Professor( professor, project, dept) Student (student no, st_name, dept)
- b. Prof_stud (professor, student no) Proj_stud (project, student no)