Inside Relational Databases with Examples in Access

• Main Authors: Whitehorn, Mark (Author), Marklyn, Bill (Author)
• Corporate Author: SpringerLink (Online service)
• Format: Electronic eBook
• Language: English
• Published: London : Springer London, 2007.
• Subjects: Computer science.; Computers.; Database management.; Computer Science.; Database Management.; Models and Principles.; Information Systems and Communication Service.

Inside Relational Databases was first published in 1997 and, rather to our surprise, rapidly reached the status of a classic work in the database field. Translated into three other languages and sold all over the world, it has helped thousands of people to understand the relational model that underp...

Table of Contents:

• A simple, single-table database
• to Part 1
• Tables
• Queries/Views
• Forms
• Reports
• Summary of Part 1
• A multi-table database
• to Part 2
• 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
• Summary of Part 2
• Database Design & Architecture
• Database design
• The seven layers of wisdom
• Database architecture
• Related database topics
• What exactly is a relational database?
• 22 Triggers and stored procedures
• Transactions, logs, backup, locking and concurrency
• Codd’s rules
• Normalization
• More about normalization
• The system tables
• More on queries: data manipulation
• SQL
• Domains
• What does null mean?
• Primary keys
• Speeding up your database
• Hardware considerations
• Indexing
• More on optimization
• Denormalization.