Inside Relational Databases (Paperback, 2nd ed. 2001)

Introduction.- Part 1. A Simple, Single-Table Database: Introduction. Tables. Forms. Queries. Reports. Summary.- Part 2. A Multi-Table, Single-User Database: Introduction. Serious Problems with Single Tables. Multiple Tables Cure Serious Problems. Making Multiple Tables Work Together. Getting the Data into the Correct Tables. Relationships in the Real World. How are Relationships Modeled? Revisiting the Big Four - The Synergy Begins. Integrity. Building a Database Application. Summary.- Part 3. Multi-Table Multi-User Databases: Database Architectures. More Complex Database Design. Triggers, Stored Procedures and Views. Transactions, Logs, Bakckup, Locking and Concurrency.- Part 4. Related Database Topics: What Exactly is a Relational Database? Codd's Rules. Normalization. The Data Dictionary. More on Queries: Data Manipulation. Domains. Indexing - Speeding Up Your Database. What Does Null Mean? Primary Keys. Glossary.