MySQL Query
User Generated
Qrfvtny2
Computer Science
IT 214
George Mason University
Description
- 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).
- 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.
- 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
This question has not been answered.
Create a free account to get help with this and any other question!
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
Oliver Twist
by Charles Dickens
Fences
by August Wilson
Herzog
by Saul Bellow
The Girl With The Dragon Tattoo
by Stieg Larsson
Enders Game
by E. M. Forster
Ezperanza Rising
by Pam Muñoz Ryan
A Portrait of the Artist as a Young Man
by James Joyce
Othello
by Wiliam Shakespeare
The Scarlet Letter
by Nathaniel Hawthorne