See buying choices for this item to see if it's one of the millions that are eligible for Amazon Prime.

Ready to Buy?
woodys-uk
Price: £66.17
In stock

16 used & new from £7.99

Have one to sell? Sell yours here
 
   
Relational Database Principles
 
 

Relational Database Principles (Paperback)

by C. Ritchie (Author) "Most computer applications require a means of holding persistent data; i.e., data that preserves its value between successive invocations of the software that produces it..." (more)
3.9 out of 5 stars See all reviews (9 customer reviews)

Available from these sellers.


4 new from £16.00 12 used from £7.99
Other Editions: RRP: Our Price: Other Offers:
Paperback 11 used & new from £0.22

Customers Who Bought This Item Also Bought

Databases (Computing Study Texts)

Databases (Computing Study Texts)

by R L Warrender
5.0 out of 5 stars (1)  £12.00
Software Engineering: Update (International Computer Science Series)

Software Engineering: Update (International Computer Science Series)

by Ian Sommerville
3.5 out of 5 stars (6)  £45.59
Database Systems: A Practical Approach to Design, Implementation and Management (International Computer Science Series)

Database Systems: A Practical Approach to Design, Implementation and Management (International Computer Science Series)

by Thomas Connolly
4.0 out of 5 stars (15)  £47.49
Business Information Systems: Technology, Development and Management for the E-Business

Business Information Systems: Technology, Development and Management for the E-Business

by Paul Bocij
4.7 out of 5 stars (3)  £45.59
Objects First with Java: A Practical Introduction Using BlueJ

Objects First with Java: A Practical Introduction Using BlueJ

by David J. Barnes
4.3 out of 5 stars (19)  £37.60
Explore similar items

Product details

  • Paperback: 296 pages
  • Publisher: Thomson Learning; 2nd Revised edition edition (25 April 2002)
  • Language English
  • ISBN-10: 0826457134
  • ISBN-13: 978-0826457134
  • Product Dimensions: 25.2 x 17.2 x 2 cm
  • Average Customer Review: 3.9 out of 5 stars See all reviews (9 customer reviews)
  • Amazon.co.uk Sales Rank: 327,619 in Books (See Bestsellers in Books)
  • See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
Relational Database
   InterSystems.com/Cache    Robust Object DB & High-Performance SQL Access - Download Caché Today. 
Relational Database
   www.oracle.com/uk    Consolidate all your company's data in a single, centralised database
Relational Databases
   www.gsBase.com/Software    Create Efficient Solutions With Our Software Now. Free Demo Here! 
  
 

Product Description

Product Description
This title provides an introduction to the practice and principles of relational databases. It emphasises data modelling and the consequent construction of a database and reflects the importance of Structured Query Language (SQL). It also includes: new material on web-based databases; increased coverage of the differences between Access and Oracle in SQL; new material on MySQL; case studies; and sample data on accompanying website.

About the Author
Colin Ritchie is a lecturer in Computer Studies at Glasgow Caledonian University. He has a research degree from Strathclyde University. He is the author of "Operating Systems".

Inside This Book (Learn More)
First Sentence
Most computer applications require a means of holding persistent data; i.e., data that preserves its value between successive invocations of the software that produces it and, indeed, between successive 'switch-ons' of the computer itself. Read the first page
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

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 organize and find favorite items.
Your tags: Add your first tag
 

What Do Customers Ultimately Buy After Viewing This Item?


 

Customer Reviews

9 Reviews
5 star:
 (5)
4 star:
 (2)
3 star:    (0)
2 star:    (0)
1 star:
 (2)
 
 
 
 
 
Average Customer Review
3.9 out of 5 stars (9 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
9 of 10 people found the following review helpful:
1.0 out of 5 stars Database miseducation , 20 Jun 2007
By A. J. HAWKEN "Tony Hawken" (London - UK) - See all my reviews
(REAL NAME)   
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 Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
6 of 8 people found the following review helpful:
1.0 out of 5 stars Book doesn't deliver the goods, 22 Oct 1999
By A Customer
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 Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
9 of 15 people found the following review helpful:
5.0 out of 5 stars Particularly useful book for undergraduate computing courses, 2 Mar 2001
By pwatson_uk@yahoo.co.uk (Barnsley, England) - See all my reviews
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 Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

4.0 out of 5 stars Great book
This was actually written by my University lecturer at Glasgow Caledonian, he is a good lecturer and of course he recommended his own book, so I went out and bought it, it really... Read more
Published on 2 Oct 2006 by E. C. McGregor

5.0 out of 5 stars Very essential
IF you are looking for a book that may help you to "think like a database" will, you should buy this book.
Published on 29 April 2003 by pal_car

4.0 out of 5 stars Good introduction to all aspects of databases
This readable and slim book begins with describing how to construct tables effectively, using data modellong techniques. This section for me is the best part of the book. Read more
Published on 5 Dec 2001 by richardadams20

5.0 out of 5 stars A fantastic book for beginners
The author writes in plain English and takes everything from first principles.
Not a huge book, but packed with info - which is a lot better than some of the huge tomes which... Read more
Published on 12 Oct 2001

5.0 out of 5 stars another in a great series
This again is an excelent book, ideal for 2nd years as said in another review. I have worked through one of colin ritchies' other books - "operating systems " it was... Read more
Published on 5 Feb 2001

5.0 out of 5 stars Useful introduction to database principles.
I found this a readable and useful introduction to database principles. It is the type of book I would recommend for a second year course on relational databases. Read more
Published on 23 Jun 2000 by John Carter

Only search this product's reviews



Customer Discussions

 Beta (What's this?)
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

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

   


Listmania!


Look for similar items by category


Feedback


Health & Beauty at Amazon.co.uk

Elemis Resurface and Renew Skin Care Gift Set of 4 Products
From soap to shavers, massagers to mascara, stock up on your daily essentials or truly pamper yourself.

Discover Health & Beauty

 

Let Olay Amaze You

Olay Total Effects Day Moisturiser SPF15 50ml
Amazon.co.uk sells all your favourite ranges from Olay, including Regenerist and Total Effects.

Discover Olay at Amazon.co.uk

 

Up to 50% off Dental Care

Braun Oral-B Professional Care 6000 Rechargeable Toothbrush - Pack of 2
Put a sparkle in your smile with up to 50% off selected Oral-B and Philips rechargeable toothbrushes.

Up to 50% off power toothbrushes

 

Treat Someone

Amazon.co.uk Gift Certificates--available in any amount from £5 to £500 With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is).

Learn more about Gift Certificates

 
Ad

Where's My Stuff?

Delivery and Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue Shopping: Top Sellers

amazon.co.uk Amazon Home
International Sites:  United States  |  Germany  |  France  |  Japan  |  Canada  |  China
Business Programs: Sell on Amazon  |  Fulfilment by Amazon  |  Join Associates  |  Join Advantage
Customer Service  |  Help  |  View Basket  |  Your Account
About Amazon.co.uk  |  Careers at Amazon
Conditions of Use & Sale |  Privacy Notice  © 1996-2009, Amazon.com, Inc. and its affiliates