Answer the following questions using the information given above. Write your code below each question.

1) Write the SQL code to create these three tables. Make sure you have primary and foreign key constraints included in the code.

2) Write the SQL code to insert the sample data into each table.

3) Write SQL code to insert a new column onto Books table called priceIncTax which is FLOAT type and populate it with values calculated as priceIncTax = price * 1.07.

4) Write SQL code to delete books from book table whose price is less than $10.