![](https://csdnimg.cn/release/download_crawler_static/10952506/bg11.jpg)
Oracle-DropPremiere.sql: Drops (deletes) all the tables and data in the Premiere
Products database.
The script files saved in the SQL Server folder have the following functions:
SQLServer-Alexamara.sql: Creates all the tables in the Alexamara Marina Group data-
base and adds all the data. Run this script file to create the Alexamara Marina Group
database. (Note: This script file assumes you have not previously created any of the tables
in the database. If you have created any of the tables, you should run the
SQLServer-DropAlexamara.sql script prior to running the SQLServer-Alexamara.sql script.)
SQLServer-Henry.sql: Creates all the tables in the Henry Books database and adds all
the data. Run this script file to create the Henry Books database. (Note: This script file
assumes you have not previously created any of the tables in the database. If you have cre-
ated any of the tables, you should run the SQLServer-DropHenry.sql script prior to running
the SQLServer-Henry.sql script.)
SQLServer-Premiere.sql: Creates all the tables in the Premiere Products database and
adds all the data. Run this script file to create the Premiere Products database. (Note: This
script file assumes you have not previously created any of the tables in the database. If you
have created any of the tables, you should run the SQLServer-DropPremiere.sql script
prior to running the SQLServer-Premiere.sql script.)
SQLServer-DropAlexamara.sql: Drops (deletes) all the tables and data in the
Alexamara Marina Group database.
SQLServer-DropHenry.sql: Drops (deletes) all the tables and data in the Henry Books
database.
SQLServer-DropPremiere.sql: Drops (deletes) all the tables and data in the Premiere
Products database.
For details on running script files in Oracle or SQL Server, check with your instructor.
You can also refer to Chapter 3 in the text for information about creating and using scripts.
For information about downloading the Oracle Database 10g Express Edition software,
please visit the Oracle Web site. For information about SQL Server 2005, please visit the
Microsoft Web site. Information about Microsoft Access is also available at the Microsoft
Web site.
Embedded Questions
In many places, you’ll find Q&A sections to ensure that you understand some crucial
material before you proceed. In some cases, the questions are designed to give you the
chance to consider some special concept in advance of its actual presentation. In all cases,
the answer to each question appears immediately after the question. You can simply read
the question and its answer, but you will benefit from taking time to determine the answer
to the question before checking your answer against the one given in the text.
End-of-Chapter Material
The end-of-chapter material consists of a Summary, a Key Terms list, Review Questions,
and exercises for the Premiere Products, Henry Books, and Alexamara Marina Group
databases. The Summary briefly describes the material covered in the chapter. The Review
Questions require you to recall and apply the important material in the chapter. The
answers to the odd-numbered Review Questions appear in Appendix C so you can check
xvi