Flylib.com
List of Figures
Previous page
Table of content
Next page
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 9
i
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
Previous page
Table of content
Next page
Microsoft SQL Server 2008 Bible
ISBN: 0470257040
EAN: 2147483647
Year: 2005
Pages: 208
Authors:
Paul Nielsen
,
Uttam Parui
BUY ON AMAZON
High-Speed Signal Propagation[c] Advanced Black Magic
DC Resistance
Pcb Configurations
Pcb Applications
UTP Transmission Example: 10BASE-T
Coaxial Cabling
The Complete Cisco VPN Configuration Guide
VPN Components
Concentrator Tools
Troubleshooting Problems
Router Site-to-Site Connections
L2L Connection Examples
Mastering Delphi 7
Building the User Interface
Client/Server with dbExpress
Multitier DataSnap Applications
Reporting with Rave
Using XML Technologies
Visual Studio Tools for Office(c) Using C# with Excel, Word, Outlook, and InfoPath
Special Excel Issues
VSTO Data Programming
A Handy Client-Side ServerDocument Utility
VSTO Support for Word Schema Mapping
Conclusion
Quantitative Methods in Project Management
Project Value: The Source of all Quantitative Measures
Introduction to Probability and Statistics for Projects
Quantitative Time Management
Special Topics in Quantitative Management
Quantitative Methods in Project Contracts
Digital Character Animation 3 (No. 3)
Mesh Deformation
Animation Interfaces
Animating with Poses
Chapter Six. Walking and Locomotion
Acting Vs. Animating
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies