Question: Write each of the queries in SQL making sure that duplicates are eliminated: Classes(class, type, country, numGuns, bore, displacement) Ships (name, class, launched) Battles (name,

Write each of the queries in SQL making sure that duplicates are eliminated:

Classes(class, type, country, numGuns, bore, displacement) Ships (name, class, launched) Battles (name, date) Outcomes (ship, battle, result) a. Give the class name and countries of the classes that carried guns of at least 16-inch bore b. Find the ships launced prior to 1921 c. Find the ships sunk in the battle of Denmark Strait d. The treaty of Washington n 1921 prohibited capital ships heavier than 35000 tons. List the ships that violated the Traty of Washington e. List the name, displacement, and the number of guns f the ships engaged in the battla of Guadalcanal f. List all of the capital ships mentioned in the database

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Exercise 2.5.2: Express the following constraints in relational algebra. The constraints are based on the relations of Exercise 2.3.2: 2.3.2: This exercise introduces another running example ,...

Exercise 9.3.2: Write the following embedded SQL queries, based on the database schema Classes (class, type, country, numGuns, bore, displacement) Ships (name, class, launched) Battles (name, date...

Exercise 6.4.7: Write the following queries, based on the database schema Classes (class, type, country, numGuns, bore, displacement) Ships (name, class, launched) Battles (name, date) Outcomes...

All I need just 6.5.2 question c. Exercise 6.5.2: Write the following database modifications, based on the database schema Classes (class, type, country, numGuns, bore, displacement) Ships (name,...

Database 2: Here is another database schema concerning World War II capital ships. It involves the following relations: Classes (class, type, country, guns, bore, displacement) Ships (name, class,...

Write the SQL table for database 2 and 3 with proper primary key and attributes ? Fil: Ei Vi Windom Helo Home Tools sign In Database 2: Here is another database schema concerning World WarI capital...

Exercise 2.3.2: This exercise introduces another running example , concerning World War II capital ships . It involves the following relations : Classes ( class , type , country , numGuns , bore ,...

Exercise 7.5.3: Write the following as triggers. In each case, disallow or undo the modification if it does not satisfy the stated constraint. The database schema is from the battleships example of...

Exercise 6.1.4: Write the following queries based on the database schema of Exercise 2.4.3: Classes ( class , type , country , numGuns , bore , displacement ) Ships ( name , class , launched )...

Exercise 6.3.2: Write the following queries, based on the database schema Classes (class, type, country, numGuns, bore, displacement) Ships (name, class, launched) Battles (name, date) Outcomes...

ABC company management has decided to revamp their performance appraisal system. As human resources director, you have been tasked with outlining a new program. The goal is to move every business...

The system of linear equations has a unique solution . Find the solution using gaussian elimination or gauss jordan x-2y + z=7 y+2z=19 x+y+3z=36

units 3 and 4 ) 0 . 2 3 . Page 1 6 of 1 8 Question 1 6 ( 1 0 points ) Simon bought a 3 . 5 % bond price at 9 0 % of par that had 3 7 years until it matures. 1 year later the yield to maturity on this...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

4. EMC Corporation

5. Conduct a phone or personal interview with a training manager. Ask this person to discuss how training has changed in the past five years and how he or she believes it will change in the future.

6. Vanguard