SQL指南（第八版）：详解数据库语句与概念

SQL

需积分: 9 52 浏览量更新于2024-07-17 收藏 4.68MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源推荐

the required and optional clauses and operators, and an example and its results. It also

contains a reference to the pages in the text where the command is covered.

Appendix B: How Do I Reference

Appendix B provides students with an opportunity to ask a question, such as “How do I

delete rows?”, and to identify the appropriate section in Appendix A to use to find the

answer. Appendix B is extremely valuable when students know what task they want to

accomplish but can’t remember the exact SQL command they need.

Appendix C: Answers to Odd-Numbered Review Questions

Answers to the odd-numbered Review Questions in each chapter appear in this appendix

so students can make sure that they are completing the Review Questions correctly.

GENERAL NOTES TO THE STUDENT

You can download the databases used in this text from www.cengage.com. The Access

data files for this book include three Access 2003 databases (Premiere Products.mdb,

Henry Books.mdb, and Alexamara Marina Group.mdb), which you can open in Access

2000, 2002, or 2003; and three Access 2007 databases (Premiere Products.accdb, Henry

Books.accdb, and Alexamara Marina Group.accdb), which you can open in Access 2007.

The data files also include script files for Oracle and SQL Server that you can use to

create or drop the Premiere Products, Henry Books, and Alexamara Marina Group

databases.

The script files saved in the Oracle folder have the following functions:

Oracle-Alexamara.sql: Creates all the tables in the Alexamara Marina Group database 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 Oracle-DropAlexamara.sql script prior

to running the Oracle-Alexamara.sql script.)

Oracle-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 Oracle-DropHenry.sql script prior to running the

Oracle-Henry.sql script.)

Oracle-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 Oracle-DropPremiere.sql script prior to

running the Oracle-Premiere.sql script.)

Oracle-DropAlexamara.sql: Drops (deletes) all the tables and data in the Alexamara

Marina Group database.

Oracle-DropHenry.sql: Drops (deletes) all the tables and data in the Henry Books

database.

Preface xv

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

剩余327页未读，继续阅读

qq_40573152

粉丝: 0
资源: 1

SQL指南（第八版）：详解数据库语句与概念

《computer networking a top-down approach(8th edition)》

computer networking top-down approach 8th edition pdf

calculus-early transcendentals 8th edition james stewart pdf

software engineer 8th edition pdf

多元回归模型的参考文献

discrete mathematics and its applications, 8th edition

systems analysis and design, 8th edition, dennis, wixom, roth, wiley

P0口的2个扩展口作为段控口和位控口，通过使用P2.6和P2.7对SN74HC573芯片的使能。P3.2（INT0）作为按钮输入口构成一个“0#～#7”的8个按钮和8个LED的显示按钮电路，系统复位时，显示“HELLO-- ”。请写出基于at89c51的汇编代码

formel-q new 8th 试卷

请给出C语言学习的书籍，同时列出书的链接。

023-05-31 16:14:46.672 ERROR 27104 --- [eate-1159694255] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://rm-bp143516c39alb8th0o.mysql.rds.aliyuncs.com:3306/sys_db, errorCode 0, state 08S01怎么理解

find a part-time job

8th多项式拟合法MATLAB算法

fluid mechanics-frank m white solution 8th

计算机网络自顶向下pdf

能在zotero软件里用的样式代码

三次谐波注入PWM参考文献

计算机网络第八版电子版

最新资源