(Solved): A database for a textbook publisher needs to be created. The following tables are designed f ...

A database for a textbook publisher needs to be created. The following tables are designed for this purpose. Also, some sample data is provided below. Author Table: Book Table: Authorship Table: Schema for the database: Answer the following questions using the information given above. Write your code below each question. - Write the SQL code to create these three tables. Make sure you have primary and foreign key constraints included in the code. - Write the SQL code to insert the sample data into each table. - Write SQL code to insert a new column onto Books table called "pricelncTax" which is FLOAT type and populate it with values calculated as pricelncTax \( = \) price \( * 1.07 \). - Write SQL code to delete books from book table whose price is less than \( \$ 10 \).