Consider the following table Collection Books and explain if it is in the first normal form. If not, normalize the table to the first normal form. Book Book A Book B Book C Collection Books Price 20 15 25 1 2 2 3 Author Author X, Author Y Author X, Author Z Author Y, Author Z Student Courses Student ID Student Name CourseID C1 C2 3 (b) [5 points] Consider the following table StudentCourses. Explain if it is in the second normal form. If not, explain which anomalies can occur and normalize the table to the second normal form. Primary keys are underlined. Alice Alice Bob Bob Charlie Charlie Order ID Product Name 1 1 2 2 Publisher Publisher Z Publisher Y Publisher Z C1 C3 C2 C3 T-shirt Jeans T-shirt Shoes Course Name Math English Math (c) [5 points] Give the reason why the following table is not in the third normal form and normalize it. OrderInfo Product Category Customer Name John Smith John Smith Year 2020 2022 2019 Physics English Physics Clothing Clothing Clothing Footwear Mary Johnson Mary Johnson (d) [5 points] Explain if the tables you obtained for the previous question is in BCNF and, if not, normalize it to BCNF.