Inside Relational Databases with Examples in AccessSpringer Science & Business Media, 2007 M04 6 - 372 pages 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. |
Contents
1 | |
A simple singletable database | 11 |
Chapter 4 QueriesViews Queries usually find subsets of the data | 36 |
Chapter 5 Forms | 45 |
Reports | 54 |
Introduction to Part 2 | 61 |
Multiple tables cure serious problems | 67 |
Making multiple tables work together | 73 |
Transactions logs backup locking | 190 |
Codds rules | 201 |
Normalization | 215 |
More about normalization | 233 |
The system tables | 244 |
Chapter 29 SQL | 258 |
What does null mean? | 309 |
Speeding up your database | 317 |
Other editions - View all
Inside Relational Databases with Examples in Access Mark Whitehorn,Bill Marklyn No preview available - 2006 |
Common terms and phrases
Access Amount FROM SALES answer table application base tables Bentley Mk Bilda Groves CARS Cascade Chapter client clustered index Codd column Customer Item Supplier data dictionary data integrity database design database engine DateOfBirth DBMS delete denormalization disk EmployeeNo Customer Item EmployeeNo FirstName ensure example FirstName LastName foreign key functionally dependent Item Supplier Amount ItemNo John Greeves Johnson Chair Harrison join Jones Bed Ford Jones Suite Harrison Layer LicenseNo log files logical model look macro McColgan multiple null value operations ORDER/ITEMS ORDERS table performance physical model primary key primary key value problem query optimizer RDBMS RDBMSs records referential integrity relational database relational model relationship Rosanne Kolumns SaleNo EmployeeNo Customer Sally Smith Second Normal Form simply Simpson Sofa Harrison Smith Sofa Harrison Smith Stool Ford SQL statement stored Suppose third normal form tion transactions trigger Triumph Spitfire Triumph Stag update Wellington
References to this book
Managing your Patients' Data in the Neonatal and Pediatric ICU: An ... Joseph Schulman No preview available - 2006 |