Question 1

Use bottom three pcitures for data requied. First three pictues have questions on them.

Question 1

Henry Books Database: Problem 18 (p.126)

QUESTION 2

Premiere Products Database: Problem 3 (p.125)

QUESTION 3

Alexamara Marina Group Database: Problem 7 (p.127)

QUESTION 4

Premiere Products Database: Problem 14 (p.125)

QUESTION 5

Henry Books Database: Problem 7 (p.126)

QUESTION 6

Alexamara Marina Group Database: Problem 4 (p.127)

QUESTION 7

Premiere Products Database: Problem 17 (p.125)

QUESTION 8

Henry Books Database: Problem 21 (p.126)

QUESTION 9

Premiere Products Database: Problem 1 (p.125)

QUESTION 10

Premiere Products Database: Problem 12 (p.125)

QUESTION 11

Alexamara Marina Group Database: Problem 1 (p.127)

QUESTION 12

Premiere Products Database: Problem 9 (p.125)

QUESTION 13

Premiere Products Database: Problem 13 (p.125)

QUESTION 14

Alexamara Marina Group Database: Problem 8 (p.127)

QUESTION 15

Henry Books Database: Problem 8 (p.126)

QUESTION 16

Henry Books Database: Problem 12 (p.126)

QUESTION 17

Henry Books Database: Problem 16 (p.126)

QUESTION 18

Henry Books Database: Problem 9 (p.126)

QUESTION 19

Premiere Products Database: Problem 15 (p.125)

QUESTION 20

Henry Books Database: Problem 10 (p.126)

arina Group database (Figures 1-8 through 1-12 in Chapter 1) Alexamara Marina Gro nd the lexaas. Use the notes at the end of Chapter 3 to print your output if saL My Use w let to do so by your instructor r number, last name, and first name of every boat owner te MARINA table (all rows and all columns). t le 127 2 List the complete me and first name of every owner located in Bowton. the last name and first name of every owner not located in Bowt on number and slip number for every slip whose length is equal to or less than List the marina 30 feet List the marina a 5. number and slip number for every boat with the type Dolphin 28. the slip number for every boat with the type Dolphin 28 that is located in marina 1. List t name for each boat located in a slip whose length is between 25 and 30 feet. List the boa the slip number for every slip in marina 1 whose rental fee is less than $3,000. List Labor is billed at the rate of $60 per hour. List the slip ID, category number, estimated hours, and estimated labor cost for every service request. To obtain the estimated labor cost, mul- tiply the estimated hours by 60. Use the column name ESTIMATED_COST for the esti- mated labor cost. 10. 1. List the marina number and slip number for all slips containing a boat with the type Sprite 12 List the marina number, slip number, and boat name for all boats. Sort the results by boat 13. How many Dolphin 28 boats are stored at both marinas? 4000, Sprite 3000, or Ray 4025 name within marina number. 14. Calculate the total rental fees Alexamara receives each year based on the length of the slip