Theory and Practice of Relational Databases

✍ Scribed by Stefan Stanczyk, Bob Champion, Richard Leyton

• Publisher: CRC Press
• Year: 2001
• Tongue: English
• Leaves: 254
• Edition: 2
• Category: Library

✦ Synopsis

A very nice introduction to the background of SQL. That behind it sits a database that can be constructed via a systematic set of rules that can be applied to data. All the standard normal forms are discussed, as one might expect.

You don't need to know the predicate calculus for this book. The mathematical treatment should not be difficult to those who have already had university level courses on computer science.

The book is not geared towards any vendor's implementation of SQL. Which is good. You can apply this book towards any of the major vendors' offerings.

✦ Table of Contents

Half-Title......Page 2
Title......Page 4
Copyright......Page 5
Contents......Page 7
Preface......Page 8
1. Introduction......Page 11
2. Data modelling......Page 20
3. The relational model......Page 38
4. Relational algebra......Page 60
5. LEAP-the algebraic DBMS......Page 93
6. Normalization......Page 107
7. Further normalization......Page 126
8. Structured Query Language......Page 149
9. Object databases......Page 180
10. SQL extensions......Page 196
11. Case study—implementation......Page 207
Appendix A: Solutions to exercises......Page 233
Appendix B: Denotations, logic, sets......Page 243
Bibliography......Page 247
Index......Page 250