IT 214: Instructions for Homework Assignment 7 [HW7 will not
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.****************************************************************************The Henry Books: Problem 1 (p. 88). When creating tables, include FKs.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.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.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.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.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.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.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
