Computers and Technology

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

answer
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 21.06.2019 22:00, gabesurlas
You should try to photograph people on bright sunny days because the light will be best a) true b) false
Answers: 1
image
Computers and Technology, 22.06.2019 23:00, nicog94
In which part of a professional email should you try to be brief, but highly descriptive?
Answers: 1
image
Computers and Technology, 23.06.2019 02:50, CrusaderLord
Define a class named movie. include private fields for the title, year, and name of the director. include three public functions withprototypes void movie: : settitle(cstring); , voidmovie: : setyear(int); , void movie: : setdirector(string); . includeanother function that displays all the information about a movie. write a main() function that declares a movie object namedmyfavoritemovie. set and display the object's fields. this is what i have but know its wrong since it will notcompile: #include#includeusing namespace std; //class declarationclass movie{private: string movietitle ; string movieyear; string directorname; public: void settitle(string title); void setyear(string year); void setdirector(string director); void displayinfo(); }; //class implementationvoid movie: : settitle(string title){ movietitle = title; cout< < "what is the title of themovie? "< > temp; myfavoritemovie. settitle(temp); cout< < "enter movie year"< > temp; myfavoritemovie. setyear(temp); cout< < "enter director'sname"< > temp; myfavoritemovie. setdirector(temp); //display all the data myfavoritemovie. displayinfo(); system("pause"); return 0; this code is not entirely mine someone on cramster edited my firstcode but then i try manipulating the new code and i still get acompile error message : \documents\visual studio 2008\projects\movie\movie\movie. cpp(46) : error c2679: binary '< < ' : no operator found which takes aright-hand operand of type 'std: : string' (or there is no acceptableconversion)c: \program files (x86)\microsoft visual studio9.0\vc\include\ostream(653): could be'std: : basic_ostream< _elem,_traits> & std: : operator< < > (std: : basic_ostream< _elem,_traits> & ,const char *)w
Answers: 1
image
Computers and Technology, 23.06.2019 06:10, erick7123
The head restraint should be adjusted so that it reaches a. the top of your ears b. the base of your skull c. the top of the head
Answers: 1
Do you know the correct answer?
Consider the following relational schema and corresponding sample data: Classes (class, type, countr...

Questions in other subjects: