Inside Relational Databases: With Examples in Access

Inside Relational Databases: With Examples in Access

By: Mark Whitehorn (author), Bill Marklyn (author)Paperback

Up to 2 WeeksUsually despatched within 2 weeks

Description

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.

Contents

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).

Product Details

  • ISBN13: 9783540760924
  • Format: Paperback
  • Number Of Pages: 252
  • ID: 9783540760924
  • weight: 490
  • ISBN10: 354076092X

Delivery Information

  • Saver Delivery: Yes
  • 1st Class Delivery: Yes
  • Courier Delivery: Yes
  • Store Delivery: Yes

Prices are for internet purchases only. Prices and availability in WHSmith Stores may vary significantly

Close