MySQL Query

User Generated

Qrfvtny2

Computer Science

IT 214

George Mason University

Description

  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)


Notes: Attached is the chapter 4 problems from the book that will be needed to answer the questions.

Unformatted Attachment Preview

IT-214 A GUIDE TO MYSQL Chapter 4 Problems:
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Related Tags