Table of Contents

01 Preface
02 The Nature of Data
03 Entities, Attributes, Values and Relationships
04 Data Structures
05 Relational Tables
06 Access Structures
07 Numeric Data
08 Character String Data
09 Logic and Databases
10 Temporal Data
11 Textual Data
12 Exotic Data
13 Missing data
14 Scales and Measurements
15 Data Encoding Schemes
16 Check Digits
17 The Basic Relational Model
18 Keys
19 Different Relational Models
20 Basic Relational Operations
21 Transactions and Concurrency Control
22 Functional Dependencies
23 Normalization
24 Denormalization
25 Metadata

Promotional Information

* Supports its extensive conceptual information with example code and other practical illustrations.
* Explains fundamental issues such as the nature of data and data modeling, and moves to more specific technical questions such as scales, measurements, and encoding.
* Offers fresh, engaging approaches to basic and not-so-basic issues of database programming, including data entities, relationships and values, data structures, set operations, numeric data, character string data, logical data and operations, and missing data among others.
* Covers the conceptual foundations of modern RDBMS technology, making it an ideal choice for students.

About the Author

Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas. He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.