Database Design for Mere Mortals(R): A Hands-On Guide to Relational Database Design (2nd Edition)
“This book takes the somewhat daunting process of database design and breaks it into completely manageable and understandable components. Mike’s approach whilst simple is completely professional, and I can recommend this book to any novice database designer.” –Sandra Barker, Lecturer, University of South Australia, Australia “Databases are a critical infrastructure technology for information systems and today’s business. Mike Hernandez has written a literate explanation of database technology–a topic that is intricate and often obscure. If you design databases yourself, this book will educate you about pitfalls and show you what to do. If you purchase products that use a database, the book explains the technology so that you can understand what the vendor is doing and assess their products better.” –Michael Blaha, consultant and trainer, author of A Manager’s Guide to Database Technology “If you told me that Mike Hernandez could improve on the first edition of Database Design for Mere Mortals I wouldn’t have believed you, but he did! The second edition is packed with more real-world examples, detailed explanations, and even includes database-design tools on the CD-ROM! This is a must-read for anyone who is even remotely interested in relational database design, from the individual who is called upon occasionally to create a useful tool at work, to the seasoned professional who wants to brush up on the fundamentals. Simply put, if you want to do it right, read this book!” –Matt Greer, Process Control Development, The Dow Chemical Company “Mike’s approach to database design is totally common-sense based, yet he’s adhered to all the rules of good relational database design. I use Mike’s books in my starter database-design class, and I recommend his books to anyone who’s interested in learning how to design databases or how to write SQL queries.” –Michelle
Rating: (out of 127 reviews)
List Price: $ 64.99
Price: $ 36.70
Database Design for Mere Mortals(R): A Hands-On Guide to Relational Database Design (2nd Edition) Reviews
Review by Christopher S. Susi:
A few days after reading 1/2 the book I nearly wrote a review giving the book 0 stars. Truly pages 50-200 can be condensed into about 10 pages. However, the chapters about building the tables, relationships, fields attributes, business rules are very well written to give an overview for the non-technical person or somebody getting started. Also, many times books that teach a language will avoid fundamental skills such as database design and these are more important than understanding syntax (you will know if your syntax is wrong when you run the program, you wont know your design is f-ed up till 6 months into implementation). If you haven’t had database design exposure through a Comp Sci program, this is an excellent starting point. Due to it’s non-technical descriptions this is a good read if you are overseeing software/database project (project manager, manager commisioning a design house, etc.) and are not entirely computer literate.On the downside, I would have liked it if he did associate the various nomalization terms that he ends up discussing but without actually saying that is what they are (e.g. breaking apart multi-valued fields, etc). Certainly if you have seen this already and would like more detailed information then consider Teorey’s Database Modeling & Design which is more advanced.
Review by :
I was first introduced to this book in College while I was learning relational database design and modeling concepts. Almost anyone can open Access and build a database, but are they doing it correctly? Knowing how to do something and WHY you are doing it are entirely different things. This book takes complicated technical information and breaks it out into an efficient and easy to understand format that anyone from a beginner to an expert can use and understand. Not only do you finish understanding the how and the why of relational design, but you have also been exposed to the detailed process of designing for others, methods of interviewing and example questions that show you how to get the information you need from your users that’s crucial to your design. I enjoyed this book and would recommend it since the concepts are software independent. At my last job, our SQL DBA called this book his Bible. I just recently ordered it again for a friend who’s beginning to learn about databases. Two thumbs up!
Buy Database Design for Mere Mortals(R): A Hands-On Guide to Relational Database Design (2nd Edition) now for only $ 36.70!
Beginning Database Design: From Novice to Professional
Beginning Database Design: From Novice to Professional provides short, easy-to-read explanations of how to get database design right the first time. This book offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. Through the help of use cases and class diagrams modeled in the UML, youll learn how to discover and represent the details and scope of the problem in question. Database design is not an exact science, and solid database design principles and examples help demonstrate the consequences of simplifications and pragmatic decisions. The rationale is to try to keep it simple, but allow room for development as situations change or resources permit. The book also features an introduction for implementing the final design in a relational database.
Rating: (out of 20 reviews)
List Price: $ 34.99
Price: $ 21.62
Beginning Database Design: From Novice to Professional Reviews
Review by Bjorn D. Tyreus:
While having many years of object-oriented design and programming experience, until recently I had no experience in designing or implementing relational databases. I learn by reading so I picked up several of the top-rated books on the subject. I found Clare Churcher’s book to be the best by far! There are two aspects of the book I found particularly attractive. First, it is short and to the point. You can read it in a day or two and learn enough of the essentials to get started on your first database design project, I did. Second, it clearly demonstrates the relationship between object-oriented data modeling and relational database design. The latter aspect made the concepts and examples particularly easy for me to understand and I suspect it will do the same for anyone else reading this book with an object-oriented programming background. Simply a great book!
Review by K. Pate:
This book does a great job of explaining data modeling, including how it corresponds to tables in a database. The book is well-written and very organized, and the examples do a good job of illustrating the concepts. It’s also mercifully short compared to other options.
It’s appropriate for database beginners, and for experiences developers who are getting into database design for the first time. There’s a section on how this all relates to OOP, with no focus on a specific language.
The examples apply to any database systems that support standard SQL including Access and MySQL. Note that the book does not cover Access and MySQL directly — you’ll need different resources for that. For MySQL, the tutorials on the MySQL site itself are a surprisingly good place to start.
This book tells you how to think about your database *before* you begin to develop it, which can be critical if you’re designing anything even slightly complicated.
I’m developing a Ruby on Rails web app, and this book really helped me think through some issues that I had not considered until now.
Buy Beginning Database Design: From Novice to Professional now for only $ 21.62!
Beginning Database Design Solutions (Wrox Programmer to Programmer)
This book is intended for IT professionals and students who want to learn how to design, analyze, and understand databases. The material will benefit those who want a better high-level understanding of databases such as proposal managers, architects, project managers, and even customers. The material will also benefit those who will actually design, build, and work with databases such as database designers, database administrators, and programmers. In many projects, these roles overlap so the same person may be responsible for working on the proposal, managing part of the project, and designing and creating the database. This book is aimed at IT professionals and students of all experience levels. It does not assume that you have any previous experience with databases or programs that use them. It doesn’t even assume that you have experience with computers. All you really need is a willingness and desire to learn. This book explains database design. It tells how to plan a database’s structure so the database will be robust, resistant to errors, and flexible enough to accommodate a reasonable amount of future change. It explains how to discover database requirements, build data models to study data needs, and refine those models to improve the database’s effectiveness. The book solidifies these concepts by working through a detailed example that designs a realistic database. Later chapters explain how to actually build databases using two common database products: Access 2007 and MySQL. The book finishes by describing some of the topics you need to understand to keep a database running effectively such as database maintenance and security. This book explains database design.
- ISBN13: 9780470385494
- Condition: New
- Notes: BUY WITH CONFIDENCE, Over one million books sold! 98% Positive feedback. Compare our books, prices and service to the competition. 100% Satisfaction Guaranteed
Rating: (out of 9 reviews)
List Price: $ 44.99
Price: $ 25.32
Beginning Database Design Solutions (Wrox Programmer to Programmer) Reviews
Review by Leonard Ansin:
Database Design Solutions, By Rod Stephens is a book that offers “expert practical experience” to assist the reader in creating a flexible and robust database even if this is your first database. A database properly designed from the start will prove rewarding and beneficial to the users. A poorly designed database, will lead to continuing headaches and frustration for the developer and most likely lost customers.
The book is clear, well written and appeals to the readers. It covers a lot of ground in different chapters. It guides you in developing business rules, explains what normalization is and gives an overview of different types of databases such as Access, SQL and My Sql. It will direct you how to start SQL statements and query constructions.
My feeling is of all the chapters in the book, the best are Chapter 4, Understanding User Needs, Chapter 7, Normalization, Chapter 9, Common Design Patterns and Chapter 10, Common Design Pitfalls. These were the most informative that appealed to me.
No matter whether you are a beginner or an experienced Database developer, this book is a must for you. It will give you the basics to start the development correctly and if you are experienced, it gives you the support to be sure your doing existing databases correctly.
This book is a must read for anyone doing database development.
By Leonard Ansin (Waltham, MA USA)
Review by DM:
I am the director (and sole employee) of a newly formed non-profit. I came to this book with little prior programming experience, and found it to be all I was looking for as far as designing a database to meet our foundation’s needs. A real strength of the book is that the author walks you through a wealth of examples, and provides many more to think through on your own–all with answers in the back of the book. So it’s almost guaranteed there will be something which matches or parallels what you are trying to do. I read the book straight through, and found the order in which the material was presented to be logical and very well thought out. I also appreciated the dry humor sprinkled throughout this book–I would often find myself perking up and smiling to myself through a subject which a lesser author could turn into tedium.
Buy Beginning Database Design Solutions (Wrox Programmer to Programmer) now for only $ 25.32!
Database Management Systems
Database Management Systems provides comprehensive and up-to-date coverage of the fundamentals of database systems. Coherent explanations and practical examples have made this one of the leading texts in the field. The third edition continues in this tradition, enhancing it with more practical material. The new edition has been reorganized to allow more flexibility in the way the course is taught. Now, instructors can easily choose whether they would like to teach a course which emphasizes database application development or a course that emphasizes database systems issues. New overview chapters at the beginning of parts make it possible to skip other chapters in the part if you don’t want the detail. More applications and examples have been added throughout the book, including SQL and Oracle examples. The applied flavor is further enhanced by the two new database applications chapters.
Rating: (out of 48 reviews)
Price: $ 73.99
Database Management Systems Reviews
Review by Paul Rogers:
A few years back, I created a special-purpose, custom-built, high-speed relational DBMS using just this book and general computer science knowledge. Darn thing blew the socks off more general purpose solutions and was very stable even after a crash. The book covers access methods, indexing, logging, crash recovery and other basics.
If you want to know how database systems are built at the nuts & bolts level, this is for you. If you want to know how to use a database system, or how to design an application database then this is not your book; choose a “user-level” book instead. If you want to know about the latest research directions, then pass on this one as well since it only covers the tried & true basics.
Review by Christian Gleissner:
I compared this book with two other reference books (Date and Elmasri/Navathe). This book is the best of the three when it comes to presenting the whole database field with a special focus on the design of databases. The key differences to the other books I compared it with are that Date focuses much more on the relational model, whilst Elmasri/Navathe has many side-notes on Oracle and Access. This book by Ramakrishnan/Gehrke deals more with design aspects of databases and gives a broad, yet also somewhat deep introduction in this respect. It does not say much about any database systems on the market but focuses more on concepts. If you are specifically interested in database design, I would recommend getting an advanced book that deals with these issues. However, if you are looking for a general dbms reference book with a special focus on design, this is the best book on the market. Unlike other books (for instance Date), it is also written in a very effective manner and comes right to the point. This easy style is especially advantageous when it comes to more difficult topics such as normalization. Where others delight in formalization, this book actually explains. Solutions for half of the questions in the book can be downloaded from the author’s website by anyone.
Buy Database Management Systems now for only $ 73.99!
Databases Demystified (Demystified)
Through clear language, step-by-step discussions, and quizzes at the end of each chapter, the author makes databases easy. Quickly learn the core skills needed to design, configure, manage, and manipulate databases, whether at work or at home. Topics such as exploring different database models, planning their design, minimizing redundant data, designing tables, applying database design concepts, and implementing database security are covered. This is that fast, easy-to-understand tutorial that you’ve been looking for.
Rating: (out of 24 reviews)
List Price: $ 21.95
Price: $ 11.95
Databases Demystified (Demystified) Reviews
Review by D. Davitian:
I’ve been reading technical books for the last 20 years and this is one of my favorites! The information is clean and accurate, you can plow through the book relatively quickly, and the concepts are presented very clearly. I highly recommend it – the “arm and a leg” you save may be your own.
The subtitle says, “A Self-Teaching Guide”, and that is exactly what you get. I found the prose approachable and the chapters very well organized. Other books sometimes offer an esoteric quiz at the end of the chapter, but this quiz actually helps focus the reader on the main points. Nobody leaves wondering what matters most.
The book targets the novice. However, it doesn’t skimp on the critical, classic database issues such as the outer join, choosing primary and alternate keys, data normalization, good data modeling, and the differences between physical and logical design. Don’t dismiss the book if you think that you are already pretty knowledgeable — I guarantee you’ll learn something new. I know that I did.
I was surprised at the treatment given to Security. Instead of limiting the discussion entirely to database security, the book expanded briefly into some adjacent areas. Anyone that works with a database should know this information, but it’s hard to find it so well ordered. Great coverage.
I do have one objection. After reading it, I thought it would be great to sit down and interview the author to learn more. It’s not that anything is missing, but this complex topic was made very approachable…it left me looking for more. Sometimes the audience hates you at the end of the show, but this refreshingly straightforward leaves you ready for more.
I look forward to the next book, where I expect the author explains how to “kick it up a notch” and become a Database Jedi Master. With a foundation like this, I know I’ll be ready!
Review by T. Winther:
Very, very good introduction to databases. I’m mostly self-taught in the DB field, and felt that although I knew and understood most concepts at a reasonable level, there were a few bits and pieces missing. I bought this book in the hope that it would help me find those bits and pieces, and wasn’t disappointed. This book would be excellent value if it cost more; at it’s current price it’s mindbogglingly good value.
Buy Databases Demystified (Demystified) now for only $ 11.95!
Fundamentals of Database Systems (6th Edition)
Clear explanations of theory and design, broad coverage of models and real systems, and an up-to-date introduction to modern database technologies result in a leading introduction to database systems. Intended for computer science majors, Fundamentals of Database Systems, 6/e emphasizes math models, design issues, relational algebra, and relational calculus. A lab manual and problems give students opportunities to practice the fundamentals of design and implementation. Real-world examples serve as engaging, practical illustrations of database concepts. The Sixth Edition maintains its coverage of the most popular database topics, including SQL, security, and data mining, and features increased emphasis on XML and semi-structured data.
Rating: (out of 56 reviews)
List Price: $ 122.00
Price: $ 80.99
Fundamentals of Database Systems (6th Edition) Reviews
Review by Andrew McCaffrey:
I used FUNDAMENTALS OF DATABASE SYSTEMS (Third Edition) in a graduate class I took on databases, and I’ve kept referring to the book since then. As a student, I’ll admit that it was tough to get through this book at times. It’s dense and almost impenetrable, but it packs a huge amount of information and is amazingly comprehensive.It puts theory well ahead of practical matters, which gives the novice a good foundation from which to really get a firm handle on how all these pieces fit together. The assumption is that the student knows nothing, even B-trees are devoted several pages of explanation. The student who does know nothing will doubtless find this wealth of data to be overwhelming at first (as I did). But stick at it. This textbook is not for people looking at how to simply plug things into Microsoft Access. It’s for programmers seriously looking to gain a strong background in what the fundamental elements of database components and systems are.The text starts off simply, merely explaining in general terms what databases are and who will use them. Then we quickly move into modeling how relational databases work. Data Modeling and Entity-Relationship Models are described in-depth, and the book comes back to ER modeling and mapping repeatedly. Object Models are covered, as well as the best ways of sorting records and the best way to index tables. The authors offer a wealth of information concerning the SQL language — so much so, that there’s much that I simply haven’t used since reading about it, although I’m sure that more advanced database programmers in the audience will find it very enlightening.It continues on with Object-Oriented Database technologies, functional dependencies, and normal forms (first, second, third and Boyce-Codd normal form). Higher system views of database architecture are also discussed, giving us an understanding of how different parts are working together. Optimization, recovery, maintenance and security are naturally touched on, as are distributed databases and the basic client/server architecture relationship. As you can see, this is all very theoretical, although some real-life explanations and examples are brought in. But it is by building up a solid knowledge base that will allow the reader to truly understand systems when encountered in the classroom or in the workplace.I’ve only touched on a handful of things that the book details in its 1000+ pages. It’s packed with mathematical formulas, computer science algorithms, schema design, and the minutua of every database operation. Its approach doesn’t make things easy, but it does contain everything you’d want to know about a given item. I had to read various sections multiple times for my coursework, obviously, but every time I studied a passage, I would uncover details and concepts that I had missed the last time. Even now as reference material, I always find myself learning (or relearning) something when consulting this book. Although in my current job I don’t require a massive amount of database knowledge, I still find this an extremely useful reference guide. To be perfectly honest, I don’t know if I would find this text helpful if I hadn’t taken a course that taught from it. It’s certainly intimidating to a beginner. But if you’re a moderate to intermediate database programmer, you’ll find this an invaluable guide to filling in the gaps in your knowledge. It may be a bit too dense and scary to serve as your only teacher, but you’ll probably find it an important one.
Review by RJ (email@example.com):
This book has just the right mix of database theory and its practical applications. I’ve studied other books of the ilk and found that this book has a leg up on them in that it doesn’t get too hung up on providing proofs for concepts that are either very intuitive or just not worth going into too detailed a proof for. It also provides a good review of “modern” database techniques like Object Oriented database, deductive databases, etc.The book could use a little more polish in terms of grammatical correctness. Besides, in my opinion, some concepts, as explained in the book, are just plain wrong. There is no way for one to contact the authors for clarification either.
Buy Fundamentals of Database Systems (6th Edition) now for only $ 80.99!
Modern Database Management (9th Edition)
Hoffer focuses on the latest principles, concepts and technologies and what leading practitioners say is most important for database developers. Database analysis, database design, SQL, client/server database environment, data warehousing, data quality and integration, and object-oriented data modeling. Intended for professional development programs in introductory database management.
Rating: (out of 17 reviews)
List Price: $ 173.33
Price: $ 84.00
Modern Database Management (9th Edition) Reviews
Review by jackofsometrades:
I bought this book for a DBMS course in a university and I liked it. This is the best written book compared to any IT book on any subject I’ve read. Everything seems so easy and simple with this. And this covers a lot of ground, enough at least for any basic level DBMS course. It covers the basics, SQL, (E)ER-diagrams, O-O db’s, warehousing, etc.What this is NOT: this is not a hands-on guide for real work. This is the first introduction to what you should know before beginning any DB-related work.
Review by Jeff Stephens:
Good up-to-date introductory text on Database Systems. It covers all the bases although in a less quantative way than the Elmasri/Navathe or Ramakrishnan/Gehrke texts. Excellent web based support material. Also, if you get the Oracle Edition (ISBN 0201383721) you’ll get 3 great CD’s: Oracle Designer/2000, Rel. 2.1; Oracle Developer/2000, Rel. 2.1, and Personal Oracle 7, Rel. 7.3.4. I found this package of text and CD’s to be the best value on the market.
Buy Modern Database Management (9th Edition) now for only $ 84.00!
Refactoring Databases: Evolutionary Database Design
Refactoring has proven its value in a wide range of development projects—helping software professionals improve system designs, maintainability, extensibility, and performance. Now, for the first time, leading agile methodologist Scott Ambler and renowned consultant Pramodkumar Sadalage introduce powerful refactoring techniques specifically designed for database systems. Ambler and Sadalage demonstrate how small changes to table structures, data, stored procedures, and triggers can significantly enhance virtually any database design—without changing semantics. You’ll learn how to evolve database schemas in step with source code—and become far more effective in projects relying on iterative, agile methodologies. This comprehensive guide and reference helps you overcome the practical obstacles to refactoring real-world databases by covering every fundamental concept underlying database refactoring. Using start-to-finish examples, the authors walk you through refactoring simple standalone database applications as well as sophisticated multi-application scenarios. You’ll master every task involved in refactoring database schemas, and discover best practices for deploying refactorings in even the most complex production environments. The second half of this book systematically covers five major categories of database refactorings. You’ll learn how to use refactoring to enhance database structure, data quality, and referential integrity; and how to refactor both architectures and methods. This book provides an extensive set of examples built with Oracle and Java and easily adaptable for other languages, such as C#, C++, or VB.NET, and other databases, such as DB2, SQL Server, MySQL, and Sybase. Using this book’s techniques and examples, you can reduce waste, rework, risk, and cost—and build database systems capable of evolving smoothly, far into the future.
Rating: (out of 22 reviews)
List Price: $ 64.99
Price: $ 23.98
Refactoring Databases: Evolutionary Database Design Reviews
Review by Michael Cohn:
This is an excellent book that, in my opinion, serves two purposes. First, it is a compendium of well thought-out ways to evolve a database design. Each refactoring includes descriptions of why you might make this change, tradeoffs to consider before making it, how to update the schema, how to migrate the data, and how applications that access the data will need to change. Some of the refactorings are simple ones that even the most change-resistant DBAs will have used in the past (“Add index”). Most others (such as “Merge tables” or “Replace LOB with Table”) are ones many conventional thinking DBAs avoid, even to the detriment of the applications their databases support.
This brings me to the second purpose of this book. Many DBAs view their jobs as protectors of the data. While that is admirable, they sometimes forget that they are part of a software development team whose job is to provide value to the organization through the development of new (and enhancement of existing) applications. One of the best DBAs I ever worked with viewed himself as a “Data Valet.” He said his job was to make sure the data was presented to applications when and where they wanted and to protect the doors from getting dinged while under his care. Through its first five chapters and then the refactorings that follow, this book will help DBAs expand their view of their role in the organization from one of simply protecting data to one of enhancing the value of data to the organization.
This book is one that you’ll keep on your reference shelf for many years to come. Highly recommended.
Review by Base Aware:
It’s been almost 7 years since Fowler’s Refactoring book, and now the database community has finally caught up with the rest of us. This book shows how to refactor a relational database schema, working you through the detailed process steps for doing so and providing the source code for implementing more database refactorings than I would have thought existed.
The first five chapters describe how to go about database refactoring. Chapter 1 overviews the idea that you can evolve your database schema in small steps, a radical departure for many traditional DBAs. It also overviews the need for supporting techniques such as agile data modeling, database regression testing, and version control of your data models and scripts. I would have liked to see more coverage of these topics, but at least the modeling material is covered in Ambler’s Agile Modeling book and there are some great SCM books out there.
Chapters 2 and 3 walk through the process of implementing a database refactoring, first through the simple situation where there is only a handful of applications accessing the database. I guess this sort of thing happens in smaller companies, but most of the time you really have to worry about scores of applications accessing your database which is a much harder situation. This is actually the focus of Chapter 3 and of the presented solutions in Chapters 6 through 11 which provide reference implementations for all of the database refactorings. This approach belies the true strength of the book: it reflects actual experience in large organizations, not just the theoretical pie in the sky stuff you see from other authors.
Chapter 4 focuses on deploying database refactorings in production, providing detailed instructions for how to roll refactorings between various sandboxes. It importantly describes how to merge the refactorings of several teams together. If you have 100 applications accessing a shared database, then potentially you need to manage the refactorings coming from 100 different development teams. Of course it would never be that bad, but even merging refactorings from 10 teams would be tough. This might be where the technique falls apart because many companies likely don’t have data managers who are skilled enough to do this sort of thing efficiently enough to keep up with agile developers. We need new tools, so hopefully companies like Oracle will build something for us.
Chapter 5 describes a collection of best practices and challenges pertaining to refactoring databases. The authors share their experiences as well as identify potential issues, such as a lack of tooling and agile expertise within the data community, that could slow adoption of this technique. My guess is that the smarter teams within companies will start doing this stuff right away, for the most part it’s pretty easy technically, but that bigger companies will struggle to change as they always do.
Chapters 6+ are reference descriptions for the individual refactorings. Each one is described using a UML data model, which is a little strange at first although once you get used to it you can see how it’s a much better notation than Crow’s feet, a detailed text description and source code. The source code examples are detailed, I guess the authors want to be thorough and provide a complete solution so that there’s no question how to implement each refactoring. The application examples are written in Java or Hibernate, but they’re simple enough that you could see how to implement them in C#, C++, Ruby, or even VB. The database code is Oracle, once again it’s pretty straightforward so you can easily see how it would work in other DBs like Sybase or MySQL.
All in all, if you’re a DBA or agile programmer you need to seriously think about buying this book.
Buy Refactoring Databases: Evolutionary Database Design now for only $ 23.98!
Database Systems: Design, Implementation, and Management
Database Systems: Design, Implementation, and Management, Eighth Edition, a market-leader for database texts, gives readers a solid foundation in practical database design and implementation. The book provides in-depth coverage of database design, demonstrating that the key to successful database implementation is in proper design of databases to fit within a larger strategic view of the data environment. Updates for the eighth edition include additional Unified Modeling Language coverage, expanded coverage of SQL Server functions, all-new business intelligence coverage, and added coverage of data security. With a strong hands-on component that includes real-world examples and exercises, this book will help students develop database design skills that have valuable and meaningful application in the real world.
Rating: (out of 15 reviews)
List Price: $ 161.95
Price: $ 31.99
Database Systems: Design, Implementation, and Management Reviews
Review by Danny Cooper:
I’m a technical person but have very little DB experience and purchased the book because I had to for a college class. I feel the book was simply OK. Some points were made well others I had to read several times. Over all the explanations were not as concise as I would like but in all fairness DB concepts are hard to explain. The overall layout was good however I think there should have been more attention during the intro to familiarize the reader with DB’s and the related concepts before delving in to the details of each phase of DB creation.
My only real gripe is that a new revision is published every year and the previous version of the 0 + dollar book becomes worthless. To save money I bought the previous version and found all the material I needed. However for the final exam the instructor of the online class gave us page numbers to use as reference so I was forced to buy the latest version which was the same book with a few new references…
If you are buying this book for reference or if you are buying this because you are taking a face to face class I recommend that you buy the previous version required by the instructor at a greatly reduced cost. You may be able to do this w/ an online class if the professor (or classmates) are flexible and willing to help reconcile the different page numbers.
Review by Phoebe H:
Book does not come with the student content that it is suppose to come with. It is supposed to come with online appendices A though L and downloads for files used in each chapter. I would not advise to by a 130 dollar incomplete book. It was release in December of 2007 unprepared for people to use because it makes references to sites and files that don’t exist but are supposed to. Signed Cheated patron. I want my money back.
Buy Database Systems: Design, Implementation, and Management now for only $ 31.99!
Concepts of Database Management (Sam 2007 Compatible Products)
This concise yet comprehensive introduction to fundamental database concepts is an indispensable resource to develop your knowledge of database management concepts. Now in its sixth edition, Concepts of Database Management maintains the focus on real-world cases that made previous editions so effective addressing the most current database issues faced today such as database design, data integrity, concurrent updates, and data security. Special features include detailed coverage of the relational model (including Query-By-Example (QBE) and SQL), normalization and views, database design, database administration and management, and more. This book’s advanced topics include distributed databases, data warehouses, stored procedures, and triggers fostering an in-depth understanding of database management that will prepare users for success in their fields.
Rating: (out of 14 reviews)
List Price: $ 79.95
Price: $ 53.24
Concepts of Database Management (Sam 2007 Compatible Products) Reviews
Review by firstname.lastname@example.org:
I have used this book for the past 3 years in an undergraduate database design course. The book addresses the major issues associated with database design without obscuring topics with a lot of the underlying math/relational algebra details. The book serves well as a backdrop for the course material. Its use of MS Access for examples works well for the typical database designer/user. ‘Hardcore’ database students/professors/developers would probably want a more detailed treatment of the subject.
Review by KnottyFella:
If you need a book for certification, this isn’t it….it is so much more than that.
This was the consensus choice of the faculty for the database foundations class when I taught information systems at university.
Of late, when I interview entry level database developers, I can tell whether or not they used this book or a recent version when they started to study database design. If they did not, they lack a comprehensive knowledge of the field. Those with the various certifications know enough about their specific application, but frequently, they can’t figure out problems that haven’t been covered by the certification training. Their conceptual knowledge rarely expands beyond their chosen application.
If you want a solid conceptual foundation of database design…this is your book.
Buy Concepts of Database Management (Sam 2007 Compatible Products) now for only $ 53.24!
Find more Databases products on Amazon!