- 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 Bestsellers Rank:
144,237 in Books (See Top 100 in Books)
- #43 in Books > Computers & Internet > Computer Science > Databases > Database Design & Theory
- See Complete Table of Contents
| ||||||||||||||||||
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Amazon.co.uk Trade-In Store for more details. |
|
There is a newer edition of this item:
|
Product details |
More About the Author
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".
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
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
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
6 of 7 people found the following review helpful:
1.0 out of 5 stars
Database miseducation,
By
This review is from: Relational Database Principles (Computing Textbooks) (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
7 of 9 people found the following review helpful:
1.0 out of 5 stars
Book doesn't deliver the goods,
By A Customer
This review is from: Relational Database Principles (Computing Textbooks) (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.
9 of 16 people found the following review helpful:
5.0 out of 5 stars
Particularly useful book for undergraduate computing courses,
By pwatson_uk@yahoo.co.uk (Barnsley, England) - See all my reviews
This review is from: Relational Database Principles (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.
Share your thoughts with other customers: Create your own review
Would you like to see more reviews about this item?
|
Most Recent Customer Reviews |
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
