List of Figures

List of Figures

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