Skip to main content Site map

Inside Relational Databases with Examples in Access (PDF eBook) New edition


Inside Relational Databases with Examples in Access (PDF eBook) New edition

eBook by Whitehorn, Mark/Marklyn, Bill

Inside Relational Databases with Examples in Access (PDF eBook)

£34.99

ISBN:
9781846286872
Publication Date:
06 Apr 2007
Edition:
New edition
Publisher:
Springer Nature
Imprint:
Springer
Pages:
372 pages
Format:
eBook
For delivery:
Download available
Inside Relational Databases with Examples in Access (PDF eBook)

Description

Contents Should we tell you the whole story? Of course, there is an inevitable tension in trying to work like this. For example, in Chapter 16 we talk about referential integrity. There are - sentially six different flavors of referential integrity but Access only s- ports four of them (they are the most important ones however, so you arent missing out on too much). The problem is this. Should we tell you about the other two? If we do, as an Access user you have every right to be annoyed that we are telling you about a feature you cant use. On the other hand, the six different types that we describe are part of the re- tional world and this book is about that world we are not trying to teach you how to use Access, we are simply using Access to illustrate the relational model. Ultimately we decided to risk your ire and to describe all of the features of the relational model as we see it, even if Access doesnt support all of them. One advantage of this approach is that if you need to use a different database engine you will almost certainly find the extra information useful. Incidentally, this is not meant to imply that Access is somehow lacking as a relational database engine. The reason we chose it for the first book is that it is such a good example of a relational database tool.

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.

Accessing your eBook through Kortext

Once purchased, you can view your eBook through the Kortext app, available to download for Windows, Android and iOS devices. Once you have downloaded the app, your eBook will be available on your Kortext digital bookshelf and can even be downloaded to view offline anytime, anywhere, helping you learn without limits.

In addition, you'll have access to Kortext's smart study tools including highlighting, notetaking, copy and paste, and easy reference export.

To download the Kortext app, head to your device's app store or visit https://app.kortext.com to sign up and read through your browser.

This is a Kortext title - click here to find out more This is a Kortext title - click here to find out more

NB: eBook is only available for a single-user licence (i.e. not for multiple / networked users).

Back

University of Sunderland logo