ITC 4175 Unit II Assignment

profilephibbs1987

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. 

 

  • 10 years ago
  • 5
Answer(0)
Bids(0)