Chapter 5 MySQL Assignment

Instructions for Homework Assignment 9

1. After logging on to my 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. If you did not run scripts creating the Premiere Products, Henry Books, and Alexamara Marina Group databases, you need to run the scripts. Follow the instructions given in the Guide to MySQL: PowerPoint Presentation for Chapter 4 available on Blackboard.
3. 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. Make sure the query, the confirmation messages (if any), and the results (if any) are included in your screen shot.
4. Save the file on your disk and submit it through the Homework Assignment 9 Submission link.

QUESTION 1

• Henry Books Database: Problem 1 (p. 159)

QUESTION 2

• Alexamara Marina Group Database: Problem 9 (p. 160)

QUESTION 3

• Henry Books Database: Problem 4 (p. 159)

QUESTION 4

• Premiere Products Database: Problem 11 (p. 158)

QUESTION 5

• Alexamara Marina Group Database: Problem 4 (p. 160)

QUESTION 6

• Henry Books Database: Problem 8 (p. 159)

QUESTION 7

• Alexamara Marina Group Database: Problem 8 (p. 160)

QUESTION 8

• Alexamara Marina Group Database: Problem 3 (p. 160)

QUESTION 9

• Premiere Products Database: Problem 14 (p. 158)

QUESTION 10

• Premiere Products Database: Problem 13 (p. 158)

QUESTION 11

• Alexamara Marina Group Database: Problem 11 (p. 160)

QUESTION 12

• Henry Books Database: Problem 6 (p. 159)

QUESTION 13

• Premiere Products Database: Problem 16 (p. 158)

QUESTION 14

• Henry Books Database: Problem 2 (p. 159)

QUESTION 15

• Alexamara Marina Group Database: Problem 15 (p. 160)

QUESTION 16

• Henry Books Database: Problem 17 (p. 159)

QUESTION 17

• Henry Books Database: Problem 13 (p. 159)

QUESTION 18

• Alexamara Marina Group Database: Problem 14 (p. 160)

QUESTION 19

• Henry Books Database: Problem 14 (p. 159)

QUESTION 20

• Premiere Products Database: Problem 17 (p. 158)

Notes: Attached is the problems for chapter 5 that is needed to answer the questions above.