Articoli correlati a INSIDE RELATIONAL DATABASES.: With examples in Access,...

INSIDE RELATIONAL DATABASES.: With examples in Access, avec CD-ROM, édition en anglais - Brossura

Whitehorn, Mark; Marklyn, Bill

 
9783540760924: INSIDE RELATIONAL DATABASES.: With examples in Access, avec CD-ROM, édition en anglais

Sinossi

Database books currently tend to fall into two categories: highly theoretical and detailed textbooks and manuals which teach how to use the software but not the underlying theory. Neither type of book explains why the reader would want to do many of the things they describe. Marklyn and Whitehorn cover essential relational database theory and explain how to build databases securely - without bogging them down into too much detail and endless formulae. They start by explaining interface components and letting you build working databases. Along the way the authors guide you through potential disasters and provide the techniques to avoid them. Inside Relational Databases is aimed at equipping students with the necessary skills to build practical databases in the 'real world' as well as ensuring that they have a sufficient theoretical grounding in the subject.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

Contenuti

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 Description

Rare Book

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.