Question

SERVICE REQUEST SERVICE SLIP CATEGORY DESCRIPTION EST SPENT NEXT HOURS HOURS SERVICE ID I DATE unit shuts down able to replicate with HHH showing the problem. Air the control ran fine through multiple tests. Owners to notify technician if the problem recurs. S Both speed and Technician has 0 7/1o/2007 depth readings on scheduled data unit are significantly less with owner to than the owner thinks they shouldthe problem. attempt to verify Technician 2 7/12/2007 as makin clattering sound.elther propeller problem with or shaft and has scheduled the boat to be pulled from the water for further 5 Owner accidentTechnician has 01 7/13/2007 caused damage to scheduled forward portion of repair. 15 11 Overlap has 3 7/17/2007 around zippers inbeen ereated heavy rain. Install Installation has overlap around been scheduled. zippers to prevent FIGURE 1-12 Sample data about service requests at Alexamara Marina Group (continued) The Alexamara Marina Group exercises at the end of this chapter will give you a chance to check your understanding of the data in this database.

Questions (1,2,12)

Answer 1

Please find the answer queries below for the queries 1,2,12 with output in MySQL database :

1

SELECT OWNER_NUM, LAST_NAME,FIRST_NAME FROM OWNER;

Output:

mysal> SELECT OWNER NUM, LAST NAME, FIRST NAME FROM OWNER | OWNER NUM Í LAST NAME | FIRST NAME | AD57 AN75 BL72 EL25 FE82 JU92 |KE22 | NO27 SM72 TR72 Adney Bruce and Jean | Anderson Bill |Blake Mary Elend Sandy and Bill | | Feenstra | Daniel JuarezMaria | Kelly Alyssa Norton Peter | SmeltzBecky and Dave | Trent Ashton 10 rows in set (0.00 sec)

2
SELECT * FROM MARINA;

Output:

mysql> SELECTFROM MARINA; | MARINA_NUM | NAME ADDRESS CITY | STATE | ZIP Hl. | Alexamara East 108 2nd Ave Alexamara Central | 283 Branston. W. Brinman | FL 32274 | . |Brinman FL 32273 1 2 2 rows in set (0.00 sec)

12
SELECT MARINA_NUM, SLIP_NUM, BOAT_NAME from MARINA_SLIP order by MARINA_NUM, BOAT_NAME;

Output:

mysql> SELECT MARINA_NUM, SLIP_NUM, BOAT_NAME from MARINA_SLIP order by MARINA NUM, BOAT_NAME; | MARINA_NUM | SLIP_NUM| BOAT_NAME Anderson II | |Anderson III| A1 B2 A3 B1 A2 Escape | Gypsy Our Toy 2 2 2 Axxon II | Bravo | Chinook | Karvel | Listy 2 4 Mermaid 11 rows in set (0.00 sec)