Why might a designer choose to define a composite primary key in a table?

You want to show the total cargo weight shipped by each ship. Which query gives each ship name and the total cargo weight it carried?

Why is data typically stored across multiple tables in a relational database?

Given table SHIP, write an SQL query to find the ship types that have an minimum length less than 200, along with the count of ships for those types.

You want to see the number of voyages each ship has taken. Each result should show the ship’s name and how many voyages are listed in SHIP_VOYAGE. Which query works?

What does the BETWEEN operator do in a SQL query?

Given table SHIP, write an SQL query using the SHIP table to retrieve the unique ship owner_names present in the table.

What is the primary role of an associative entity in a relational schema?

If you learn one implementation of SQL, what does that mean for learning others?

You want to create a list of ship names and their destination ports for voyages that went to ‘Singapore’. You use a CTE to define the voyages first. Which query gives the correct result?