Classes(class, type, country, numGuns, bore, displacement) Ships (name, class, launched) Battles (name, date) Outcomes (ship, battle, result) (a) Sample data for relation Classes (b) Sample data for relation Battles (c) Sample data for relation Outcomes Figure 2.23: Sample data for relation Ships These questions concern the ship relations: a) Find the ship name and ship type ('bc' or 'bb') of each of the individual ships produced by Gt. Britain. You must use a join (i.e., cross product) followed by a WHERE. (NOTE: the type attribute is named "stype", which is slightly different from the book.) b) Find the ship name and ship type ('bc' or 'bb') of each of the individual ships produced by Gt. Britain. You must use a natural join. c) Find the displacement (weight) of the Musashi. You must use a join (i.e., cross product) followed by a WHERE. d) Find the displacement (weight) of the Musashi. You must use a subquery that returns a scalar