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.
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
The post write a sql query to retrieve the required information and test the query in mysql appeared first on My Nursing Experts.
