write a sql query to retrieve the required information and test the query in mysql

IT 214: Instructions for Homework Assignment 7

[HW7 will not be accepted late]

  • Click the Homework Assignment 7 link to start the assignment. Your unique set of problem numbers will be displayed in a new window (the actual problems are at the end of Chapter 3 of your textbook). Copy the assigned problem numbers.
  • Open a MS Word file and type the course number, section number, HW number, and your name.
  • Paste copied problem numbers into your MS Word file.
  • Log on to MySQL following the instructions you received in class. You can also find the instructions in the Guide to MySQL: PowerPoint presentation for Chapter 3 available on Blackboard.
  • After logging on, 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. Make sure the query, the confirmation messages (if any), and the results (if any) are included in your screen shot. You may use one screen shot for several SQL queries and you may also use several screen shots for one SQL command if needed (see the EXAMPLE section below).
  • Save the file on your disk and submit it through the Homework Assignment 7 Submission link.

Example:

Problem 1: Use the appropriate CREATE TABLE command to create the PART table in the Premiere Products database.

****************************************************************************

  1. The Henry Books: Problem 1 (p. 88). When creating tables, include FKs.
  2. The Henry Books: Problem 2 (p. 88). Add any two records to the BRANCH table. After inserting data, use the SELECT* command to show the content of the table.
  3. The Henry Books: Problem 3 (p. 88). Add any two records to the PUBLISHER table. After inserting data, use the SELECT* command to show the content of the table.
  4. The Henry Books: Problem 4 (p. 88). Add any two records to the AUTHOR table. After inserting data, use the SELECT* command to show the content of the table.
  5. The Henry Books: Problem 5 (p. 88). Add any two records to the BOOK table. Make sure records you chose do not violate referential integrity rules (in other words, foreign key values in the BOOK table are consistent with the primary key values in the PUBLISHER table). After inserting data, use the SELECT* command to show the content of the table.
  6. The Henry Books: Problem 6 (p. 88). Add any two records to the WROTE table. Make sure records you chose do not violate referential integrity rules (in other words, foreign key values in the WROTE table are consistent with the primary key values in the BOOK table and the AUTHOR table). After inserting data, use the SELECT* command to show the content of the table.
  7. The Henry Books: Problem 7 (p. 88). Add any two records to the INVENTORY table. Make sure records you chose do not violate referential integrity rules (in other words, foreign key values in the INVENTORY table are consistent with the primary key values in the BOOK table and the BRANCH table). After inserting data, use the SELECT* command to show the content of the table.
#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational