Database Schema
Classes(class, type, country, numGuns, bore, displacement)
Ships(name, class, launched)
Battles(name, date)
Outcomes(ship, battle, result)
Based on exercise 6.2.3 ( page 267 - 268 )
1. Find the ships lighter than 45,000 tone ?
2. Find the name, displacement and number of guns of the ships engaged in the battle of Denmark strait.
3. List all the tables contained in the database , across all the tables?
4. Find those countries have only battle ship and battle cruisers ?
5. Find those ships that fought at least two battles, without ever being sunk.
6. Find those battles with at least two ships of the same country?