Microsoft SQL Server 2008 Bible

Chapter 1: SQL and Relational Database Management Systems (RDBMS)

Figure 1-1: Hierarchical structure

Figure 1-2: Hierarchical database example

Figure 1-3: Network database example

Figure 1-4: Multiple columns to resolve multiple addresses for CUSTOMER

Figure 1-5: Multiple records to resolve multiple addresses for CUSTOMER

Figure 1-6: Primary/Foreign Key relationship between tables

Figure 1-7: Resolving the multiple customer addresses problem within relational model

Chapter 3: SQL Data Types

Figure 3-1: Fixed-length character string storage

Figure 3-2: Varying-length character string storage

Figure 3-3: Fixed-length Unicode character storage

Figure 3-4: Varying-length Unicode character storage

Figure 3-5: Table with column declared as an object type

Figure 3-6: Nested tables in Oracle

Chapter 4: Creating RDBMS Objects

Figure 4-1: Mary's rows in the TMP_CUSTOMER_ORDER_TOTALS temporary table

Figure 4-2: Susan's rows in the TMP_CUSTOMER_ORDER_TOTALS temporary table

Figure 4-3: Kyle's rows in the TMP_CUSTOMER_ORDER_TOTALS temporary table

Figure 4-4: Index use

Figure 4-5: B-Tree example

Figure 4-6: Database organization in Oracle

Figure 4-7: Database organization in MS SQL Server

Figure 4-8: Relationship between tablespace and datafile (one-to-many).

Figure 4-9: Using sequence-generated numbers to populate primary keys in multiple tables

Chapter 6: Data Manipulation Language (DML)

Figure 6-1: Using data from other table as an assignment value

Figure 6-2: Updating multiple rows using correlated subquery

Figure 6-3: Deleting from table referenced by ON DELETE CASCADE constraints

Figure 6-4: Deleting from table referenced by ON DELETE SET NULL constraints

Chapter 9: Multitable Queries

Figure 9-1: Simple inner join

Figure 9-2: Primary/foreign key nonequijoin

Figure 9-3: The contents of DISCOUNT table

Figure 9-4: Self-join

Figure 9-5: Four tables join

Chapter 16: SQL API

Figure 16-1: Microsoft ODBC Driver Manager console

Figure 16-2: ODBC drivers selection

Figure 16-3: IBM DB2 UDB ODBC driver configuration

Figure 16-4: New user DSN entry IBM DB2 UDB

Figure 16-5: illustrates generic RDBMS access using JDBS drivers.

Figure 16-6: Accessing IBM DB2 UDB through CLI

Figure 16-7: Connecting to Microsoft SQL Server 2000 through OLEDB

Figure 16-8: Results of the database C# program

Appendix B: The ACME Sample Database

Figure B-1: ACME database schema

Appendix D: Installing RDBMS Software

Figure D-1: Oracle 9i Autorun window

Figure D-2: Oracle Welcome window

Figure D-3: Oracle File Locations window

Figure D-4: Oracle Database Identification window

Figure D-5: Oracle Database Character Set window

Figure D-6: Oracle Summary window

Figure D-7: Oracle Install window / Disk Location pop-up screen

Figure D-8: Oracle Configuration Tools and Database Configuration assistant windows

Figure D-9: Oracle Change passwords for system users on the Database Configuration assistant window

Figure D-10: Oracle Windows Services window

Figure D-11: Removing Oracle software with the Inventory window

Figure D-12: Oracle Administration Assistant for Windows NT

Figure D-13: DB2 UDB 8.1 Installation window

Figure D-14: DB2 UDB 8.1 Products selection screen

Figure D-15: DB2 UDB 8.1 Setup wizard screen

Figure D-16: DB2 UDB 8.1 Select installation folder screen

Figure D-17: DB2 UDB 8.1 Start copying files screen

Figure D-18: DB2 UDB 8.1 Creating database using Control Center window

Figure D-19: DB2 UDB 8.1 Creating ACME database in using Database Wizard

Figure D-20: This MS SQL 2000 installation window allows you to choose the destination computer name.

Figure D-21: MS SQL 2000 Installation Selection window

Figure D-22: MS SQL 2000 Installation Definition screen

Figure D-23: MS SQL 2000 Setup Type screen

Figure D-24: MS SQL 2000 Services Accounts screen

Figure D-25: MS SQL 2000 Authentication Mode screen

Figure D-26: MS SQL 2000 Server Service Manager

Appendix E: Accessing RDBMS

Figure E-1: SQL*Plus command-line interface started from MS-DOS

Figure E-2: Executing SQL commands from SQL*Plus

Figure E-3: SQL*Plus Worksheet window

Figure E-4: OSQL session window

Figure E-5: MS SQL Server Query Analyzer dialog box

Figure E-6: Executing SQL commands using Query Analyzer

Appendix L: A Brief Introduction to the Number Systems, Boolean Algebra, and Set Theory

Figure L-1: Set union

Figure L-2: Set intersection

Figure L-3: Set difference

Figure L-4: Cartesian product