لطفا منتظر باشید ...
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
