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?