Inside Relational Databases

The second edition of the best-selling Inside Relational Databases is revised and updated to bring you the most reader-friendly explanation of the relational model and its importance to database designers and builders. Clear explanations make use of examples rather than equations to show you how an understanding of the relational model can make your databases faster, more flexible and thoroughly fit for their purpose. Dr Mark Whitehorn has an extensive understanding of relational database theory and his popular and long running database column in the UK's "Personal Computer World" has already made database theory accessible to thousands. Bill Marklyn has an intimate knowledge of relational databases and was the Development Manager who oversaw the entire design of the first two major releases of Microsoft's highly successful database product, Access. Together they make a great team, illuminating a tricky subject with substance and style. Reviews from the first edition of Inside Relational Databases: "Quite simply - superb. By making relational databases understandable, Mark Whitehorn and Bill Marklyn have achieved far more than most. Making the subject interesting and entertaining as well puts these two authors firmly in a class of their own." - Neil Fawcett, Group Technical Editor, VNU Business Publications "PCW and Amazon.co.uk contributor Mark Whitehorn is that rare combination - an expert in his field, databases, and a fine writer too, with a talent for honing a complex subject down to its essentials." - Tamsin Todd, Computer & Internet Editor, Amazon.co.uk "Inside Relational Databases is excellent. It is clearly and concisely written and full of humorous asides which ease the reader through an otherwise weighty topic. Probably the most engaging technical book I have read." - Paul McGowan Cd-rom Includes: Access 2000 Or 97 For Chapters 2-10, 12, 14a-c,15-17, 25, 27, 28a-b, 31. Ch. 1. Introduction -- Pt. 1. A Simple, Single-table Database -- Ch. 2. Introduction To Part 1 -- Ch. 3. Tables -- Ch. 4. Forms -- Ch. 5. Queries -- Ch. 6. Reports -- Ch. 7. Summary Of Part 1 -- Pt. 2. A Multi-table, Single-user Database -- Ch. 8. Introduction To Part 2 -- Ch. 9. Serious Problems With Single Tables -- Ch. 10. Multiple Tables Cure Serious Problems -- Ch. 11. Making Multiple Tables Work Together -- Ch. 12. Getting The Data Into The Correct Tables -- Ch. 13. Relationships In The Real World -- Ch. 14. How Are Relationships Modeled? -- Ch. 15. Revisiting The Big Four -- The Synergy Begins -- Ch. 16. Integrity -- Ch. 17. Building A Database Application -- Ch. 18. Summary Of Part 2 -- Pt. 3. Multi-table, Multi-user Databases -- Ch. 19. Database Architectures -- Ch. 20. More Complex Database Design -- Ch. 21. Triggers, Stored Procedures And Views -- Ch. 22. Transactions, Logs, Backup, Locking And Concurrency -- Pt. 4. Related Database Topics -- Ch. 23. What Exactly Is A Relational Database? -- Ch. 24. Codd's Rules -- Ch. 25. Normalization -- Ch. 26. The Data Dictionary -- Ch. 27. More On Queries: Data Manipulation -- Ch. 28. Sql -- Ch. 29. Domains -- Ch. 30. Indexing -- Speeding Up Your Database -- Ch. 31. What Does Null Mean? -- Ch. 32. Primary Keys. Mark Whitehorn And Bill Marklyn. Includes Index. System Requirements For Accompanying Computer Disc: Windows Explorer. 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. Discusses the theory behind relational database development and explains how to build a working database, covering topics including Codd's rules, normalization, and data manipulation.