Marklyn and Whitehorn cover essential relational database theory and explain how to build databases securely - seeking to do this without bagging the reader down with too much detail and endless formulae. They start by explaining interface components and letting the reader build working databases. Along the way the authors guide the reader through potential disasters and provide the techniques to avoid them. The text seeks to bridge the gap between theoretical database books and manuals.
Introduction.- A simple, single-table database.- Introduction to section 1.- Tables.- Forms.- Queries.- Reports.- Summary of section 1.- A multi-table, single-user database.- Introduction to section 2.- Bad news! single tables often cause serious problems.- Good news! - multiple tables cure serious problems!- What do you need to make multiple tables work together?- Getting the right data into the correct tables.- Relationships in the real world.- How are relationships modelled?- Revisiting the big four.- Integrity.- Building a database application - GUIs, macros and control languages.- Summary of section 2.- Section 3 - Multi-table multi-user databases.- What exactly is a relational database?- Codd's rules.- Getting the right data into the right tables - normalisation.- Keeping track of everything (the data dictionary).- More on queries (data manipulation).- SQL.- Domains.- Speeding up your database.- What does null mean?- Primary keys - scope and problems finding truly global ones.- Glossary (a 'bluffer's guide' to database terminology).