create table classes $($ class varchar$(20),$ type char $(2),$ country varchar $(20),$ numGuns int, bore int, displacement int, primary key $($class$))$;create table ships $($ name varchar$(20),$ class varchar$(20),$ launched int, primary key $($name$),$ foreign key $($class$)$ references classes$($class$))$;create table battles $($ name varchar$(20),$ date date, primary key $($name$))$;create table outcomes $($ ship varchar$(20),$ battle varchar$(20),$ result varchar$(10),$ primary key $($ship$,$ battle$),$ foreign key $($ship$)$ references ships$($name$),$ foreign key $($battle$)$ references battles$($name$))$;insert into classes values $(\text{'}$Bismarck$\text{'},\text{'}$bb$\text{'},$ 'Germany', $8,15,42000)$;insert into classes values $(\text{'}$Iowa$\text{'},\text{'}$bb$\text{'},$ 'USA', $9,16,46000)$;insert into classes values $(\text{'}$Kongo$\text{'},\text{'}$bc$\text{'},$ 'Japan', $8,14,32000)$;insert into classes values $(\text{'}$North Carolina', $\text{'}$bb$\text{'},$ 'USA', $9,16,37000)$;insert into classes values $(\text{'}$Renown$\text{'},\text{'}$bc$\text{'},\text{'}$Gt$.$ Britain', $6,15,32000)$;insert into classes values $(\text{'}$Revenge$\text{'},\text{'}$bb$\text{'},\text{'}$Gt$.$ Britain', $8,15,29000)$;insert into classes values $(\text{'}$Tennessee$\text{'},\text{'}$bb$\text{'},$ 'USA', $12,14,32000)$;insert into classes values $(\text{'}$Yamato$\text{'},\text{'}$bb$\text{'},$ 'Japan', $9,18,65000)$;insert into ships values $(\text{'}$California$\text{'},$ 'Tennessee', $1921)$;insert into ships values $(\text{'}$Haruna$\text{'},$ 'Kongo', $1915)$;insert into ships values $(\text{'}$Hiei$\text{'},$ 'Kongo', $1914)$;insert into ships values $(\text{'}$Iowa$\text{'},$ 'Iowa', $1943)$;insert into ships values $(\text{'}$Kirishima$\text{'},$ 'Kongo', $1915)$;insert into ships values $(\text{'}$Kongo$\text{'},$ 'Kongo', $1913)$;insert into ships values $(\text{'}$Missouri$\text{'},$ 'Iowa', $1944)$;insert into ships values $(\text{'}$Mushashi$\text{'},$ 'Yamato', $1942)$;insert into ships values $(\text{'}$New Jersey', 'Iowa', $1943)$;insert into ships values $(\text{'}$North Carolina', 'North Carolina', $1941)$;insert into ships values $(\text{'}$Ramillies$\text{'},$ 'Revenge', $1917)$;insert into ships values $(\text{'}$Renown$\text{'},$ 'Renown', $1916)$;insert into ships values $(\text{'}$Repulse$\text{'},$ 'Renown', $1916)$;insert into ships values $(\text{'}$Resolution$\text{'},$ 'Revenge', $1916)$;insert into ships values $(\text{'}$Revenge$\text{'},$ 'Revenge', $1916)$;insert into ships values $(\text{'}$Royal Oak', 'Revenge', $1916)$;insert into ships values $(\text{'}$Royal Sovereign', 'Revenge', $1916)$;insert into ships values $(\text{'}$Tennessee$\text{'},$ 'Tennessee', $1920)$;insert into ships values $(\text{'}$Washington$\text{'},$ 'North Carolina', $1941)$;insert into ships values $(\text{'}$Wisconsin$\text{'},$ 'Iowa', $1944)$;insert into ships values $(\text{'}$Yamato$\text{'},$ 'Yamato', $1941)$;insert into battles values $(\text{'}$North Atlantic', $\text{'}1941-05-24\text{'})$;insert into battles values $(\text{'}$Guadalcanal$\text{'},\text{'}1942-11-15\text{'})$;insert into battles values $(\text{'}$North Cape', $\text{'}1943-12-26\text{'})$;insert into battles values $(\text{'}$Surigao Straight', $\text{'}1944-10-25\text{'})$;insert into outcomes values $(\text{'}$California$\text{'},$ 'Surigao Straight', $\text{'}$ok$\text{'})$;insert into outcomes values $(\text{'}$Haruna$\text{'},$ 'Surigao Straight', 'sunk'$)$;insert into outcomes values $(\text{'}$Iowa$\text{'},$ 'Guadalcanal', $\text{'}$ok$\text{'})$;insert into outcomes values $(\text{'}$Iowa$\text{'},$ 'Surigao Straight', $\text{'}$ok$\text{'})$;insert into outcomes values $(\text{'}$Kirishima$\text{'},$ 'Guadalcanal', 'sunk'$)$;insert into outcomes values $(\text{'}$Mushashi$\text{'},$ 'Surigao Straight', 'sunk'$)$;insert into outcomes values $(\text{'}$New Jersey', 'Guadalcanal', 'damaged'$)$;insert into outcomes values $(\text{'}$New Jersey', 'Surigao Straight', $\text{'}$ok$\text{'})$;insert into outcomes values $(\text{'}$Ramillies$\text{'},$ 'North Atlantic', 'sunk'$)$;insert into outcomes values $(\text{'}$Renown$\text{'},$ 'North Cape', $\text{'}$ok$\text{'})$;insert into outcomes values $(\text{'}$Repulse$\text{'},$ 'North Atlantic', 'sunk'$)$;insert into outcomes values $(\text{'}$Resolution$\text{'},$ 'North Atlantic', $\text{'}$ok$\text{'})$;insert into outcomes values $(\text{'}$Revenge$\text{'},$ 'North Atlantic', 'damaged'$)$;insert into outcomes values $(\text{'}$Revenge$\text{'},$ 'North Cape', 'damaged'$)$;insert into outcomes values $(\text{'}$Royal Oak', 'North Atlantic', $\text{'}$ok$\text{'})$;insert into outcomes values $(\text{'}$Royal Oak', 'North Cape', 'damaged'$)$;insert into outcomes values $(\text{'}$Royal Sovereign', 'North Cape', 'sunk'$)$;insert into outcomes values $(\text{'}$Tennessee$\text{'},$ 'Surigao Straight', $\text{'}$ok$\text{'})$;insert into outcomes values $(\text{'}$Washington$\text{'},$ 'Guadalcanal', $\text{'}$ok$\text{'})$;

$($a$)$

Write multiple views that combine at least $2$ tables in some sensible way.

$($b$)$

Write one $($INSTEAD OF$)$ trigger that will add a row to the proper tables should someone attempt to add a row to the view that you created.