Have one to sell? Sell yours here
Relational Database Principles
  
Tell the Publisher!
I’d like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Relational Database Principles [Paperback]

C. Ritchie
3.9 out of 5 stars  See all reviews (9 customer reviews)

Available from these sellers.


Formats

Amazon Price New from Used from
Paperback --  
Paperback, 1 Feb 2001 --  
Amazon.co.uk Trade-In Store
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details.

Customers Who Bought This Item Also Bought


Product details

  • Paperback: 294 pages
  • Publisher: Cengage Learning EMEA (1 Feb 2001)
  • Language English
  • ISBN-10: 0826454224
  • ISBN-13: 978-0826454225
  • Product Dimensions: 24.1 x 17.1 x 1.9 cm
  • Average Customer Review: 3.9 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon Bestsellers Rank: 1,771,258 in Books (See Top 100 in Books)

More About the Author

C. Ritchie
Discover books, learn about writers, and more.

Visit Amazon's C. Ritchie Page

Product Description

Product Description

This is an introduction to the practice and principles of relational databases, with emphasis on data modelling and acknowledgement of the importance of Structured Query Language.

Tag this product

 (What's this?)
Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items.
Your tags: Add your first tag
 

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

Most Helpful Customer Reviews
7 of 8 people found the following review helpful
Database miseducation 20 Jun 2007
Format:Paperback
I must disagree with the other reviewers. I find the book a terrible book that is full of mistakes and misunderstood concepts.

The author confuses the 3-level architecture by writing when referring to the 3-level architecture (page 21) "On this basis, the relational model can be seen as a conceptual model". This is complete and utter rubbish, a good relational product will model all 3 levels of the 3-level architecture.

There are significant mistakes in just about every chapter. But probably the worst is chapter 5 - Normalisation. Most of the mistakes arise from a poor definition for first normal form. In the book we have the following
"The first normal form is concerned with multi-valued attributes of design (page 78)". I am not quite sure what this is supposed to mean, as it is far from clear. I would prefer something that is more precise like that given by database authorities such as Chris Date. That is, a relation is in first normal form if and only if all attributes are atomic (Single-valued). In other words, provided each attribute in any given row has a single value you have first normal form. In fact this is an essential property of any table - that is all tables are in 1NF by definition. The author attemps to normalize the data without using functional dependencies, which are barely mentioned. Instead he prefers to partition the tables by inspection, in some cases obtaining the wrong result. I have in the past used his exercises with some of my students, but have done it correctly using functional dependencies.

Not a book that I could possibly recommend. There are now many good books available for all types of student, so why waste money and time on this book. If you want a slim book that is easy to read, I would recommend:

1. The essence of databases. F.D. Rolland. Prentice Hall
Comment | 
Was this review helpful to you?
7 of 9 people found the following review helpful
By A Customer
Format:Paperback
The book is illogically organised in that you have to keep forward referencing to find out the meaning of terminology introduced previously.

The content of the book is extremely poor in places, because of the omissions and also the porr and often incorrect explanations. For instance the 3 level database architecture is mentioned briefly, but at no time is it stated that the putpose of such an architecture is to achieve data independence, and how this can be achieved. Then in the context of this model it is stated that the relational model can be seen as a conceptual model.

The definitions of the normal forms are extremely poor - possibly worse than those stated in 'A' level computing texts. Taking the definition for first normal form - "The first normal form is concerned with multi-valued attributes of design", the book takes this to mean any redundant data, rather than a repeating group with any one row and column. This ambiguity is then exploited to justify the need to partition a table without any reference to functional dependencies.

The book also includes what I consider to be irrelevant topics. Why bother mentioning the dBASE language as it is neither relational nor used. It also includes two and a half pages about VBA, which is described as a 4GL on the basis that it can be used to directly access a database.

To sum up - This is a rather poor text book on database. Possibly the worst that I have read in years. It is a pity as there are no good textbooks which are accessible to the average HNC and HND students. I have advised my students that if they are going to borrow this book from the library, they should use it with caution.

Comment | 
Was this review helpful to you?
9 of 16 people found the following review helpful
Format:Paperback
I've found this book to be particularly useful for people taking undergraduate courses in computing or database analysis and design.

It introduces the concept of relational databases and presents the reader with easy to follow examples. Each chapter of the book has exercises for the reader, to test their understanding of the covered items.

Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Listmania!

Create a Listmania! list

Look for similar items by category


Look for similar items by subject


Feedback