Tables

Classes(class, type, country, numguns, bore, displacement)
Battles(name, date)
Outcomes(ship, battle, result)
Ships(name, class, launched)


If a class of ships has more than 9 guns, then their bore must be no larger than 14 inches.

How to impose the above condition on table using check constraints

Thanks in advace