Unit II Assignment
Database and SQL Exercise
Refer to the INTRODUCTION on page xxix in the Discovering SQL textbook to download the database script files from
the publisher. Once you have downloaded the files, refer to Appendix A: Installing the Library Database on page 353
in the Discovering SQL textbook to install the Library Database. This will be the database that you will use throughout
the rest of this course. Be sure to keep the original script files that you downloaded from the publisher in case you need
to remove and rebuild your database. After you have loaded the Library database into your DBMS, you should be able
to query the tables. To show that you have completed this step, write a simple SELECT statement to display records from
one of the tables. You should include a WHERE clause with an operator that was discussed in this unit. Save the results
of that query into a text, Word, or Excel file and upload into Blackboard for grading. If you have problems loading the
database, feel free to contact your instructor. You do not have to complete this exercise without assistance. If you need
assistance, your instructor can help you complete it.
In this exercise, you will be typing in SQL commands and executing them against the database that you installed in the
Unit II Database Lab. Be sure that you have completed the Unit II Database Lab before attempting this SQL Lab. You
should complete the following ‘Try It Out’ exercises from the Discovering SQL textbook. Be sure to re-read the sections
preceding each of these, so that you understand what each exercise is accomplishing.
After you have typed in each SQL statement or set of SQL statements and executed them successfully, copy your SQL
code into a Word document. Then create a screen capture of the results window or copy and paste the results into the
text or Word document as well. The text or Word document should contain the results of all five ‘Try It Out’ exercises. Be
sure to label each one with the title of the assignment, the page number in the textbook, and the number of the step you
are performing, so that your instructor can easily tell which one is which. Pay attention to the formatting of your SQL
statements and the labeling, as these items count in the final score as well. The SQL statements should be formatted as
they appear in the book.
Try It Out: Discovering Nulls, page 44
Try It Out: Demonstrating Order of Precedence, page 77
Try It Out: Violating Entity Integrity, page 82
Try It Out: Violating Referential Integrity, page 86
Try It Out: Violating Referential Integrity, pages 88-89
Click here to review the instruction of how to install the library database for Microsoft SQL Server 2012 Express.
No comments:
Post a Comment