Computers and Technology, 06.11.2021 06:50 johndiaz26

Consider the following relational schema and corresponding sample data: Classes (class, type, country, num Guns, bore, displacement) Ships (name, class, launched) Battles (name, date) Outcomes (ship, battle, result) class type country numGuns bore displacement Bismarck bb Germany 8 15 42,000 Iowa bb USA 9 16 46,000 Kongo be Japan 8 14 32,000 North Carolina bb USA 9 16 37,000 Renown be Britain 6 15 32,000 Revenge bb Britain 8 15 29,000 Tennessee bb USA 12 14 32,000 Yamato bb Japan 18 65,000 name date Denmark Strait 05/24/41 Guadalcanal 11/15/42 North Cape 12/26/43 Surigao Strait 10/25/44 name class California Tennessee Haruna Kongo Hiei Kongo Iowa Iowa Kirishima Kongo Kongo Kongo Missouri Iowa Musashi Yamato New Jersey Iowa North Carolina North Carolina Ramillies Revenge Renown Renown Repulse Renown Resolution Revenge Revenge Revenge Royal Oak Revenge Royal Sovereign Revenge Tennessee Tennessee Washington North Carolina Wisconsin Iowa Yamato Yamato launched 1915 1915 1915 1933 1915 1913 1935 1942 1936 1941 1917 1916 1916 1916 1916 1916 1916 1915 1941 1940 1941 ship battle California Surigao Strait Kirishima Guadalcanal Resolution Denmark Strait Wisconsin Guadalcanal Tennessee Surigao Strait Washington Guadalcanal New Jersey Surigao Strait Yamato Surigao Strait Wisconsin Surigao Strait result ok sunk ok damaged ok ok ok sunk damaged SQL Relational Algebra form
List the name, displacement, and number of guns of the ships engaged in the battle ofSurigao Strait.
List the name of all the ships from the database. Ships appear inShips, Classes, andOutcomestables. All of them have to be printed.
Find the classes that have exactly two ships in the class.
Find the countries that have both bb and bc ships

Answers: 1

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 00:20

The pyraminx is a rubik's cube-type toy in the shape of a tetrahedron (not a pyramid). the pyraminx shown below has edges 15\,\text{cm}15cm15, space, c, m long and vertical height h=12.2\,\text{cm}h=12.2cmh, equals, 12, point, 2, space, c, m. the triangle drawn with dashed lines is a right triangle. what is the distance rrr? round your answer to the nearest tenth.

Answers: 1

Answer

Computers and Technology, 22.06.2019 13:00

Write a program which asks you to enter a name in the form of first middle initial last. so you might enter for example samuel p. clemens. use getline to read in the string because it contains spaces. also, apparently the shift key on your keyboard doesn’t work, because you enter it all lower case. pass the string to a function which uses .find to locate the letters which need to be upper case and use toupper to convert those characters to uppercase. the revised string should then be returned to main in the form last, first mi where it will be displayed.

Answers: 1

Answer

Computers and Technology, 22.06.2019 19:20

Consider the following code snippet: #ifndef cashregister_h#define cashregister_hconst double max_balance = 6000000.0; class cashregister{public: cashregister(); cashregister(double new_balance); void set_balance(double new_balance); double get_balance() const; private: double balance[12]; }; double get_monthly_balance(cashregister bk, int month); #endifwhich of the following is correct? a)the header file is correct as given.b)the definition of max_balance should be removed since header files should not contain constants.c)the definition of cashregister should be removed since header files should not contain class definitions.d)the body of the get_monthly_balance function should be added to the header file.

Answers: 1

Answer

Computers and Technology, 23.06.2019 18:30

Janice recently received her college degree and is looking for a job. she is worried that since she just finished school, she will be required to repay her perkins and direct subsidized loans immediately. janice pulls out the paperwork she signed and reviews it again for repayment information. after reading all of the information, janice discovers that

Answers: 2

Answer

You know the right answer?

Consider the following relational schema and corresponding sample data: Classes (class, type, countr...

Questions