Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.
Read instantly on your browser with Kindle for Web.
Using your mobile phone camera - scan the code below and download the Kindle app.
An Introduction to Database Systems Subsequent Edition
There is a newer edition of this item:
- ISBN-100201385902
- ISBN-13978-0201385908
- EditionSubsequent
- PublisherAddison-Wesley
- Publication dateJanuary 1, 2000
- LanguageEnglish
- Dimensions10 x 1.5 x 8.25 inches
- Print length938 pages
Popular titles by this author
The New Relational Database Dictionary: Terms, Concepts, and ExamplesChris DatePaperback$10.53 shippingOnly 2 left in stock (more on the way).
Introduction to Database Systems, AnPaperback$22.82 shippingGet it as soon as Thursday, Jul 18Only 1 left in stock - order soon.
SQL and Relational Theory: How to Write Accurate SQL CodeChris DatePaperback$12.77 shippingOnly 10 left in stock (more on the way).
Relational Theory for Computer Professionals: What Relational Databases Are Really All AboutChris DatePaperback$10.92 shipping
Editorial Reviews
Amazon.com Review
This is an extraordinarily academic book. In his preface, C.J. Date goes so far as to lament having to use Structured Query Language (SQL) in some of his examples because it's "so far from being a true embodiment of relational principles." What's more, he writes in a very academic style, peppering his heavily footnoted prose with mathematical expressions and words like relevar and tuple. The academic style and highbrow language isn't a bad thing, since this book deals with complicated, largely abstract phenomena in depth.
Be aware that An Introduction to Database Systems is a far cry from the highly graphical, problem-focused books that target the community of commercial database developers, and as such requires more careful study. This book is about theories, concepts, and ideals rather than problems, solutions, and specific implementations. Per se, it will enable you to become a better database programmer--but only if you supplement it with practical guides and hands-on experience. --David Wall
From the Back Cover
The material is organized into six major parts. Part I provides a broad introduction to the concepts of database systems in general and relational systems in particular. Part II consists of a careful description of the relational model, which is the theoretical foundation for the database field as a whole. Part III discusses the general theory of database design. Part IV is concerned with transaction management. Part V shows how relational concepts are relevant to a variety of further aspects of database technologysecurity, distributed databases, temporal data, decision support, and so on. Finally, Part VI describes the impact of object technology on database systems.
This Seventh Edition of An Introduction to Database Systems features widely rewritten material to improve and amplify treatment of several topics, including:
Revised and expanded material on the relational model, particularly the sections on types (domains), relation values vs. relation variables, integrity, predicates, and views
New material on relation-valued attributes, denormalization, orthogonal design, and alternative approaches to semantic modeling (including "business rules")
Complete new chapters covering type inheritance, decision support, and temporal databases
Two new appendixes, one on detail of SQL and one on SQL3
Readers of this book will gain a strong working knowledge of the overall structure, concepts, and objectives of database systems and will become familiar with the theoretical principles
underlying the construction of such systems.
Product details
- Publisher : Addison-Wesley; Subsequent edition (January 1, 2000)
- Language : English
- Hardcover : 938 pages
- ISBN-10 : 0201385902
- ISBN-13 : 978-0201385908
- Item Weight : 3.69 pounds
- Dimensions : 10 x 1.5 x 8.25 inches
- Best Sellers Rank: #2,647,061 in Books (See Top 100 in Books)
- #785 in Database Storage & Design
- #5,273 in Databases & Big Data
- #27,964 in Mathematics (Books)
- Customer Reviews:
About the author

Discover more of the author’s books, see similar authors, read author blogs and more
Customer reviews
Customer Reviews, including Product Star Ratings help customers to learn more about the product and decide whether it is the right product for them.
To calculate the overall star rating and percentage breakdown by star, we don’t use a simple average. Instead, our system considers things like how recent a review is and if the reviewer bought the item on Amazon. It also analyzed reviews to verify trustworthiness.
Learn more how customers reviews work on Amazon-
Top reviews
Top reviews from the United States
There was a problem filtering reviews right now. Please try again later.
If you wish to quickly jump into database design without a full and rigorous knowledge of database theory (by no means a bad thing) then this book is not for you. If, however, you want a thorough grounding in the principles and practice of database theory considered from an academic standpoint, then this book is highly recommended.
Date is one of the giant figures of relational database theory, and this masterful work covers, in exhaustive detail, all the elementary principles of the subject. The book commences with an overview of database systems and management, before moving on to introduce the relational model. Part II of the book covers in great detail the relational model, introducing the relational algebra and the relational calculus (and then showing the formal equivalence of the two). The SQL language is introduced.
Part III discusses database design, with special emphasis on the vital topics of nonloss decomposition, functional dependencies and normalisation. For practical database designers this is perhaps the most valuable part of the book. Part IV covers data protection from the standpoints of integrity and implementation in practical systems.
Part V gathers a miscellany of related topics such as optimization of queries, a discussion of the 'NULL' problem and an introduction to ditributed (i.e. client/server) database systems. Part VI is an introduction to object-oriented database systems, with an examination of the problems faced by traditional relational systems when faced with object-oriented problems.
It is important to note the target audience for this book. This book is first and foremost academic by nature. Rigour is not sacrificed for conciseness or simplicity. It is textually dense, especially parts II and III (far and away the most important parts). The reader will have to put in a lot of work to fully grasp the details of the concepts. For example, Date's definition of third normal form (3NF): "A relation is in 3NF if and only if it is in 2NF and every nonkey attribute is nontransitively dependent on the primary key". To appreciate in detail the significance of this definition requires substantial effort. However, this effort will pay dividends when the time comes to actually design a real-world system. Failure to understand the principles of database theory at this level of rigour lies behind many failed implementation attempts. Not every database designer needs this knowledge, but a manager of a large database project certainly does. I would not recommend this book as an introductory text for an undergraduate course in database design, due to the large quantity of material covered and its highly theoretical exposition. I would, however, strongly recommend it for students at a higher level, professional database designers and implementors of database management systems.
The details are great and some are so striking as to seem profound. How many people know that there are relations that have no attributes? Date also apologies for past misconceptions. It is gratifying to know that he now agrees with what some suspected - an relation attribute's value can be another relation, if we want it to be. The book is full of wisdom like that.
Just like the author, I wish the builders of so-called relational systems would pay some attention to this thinking (which he freely admits is not all his own). Then they might spend less time refining ideas which the reader of this book will realize are clearly wrong, like not separating the physical from the logical. If they also read his 'Third Manifesto', co-authored with Hugh Darwen where his personal opinions shine through even more, they might see ways to simplify further as well as apply the ideas in new and useful ways and take databases to a new level.
This book is not for anybody who only wants a 24 hour, or even a 21 day, treatment, although those are OK as far as they go. It is for anybody who is interested in the field, but perhaps not for some who only want a job. But i think this book has to be read to understand why!
I would pay more for an even longer book with more detail on some of the early papers by others such as those about normalization. These papers are now very hard to obtain.
The best book i've read on database (perhaps i should say relations and THEIR foundations) was Introduction to Mathematical Philosophy by Bertrand Russell, written in 1917 no less! It also bears re-reading.
Top reviews from other countries
The book taught me a great deal about databases, the relational model, SQL (and its flaws). The book also taught me about computer science subjects such as security, optimisation, type inheritance (classes, object-oriented inheritance).

