+612 9045 4394
Inside Relational Databases with Examples in Access - Mark Whitehorn

Inside Relational Databases with Examples in Access

Paperback Published: 31st October 2006
ISBN: 9781846283949
Number Of Pages: 372

Share This Book:


RRP $100.00
Ships in 7 to 10 business days

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 aren't 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 can't 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 doesn't 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.

Prefacep. xiii
Introductionp. 1
Who are we?p. 1
What is a database?p. 2
Databases vs. Database Management Systemsp. 3
Relational Database Management Systemsp. 3
Why this book?p. 4
Who should read this book?p. 5
Organization of the bookp. 6
Some ground rulesp. 7
Downloading files from the websitep. 8
Acknowledgementsp. 8
We don't have problems...p. 9
Outroductionp. 9
A simple, single-table databasep. 11
Introduction to Part 1p. 13
Tablesp. 13
Queries/Viewsp. 14
Formsp. 14
Reportsp. 15
Tablesp. 17
Rows & columns - records & fieldsp. 18
Building a tablep. 22
Types of datap. 23
Meaningful operationsp. 24
Excluding certain errorsp. 26
Making storage more efficientp. 26
Making data recall more rapidp. 28
Field sizep. 28
General notes on table designp. 29
Queries/Viewsp. 36
Queries usually find subsets of the datap. 36
Queries, answer tables and base tables finally defined properly and closure mentioned brieflyp. 37
Summarizing datap. 42
Other useful queriesp. 42
Graphical querying toolsp. 43
SQL and Viewsp. 44
Formsp. 45
Multiple forms per tablep. 48
Text boxes can be made read onlyp. 49
Text boxes don't have to present data from just one fieldp. 49
It isn't necessary for each field in a table to appear on the formp. 51
Controlling data entryp. 51
Use of forms can be controlledp. 51
Forms can be web pagesp. 51
Summaryp. 52
Reportsp. 54
Summary of Part 1p. 56
A multi-table databasep. 59
Introduction to Part 2p. 61
Serious problems with single tablesp. 62
Redundant datap. 63
Typographical errorsp. 63
Modifying datap. 64
Summaryp. 65
Multiple tables cure serious problemsp. 67
Redundant datap. 69
Typographical errorsp. 72
Modifying datap. 72
Making multiple tables work togetherp. 73
Databases are designed to model the real worldp. 74
Getting the data into the correct tablesp. 75
Not normalization (and not ER modeling either)p. 77
Object identificationp. 78
Relationships in the real worldp. 81
One-to-manyp. 81
One-to-onep. 82
Many-to-manyp. 82
Nonep. 82
Mapping real world relationships to tablesp. 83
How are relationships modeled?p. 84
Primary keysp. 86
Foreign keysp. 91
Summary so farp. 92
Joinsp. 93
General lessons about joinsp. 106
Revisiting the big four - the synergy beginsp. 112
Closurep. 112
Tablesp. 115
Queries (and a bit on forms)p. 116
Formsp. 123
Reportsp. 124
Integrityp. 127
Data integrity - is it worth the effort?p. 127
Types of data integrity error (and some cures)p. 128
Declarative and procedural referential integrityp. 134
Nulls in foreign keysp. 139
These options in contextp. 142
Other integrity issuesp. 143
Integrity - where should you set it?p. 143
Summary of Part 2p. 146
Database Design & Architecturep. 147
Database designp. 149
Designing databases - user, logical and physical modelsp. 149
The Logical model - overviewp. 151
More about the logical modelp. 152
CASE toolsp. 154
Summary so farp. 158
The final big advantage of CASE toolsp. 158
More about the differences between the Logical and Physical modelsp. 160
Reality checkp. 162
Normalization can helpp. 162
Reverse engineeringp. 163
Methodologiesp. 164
Summary of design modelsp. 164
The seven layers of wisdomp. 165
The seven layers of wisdomp. 165
Database architecturep. 168
Default Architecture in Accessp. 168
Access - PC front end - data on file serverp. 168
Client-server (or two-tier) architecturep. 171
Three-tier architecture (also known as multi-tier)p. 173
Web-based applicationsp. 174
Choosing a database architecturep. 176
What comes nextp. 177
Related database topicsp. 179
What exactly is a relational database?p. 181
Do multiple tables a relational database make?p. 181
Triggers and stored proceduresp. 183
Triggersp. 183
Stored proceduresp. 187
Summary - triggers and stored proceduresp. 189
Transactions, logs, backup, locking and concurrencyp. 190
Transactionsp. 190
Logsp. 191
Lockingp. 197
Concurrencyp. 199
Row locking and page lockingp. 199
Access and the features described in this chapterp. 200
Answers from earlierp. 200
Codd's rulesp. 201
Codd's rulesp. 201
Economy vs. readabilityp. 201
A little backgroundp. 202
The rules themselvesp. 202
Summaryp. 213
Normalizationp. 215
A first look at normalizationp. 215
First normal form (first level of normalization): 1NFp. 216
Second normal form (second level of normalization): 2NFp. 218
Third normal form (third level of normalization): 3NFp. 220
Summary so farp. 221
Adding some definitionsp. 222
Summary (again)p. 231
More about normalizationp. 233
Higher normal formsp. 233
Normalization doesn't automatically remove all redundancyp. 237
Summaryp. 242
The system tablesp. 244
More on queries: data manipulationp. 246
Relational operatorsp. 246
Summaryp. 256
SQLp. 258
SELECT and FROMp. 261
WHEREp. 262
Conditionsp. 263
ORDER BYp. 267
Wildcardsp. 270
Sub-queriesp. 271
Built-in functionsp. 272
GROUP BY - collecting informationp. 276
GROUP BY...HAVING - collecting specific informationp. 282
Working with multiple tablesp. 285
Inner (Natural) joinsp. 290
Outer joinsp. 291
UNIONp. 293
SELECT summaryp. 296
INSERTp. 297
UPDATEp. 300
DELETEp. 302
A question (and a free SQL diagnostic tool)p. 303
Summaryp. 306
Domainsp. 307
What does null mean?p. 309
Primary keysp. 313
Candidate keysp. 315
Speeding up your databasep. 317
Hardware considerationsp. 319
CPUsp. 320
Memoryp. 320
Disksp. 322
Data volume vs. disk capacityp. 322
Don't put all your eggs in one basketp. 323
Indexingp. 324
Indexing techniquesp. 324
Applying indexes - which fields/columns should be indexed?p. 333
Intelligent use of indexesp. 337
More on optimizationp. 338
Query optimizationp. 338
Update statisticsp. 339
Query analysisp. 340
Writing good SQL codep. 342
Denormalizationp. 344
Mirroring tablesp. 345
Splitting tablesp. 346
Redundant datap. 348
Repeating groups (breaking 1NF)p. 349
Derived columnsp. 351
Summaryp. 352
GUIs, macros and control languagesp. 353
Creating a very simple user interfacep. 353
Other languages - SQLp. 362
Indexp. 365
Table of Contents provided by Ingram. All Rights Reserved.

ISBN: 9781846283949
ISBN-10: 1846283949
Audience: General
Format: Paperback
Language: English
Number Of Pages: 372
Published: 31st October 2006
Publisher: Springer London Ltd
Country of Publication: GB
Dimensions (cm): 23.47 x 18.14  x 2.41
Weight (kg): 0.75
Edition Type: New edition