Database Design - 2nd Edition
Adrienne Watt, City University
Pub Date: 2014
Conditions of Use
It give a sound history and need for database without picking one other the other. It also comes in several formats from pdf to Kindle and etc. It read more
It give a sound history and need for database without picking one other the other. It also comes in several formats from pdf to Kindle and etc. It provide a clear and unbiased history of data effort and societal engagement with data. It give a good scope of data base design. It does not include any open source database topics like Hadoop or MongoDB or their influx on the database market, learning or industry. Such would have to be supplemented materials.
It accuracy is very good and it admits is covers most topics in databases.It's a great intro to databases book.
For a free book it is awesome. Even though cloud databases have existed since 1996, their use is now only becoming mainstream, but the basics of databases remains in tact.It does not include GIS or apps as extensions of databases in 2017. For intro to database awesome, but not for an advanced databases course.
it has the properly communication for a novice database person getting into the field. The book give a great introduction to database and is clear throughout.
The book is written in a consistent manner and attempts not to lose the learner. The book uses some mathematical formula and needs more.
The book is broken down well into many chapters and digestible chunks of thought that are easily builds upon previous learning. the various chapters do a great job breaking down the database knowledge.
the book is very well organized and thought out. It give good examples for student to build up with homework to test their perceptions. The book sets up the learning of material and give a learner an opportunity to apply it in homework. Also, vocabulary is used to add to the database literacy of the student.
it was simple to use for an introductory course. Now real world experience would still need to be done in a hands-on manner. It gave examples and key terms to support more learning for another course. All graphics and layout were done very nicely for the online and pdf versions.
The grammar use was excellent. It made clear objectives and outcomes for learning.
not really applicable
A 3rd edition would be welcomed!!!
The book contains the Table of Contents and lists Key Terms for every Chapter. However, it will be better to include Index with corresponding page read more
The book contains the Table of Contents and lists Key Terms for every Chapter. However, it will be better to include Index with corresponding page numbers and/or hyperlinks.
Content is accurate with many examples.
Better to add some more brief introduction on non-traditional databases and maybe some compact comparison table as well.
The figures and the tables are clear. Some itemized list may extend with longer explanations. Chapter 3 may be improved by putting some sections as sub-sections under other sections. Chapter 4 may explain the Physical Data Models as well. On relational model, the Primary Keys should be highlighted, e.g. bolded.
The whole book should be standardized with one ERD format. The early chapter uses the Chen's notation. The key chapter uses and explains the Crow's Feet notation. The appendix uses the UML.
The content includes all key components and topics about traditional database management systems.
Chapters 8, 9 and 10 may be re-arranged in sequence.
The pages are all good.
The grammar reads well.
The content reads neutral on cultural relevance.
Maybe CREATE VIEW and DROP VIEW can be added.
The texts covers all the topics required for an introduction to data base management course. read more
The texts covers all the topics required for an introduction to data base management course.
The book is accurate and follows the conventions used in other popular references in the data base management system field.
The book is very relevant to the content covered in an introductory database management system courses.
The book text clear. The figures resolution is not excellent but readable. The naming of the attributes for some relations in the relational model chapter is not very descriptive in some cases. The exercises are limited in some chapters.
The naming of the attributes for some relations in the relational model chapter is not very descriptive in some cases. The exercises are limited in some chapters.
The text is easy to read and easy to divide in smaller sections that can be assigned within the course.
The flow of the book is very good and follows the state of the art for other very well know references in the same field.
The only thing to mention is the resolution of the figures that need to be enhanced.
I didn't see any grammatical mistakes.
The text is not culturally insensitive or offensive in any way.
The book is very useful for introductory database management courses.
The book covers all necessary areas and topics, but I did not see an overall index. I like the idea of having key terms at the end of each section. read more
The book covers all necessary areas and topics, but I did not see an overall index. I like the idea of having key terms at the end of each section. It was a great book for database design and as an extra bonus, SQL was covered in greater detail than most texts on the subject. It is complete with section review, exercises, and solutions. Table of contents is complete, organized, and the topics are presented in the appropriate order.
Topics are described accurately and content is free of errors.
The topic here is traditional theory which does not change quickly as typical IT topics do. All content is relevant and up-to-date examples are used. Any updates should be easily implemented, but very few would be expected.
The book was very clear and topics were explained thoroughly. The terminology used was easy to understand. Key terms for each section were conveniently located at the end of each section which explained the important terms. This could easily be used as a section review.
The text, terminology, and terms are consistent throughout all sections of the book.
The book was consistent with all the typical modules and sections with key terms, questions, and lab exercises which reinforced concepts covered in each section. It is well-organized and reading flowed easily. Terms were presented in the appropriate order and the text was not verbose.
Topics are presented in a logical fashion. This organization is typical of all other database design courses I have seen.
Many of the images are blurry and difficult to see. I had to zoom very large and they were still sometimes very hard to read. Navigation was typical of PDF documents and easy to move around and navigate throughout the document.
I found a few grammatical errors.
The text is not insensitive or offensive. Examples are typical business examples which are relevant and current. Example database designs are very simple to comprehend so that emphasis is placed on learning the concepts.
I think this book would make an excellent textbook for a relational database design course. It is complete with exercises and section reviews. The exercises are very beneficial and solutions to examples and labs are included with the text which is very important to the student. It would also be good to use for a SQL review.
The book is a thorough and covers the topics that is expected to be covered in a database design course. The topics are well organized. I was read more
The book is a thorough and covers the topics that is expected to be covered in a database design course. The topics are well organized. I was expecting material on NoSQL to be included and other recent updates in databases
The material in the book was accurate.
The book covers the material required in database design well and will be relevant in future. The recent advances in the database design should be incorporated.
The book is clear and concise.
The book is consistent in terms of terminology and organization of the concepts in every chapter.
The chapters in the book provide modularity. The instructor can select the topics accordingly.
The organization and structure is broad and comprehensive. I would hope there could have been more worked out examples.
The interface is great.
I did not find any errors in grammar
I did not find any culturally insensitive or offensive material.
This book is an ideal textbook for database design. The organization of the book helps in the understanding of the material at a low gradient. I hope the authors add more worked out examples.
Table of Contents
About the Book
- Chapter 1 Before the Advent of Database Systems
- Chapter 2 Fundamental Concepts
- Chapter 3 Characteristics and Benefits of a Database
- Chapter 4 Types of Data Models
- Chapter 5 Data Modelling
- Chapter 6 Classification of Database Management Systems
- Chapter 7 The Relational Data Model
- Chapter 8 The Entity Relationship Data Model
- Chapter 9 Integrity Rules and Constraints
- Chapter 10 ER Modelling
- Chapter 11 Functional Dependencies
- Chapter 12 Normalization
- Chapter 13 Database Development Process
- Chapter 14 Database Users
- Chapter 15 SQL Structured Query Language
- Chapter 16 SQL Data Manipulation Language
Appendix A University Registration Data Model Example
Appendix B Sample ERD Exercises
Appendix C SQL Lab with Solution
About the Authors
About the Book
This second edition of Database Design book covers the concepts used in database systems and the database design process. Topics include:
- The history of databases
- Characteristics and benefits of databases
- Data models
- Data modelling
- Classification of database management systems
- Integrity rules and constraints
- Functional dependencies
- Database development process
New to this edition are more examples, highlighted and defined key terms, both throughout and at the end of each chapter, and end-of-chapter review exercises. Two new chapters have been added on SQL, along with appendices that include a data model example, sample ERD exercises and SQL lab with solutions.
About the Contributors
Adrienne Watt holds a computer systems diploma (BCIT), a bachelor’s degree in technology (BCIT) and a master’s degree in business administration (City University).
Since 1989, Adrienne has worked as an educator and gained extensive experience developing and delivering business and technology curriculum to post-secondary students. During that time, she ran a successful software development business. In the business, she worked as an IT professional in a variety of senior positions including project manager, database designer, administrator and business analyst. Recently she has been exploring a wide range of technology-related tools and processes to improve delivery methods and enhance learning for her students.