Description
Springer Inside Relational Databases by Mark Whitehorn, Bill Marklyn
The second edition of this best-seller is revised and updated. It delivers a reader-friendly explanation of the relational model and its importance to database designers and builders. Clear explanations make use of examples rather than equations, and show how an understanding of the relational model can lead to making a database faster and flexible. Topics covered include: nulls, primary and foreign keys, joins, relationships, domains, indexing, and many others. The authors manage to shed light on this tricky subject with substance and style.
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.