Appropriate Location

1. After logging on to MySQL, set the default database (type USE your_user_name;command at the mysql> prompt) and engine (type SET storage_engine=InnoDB;command at the mysql> prompt).
2. For each of the assigned problems, write a SQL query to retrieve the required information and test the query in MySQL. Once the query is successfully executed, type your first name and last name at the next mysql> prompt and take a screen shot (press ALT+PRINT SCREEN by holding down the ALT key and then pressing the PRINT SCREEN key). Paste the screen shot in the appropriate location in your MS Word file.
3. Save the file on your disk and submit it through the Homework Assignment 8 Submission link.

QUESTION 1

Henry Books Database: Problem 14 (p.126)

QUESTION 2

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

QUESTION 3

Henry Books Database: Problem 2 (p.126)

QUESTION 4

Henry Books Database: Problem 21 (p.126)

QUESTION 5

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

QUESTION 6

Premiere Products Database: Problem 11 (p.125)

QUESTION 7

Henry Books Database: Problem 5 (p.126)

QUESTION 8

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

QUESTION 9

Premiere Products Database: Problem 12 (p.125)

select * from Part order by Description;

QUESTION 10

Henry Books Database: Problem 18 (p.126)

QUESTION 11

Premiere Products Database: Problem 3 (p.125)

QUESTION 12

Henry Books Database: Problem 12 (p.126)

QUESTION 13

Premiere Products Database: Problem 2 (p.125)

QUESTION 14

Premiere Products Database: Problem 15 (p.125)

QUESTION 15

Henry Books Database: Problem 10 (p.126)

QUESTION 16

Premiere Products Database: Problem 20 (p.125)

QUESTION 17

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

QUESTION 18

Premiere Products Database: Problem 6 (p.125)

QUESTION 19

Premiere Products Database: Problem 18 (p.125)

QUESTION 20

Premiere Products Database: Problem 14 (p.125)