use sql database knowledge to solve the following questions:

Normalize the following table to satisfy BCNF: COURSESECTION(SectionID, CourselD, CourseName, Term, Professor!D, ProfessorName, ProfessorEmail). (Hints: functional dependency (1) SectionID CourselD, CourseName, Term, Professor!D, ProfessorName, ProfessorEmail; (2) CourseID CourseName; (3) Professor!D ProfessorName, ProfessorEmail) 5. Professor Name SectionID CourseID CourseName Term ProfessorID ProfessorEmail 201702 ITIT101 2017 Introduction to Alice H001 H002 H002 alice@h.edu 101 01 201709 IT 101_01 Computational Tools Spring 2017 Fall 2017 Fall 2017 Fall 2017 Spring 2017 Fall 2017 Spring 2017 Fall Introduction to Computational Tools Java Programming IT101 bob@h.edu bob@h.edu Cindy cindy@h.edu Cindy indv@h.edu Bob 201709_ITIT102 Bob 102 01 201709 IT 102 02 201702 IT 117_01 201709 IT 117 01 201702_T 120 01 201709 IT 120 01 IT102 IT117 T117 H003 H003 H001 H001 Java Programming Database Database Computer Network Computer Network Alice alice@h.edu Alice Bob alice@h.edu IT120 H002 bob@h.edu