EMERGENCY!!! PLEASE HELP!!! I WILL VOTE FOR YOUR SOLUTION

10. Consider the following relation StudyProgram which is used to store information about study programs: [10] Study Program (SNo, Studyprogram, Number Semester, StaffNo, LastName, Phone) Each study program (like Informatik Bachelor) has a unique study program number (SNo) and a unique name (Sudyprogram). Further the duration in number of semesters for the program is stored (NumberSemester) as well as for the professor heading the program the staff number (StaffNo), last name (LastName) and his phone number ((Phone). Each study program has one Professor heading the program, but a professor might be heading several study programs. No two professors have the same staff number, but there are potentially staff members with the same last name and staff members might share the phone number. a) Write down all functional dependencies. [3] b) Detect all candidate keys by analyzing the functional dependencies. [2] c) Evaluate the relational design with the relation StudyProgram as given above. [5] cl) In which (if any) normal form is relation the relation StudyProgram? c2) Is relation Study Program in Boyce-Codd-Normal form (BCNF)? If not, create a relational schema in BCNF by decomposing relation StudyProgram. Underline primary key attributes