Database Design - 2nd Edition
Adrienne Watt, City University
Pub Date: 2014
Conditions of Use
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.