Question: Just the queries please. Also should be done using SQL join commands. Write the following queries, based on the database schema Classes(class, type, country, numGuns,

Just the queries please. Also should be done using SQL join

Just the queries please. Also should be done using SQL join commands.

Write the following queries, based on the database schema Classes(class, type, country, numGuns, bore, displacement) Ships(name, class, launched) Battles(name, date) Outcomes(ship, battle, result) a) Find the ships heavier than 35,000 tons. b) List the name, displacement, and number of guns of the ships engaged in the battle of Guadalcanal c) List all the ships mentioned in the database. (Remember that all these ships may not appear in the Ships relation.)

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!

excecise 2.3.2 69 12:34 PM oppgaver-kap02 (1).pdf 2.3. DEFINING A RELATION SCHEMA IN SQL 37 b) A suitable schema for relation Laptop c) A suitable schema for relation Printer. d) A suitable schema...

Exercise 2 . 4 . 3 : This exercise builds upon Exercise 2 . 3 . 2 concerning World War II capital ships. Recall it involves the following relations: Classes ( class , type, country, numGuns, bore,...

For the battleship database, write expressions of relational algebra to answer the following queries in SQL: Classes (class, type, country, guns, bore, displacement) Ships (name, class, launched)...

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...

Please answer exercise 2.4.3, parts a-h and you can charge for multiple questions. Thanks. The hint for h is that ships are built in classes from the same design, and the class is usually named for...

Please read the direction Database- Express the following constraints in relational algebra. These are based on the given ship data (attached below). Classes(class, type, country, numGuns, bore,...

/* This assignment introduces an example concerning World War II capital ships. It involves the following relations: Classes(class, type, country, numGuns, bore, displacement) Ships(name, class,...

question 5 - 9 Consider the following relational schema: Classes(class, type, country, numGuns, bore, displacement) Ships name, class, launched) Battles(name, date) Outcomes(ship, battle, result)...

/* This assignment introduces an example concerning World War II capital ships. It involves the following relations: Classes(class, type, country, numGuns, bore, displacement) Ships(name, class,...

Write SQL queries for the following requirements Classes(class, type, country, numGuns, bore, displacement) Ships(name, class, launched) Battles(name, date_fought) Outcomes(ship, battle, result)...

Miami Marine uses ROI to evaluate the performance of both its Powerboat and Sailboat Division managers. The following estimates of relevant measures have been made for the upcoming year: Both...

The crate has a mass M and is subjected to a towing force P acting at an angle 1 with the horizontal. If the coefficient of static friction is s, determine the magnitude of P to just start the crate...

Health insurers and HMOs are licensed differently. Group of answer choices True False

c) Determine the boiling point of a solution containing 0.55kg of CHCl3 and 35.0g Eucalyptol (C10H18O). The normal boiling point and molal boiling point elevation constant of CHCl3 are 61.2C and...

LO10.4 Convey how purely competitive firms can use the total-revenuetotal-cost approach to maximize profits or minimize losses in the short run.

LO9.4 Use economies of scale to link a firms size and its average costs in the long run.

LO9.5 Give business examples of short-run costs, economies of scale, and minimum efficient scale (MES).