a) Create a new database as test.db. Create the tables with the following schema usingDDL commands.Sailors (sid: PK, sname: must be unique, rating: Between 0 and 5, age)Boats (bid: PK, bname, color (Must be blue or black only)Reserves (rid: PK, sid: FK, bid: FK, date: Default value: current date.)Note: If the record from boats is updated, its value should be set null in Reserves.b) Apply following queries.1) A new reservation of boat with id 208 and sailor with id S03 has been done on 2019-12-26. Store thi.data.2) Find all the sailors with a rating below 3.3) Create a view that will display the names of sailors who have reserved boat with id 109.4) Find the boat ids that are not reserved.5) Add a new column design to the Boat table.6) Show the names of sailor and color of boat who have reserved black color boat.7) Delete the reservations made on date 2019-10-12.8) Find the average age of all sailors.

Note: As per our guidelines we can able to solve only one big question at a time. So, please repost…

a) Create a new database as test.db. Create the tables with the following schema using DDL commands. Sailors (sid: PK, sname: must be unique, rating: Between 0 and 5, age) Boats (bid: PK, bname, color (Must be blue or black only) Reserves (rid: PK, sid: FK, bid: FK, date: Default value: current date.) Note: If the record from boats is updated, its value should be set null in Reserves.