QUESTION 1 Consider the following relational database schema. Book (BookNo, BookTitle, BookType) Orders (Order No, BookNo, CustomerID, Price) Write SQL Query to find the total amount of money spent on orders for books of type "Science" (i.e. BookType = "Science") QUESTIONS Consider the following relational database schema for a conference management system. Author (AuthorID, AuthorName, Author University, UniversityCountry) Conference Attendance ConferencelD, AuthorID, Conference-Name, Conference-Location) Decompose the relations above to 3NF relations. Clearly show your work step-by-step. QUESTIONS Consider the following relational database schema for a conference management system. Author (AuthorID, AuthorName, Author University, UniversityCountry) Conference Attendance ConferencelD, AuthorID, Conference-Name, Conference-Location) Decompose the relations above to 3NF relations. Clearly show your work step-by-step