Consider the following relations for ships visit ports application where primary keys are underlined. Answer all queries in the language asked for (alternate language gets no credit). MAKER (Maker_Name, Registration_Country)
SHIP (Ship_ID, Ship_Name, Maker_Name, Model, Built_Year )
PORT (Port_ID, Port_Name, Location_Country)
SHIP_VISIT(Ship_ID, Port_ID, Date, Duration_in_Days)

Required:
a. Show how to insert the tuple in SHIP_VISIT (using SQL). What kind of checks must the system perform to guarantee integrity of the above database?
b. Do the following queries in the language(s) indicated: 1B.1. list the ship_name and model of ships that visited the country where it was built. (using SQL)