CS 306 Data base design

QUESTION 1 and The required causes of a query are clauses QUESTION 2 To display the full content of a table named Team, which of the following have correct syntax? Note: Not considering ending with simicolone select team from database select from team select * from teams SELECT * FROM TEAM select from team SELECT PROTEANA 11 QUESTION 2 To display the full content of a table named Team, which of the following have correct syntax? Note: Not considering ending with simicolone select team from database select * from team select * from teams SELECT * FROM TEAM select from team SELECT FROM TEAM select all teams QUESTION 3 (Hotel Reservation db) SELECT clause only Which is the right select clause if you want to display guest number, the check-in date and check-out date from the booking table? select select guest number, check-in date, check out date select bookings O select guestNodateFrom, datelo O select guestNo, hotelNo 1 po QUESTION 4 (DreamHome db) How many columns is the result of this query? SELECT * FROM staff WHERE position != 'manager'; 05 6 8 O other QUESTION 5 (DreamHome db) How many columns is the result of this query? SELECT * FROM registration where branchNo = '3003'; 03 O other QUESTION 6 Based on the data instance you were given the query of the above problem will produce the output: For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac), QUESTION 7 WHERE clause only Which is the right condition for the value of the field population be greater than 100.000 but less than 500,000? where populations between 100000 and 500000 O where population between 100000 and 500000 where population between 500000 and 100000 where 100000 100000 where population 100000 QUESTION 8 WHERE clause only Which is the right condition for the value of the field hotelName is not Trump Hotel? where hotelName !="Trump Hotel where hotelName !-Trump Hotel O where hotel name !'Trump Hotel O where hotel name !- Trump Hotel QUESTION 9 WHERE clause only Which is the right condition for the value of the field Iname ends with 'st? where Iname like %t% where Iname like st96 where Iname likest O where Iname like 'st%" where Iname - 'st where Iname like 'st where Iname like 'st whereinamest where Iname like 'st96 where Iname w sto QUESTION 10 Write a query to list all clients whose email address are with gmail account. QUESTION 11 Write a query to list all hotel names in New York and Toronto, QUESTION 12 Save Write a query to list names of guests who does not have an address in the database, mr 41 Answers to save all anners, QUESTION 12 Write a query to list names of guests who does not have an address in the database, 2 QUESTION 13 >> 111 14px [+ - The v 6 Give a simple example of a query using column alias. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). B 1 VS Paragraph Arial % od 5 EXX, . 1992 Save A Click Save and Submit to save and submit. Click Save All Anuncers to save all answers. !!! 14px QUESTION 14 Give a simple example of a query using calculated values For the toolbar, press ALT+F10 (PO) or ALT+FN+F10 (Mac). BTU & Paragraph Anal a 6 x X 3. The (5) . QUESTION 15 I. 2 > V 14px [+ v (Optional) Give a simple example of a query using DISTINCT For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac) BI VS Paragraph Arial % od a DE X X & The