Browse the Collection

Please search the collection as a library catalogue or database. For example, to retrieve all results related to sociology, you may want to use sociolog* as this will include books with any ending to the root ~ sociology, sociological, sociologist, and sociologists ~ in the title or description.

Database Design-2nd Edition

textbook cover image
Spiral Stairs In Milano old building downtown (http://www.flickr.com/photos/micurs/3498339723/in/photostream/) by Michele Ursino (http://www.flickr.com/photos/micurs/) used under a CC-BY-SA license (http://creativecommons.org/licenses/by-sa/2.0/deed.en_CA)

Description: Database Design - 2nd Edition covers database systems and database design concepts. New to this edition are SQL info, additional examples, key terms and review exercises at the end of each chapter.

Author: Adrienne Watt, Douglas College, Nelson Eng, Douglas College

Original source: open.bccampus.ca

Adoption (faculty): Contact us if you are using this textbook in your course

Adaptations: Support for adapting an open textbook

Open Textbook(s):

  1. DOWNLOAD PDF file. This icon is licensed under a Creative Commons
Attribution 3.0 License. Copyright Yusuke Kamiyamane. Print PDF (.pdf) (8 MB)
  2. WEBSITE External website. This icon is licensed under a Creative Commons
		Attribution 3.0 License. Copyright Yusuke Kamiyamane. Read this book online
  3. DOWNLOAD PDF file. This icon is licensed under a Creative Commons
Attribution 3.0 License. Copyright Yusuke Kamiyamane. Digital PDF (.pdf) (2 MB)
  4. DOWNLOAD EPUB file. This icon is licensed under a Creative Commons
Attribution 3.0 License. Copyright Yusuke Kamiyamane. eReader (.epub) (1 MB)
  5. DOWNLOAD MOBI file. This icon is licensed under a Creative Commons
Attribution 3.0 License. Copyright Yusuke Kamiyamane. Kindle (.mobi) (3 MB)
  6. PRINT Buy a print copy
  7. DOWNLOAD XML file. This icon is licensed under a Creative Commons
Attribution 3.0 License. Copyright Yusuke Kamiyamane. EDITABLE: PressBooks file (.xml) (0.58 MB)
  8. DOWNLOAD XML file. This icon is licensed under a Creative Commons
Attribution 3.0 License. Copyright Yusuke Kamiyamane. EDITABLE: WordPress file (vanilla.xml) (0.55 MB)
  9. DOWNLOAD XHTML file. This icon is licensed under a Creative Commons
Attribution 3.0 License. Copyright Yusuke Kamiyamane. EDITABLE: HTML file (.html) (0.3 MB)
  10. DOWNLOAD ODT file. This icon is licensed under a Creative Commons
Attribution 3.0 License. Copyright Yusuke Kamiyamane. EDITABLE: Open Document Text file (.odt) (0.57 MB)

1. Reviewed by: Simhadri (Rupa) Manabala
  • Institution: Douglas College
  • Title/Position: CSIS Instructor
  • Overall Rating: 5 out of 5
  • Date:
  • License: Creative Commons License

Q: The text covers all areas and ideas of the subject appropriately and provides an effective index and/or glossary

The concepts underlying the database design process are clearly defined and explained. Each chapter has a list of key terms from the chapter which indeed act as glossary.

Comprehensiveness Rating: 5 out of 5

Q: Content is accurate, error-free and unbiased

The diagrams and the supplementary material such as screen caps/ queries with syntax and examples are clearly provided so the learners can try it out for themselves and check the results. The content is completely un-biased.

Content Accuracy Rating: 5 out of 5

Q: Content is up-to-date, but not in a way that will quickly make the text obsolete within a short period of time. The text is written and/or arranged in such a way that necessary updates will be relatively easy and straightforward to implement

The text is written and/or arranged in such a way that necessary updates will be relatively easy and straightforward to implement. There is a noticeable variation between the syntax for SQL statements in general and SQL Server 2012 Database Engine edition syntax. Having said that, transition to the latest edition of the SQL Server 2012 program is not an issue of concern. The text in each chapter is not too lengthy so that the reader gets distracted. At the same time, it is not too short where the learner does not get enough information for that topic. Well written.

Relevance Rating: 5 out of 5

Q: The text is written in lucid, accessible prose, and provides adequate context for any jargon/technical terminology used

The language used in the textbook is quite simple and straightforward for the learner to relate to the terminology used in the industry practices. Having said that, I must mention that the section on Joins (pages 107 – 109) needs a bit more clarification in simple terms.

Clarity Rating: 5 out of 5

Q: The text is internally consistent in terms of terminology and framework

Totally agree that the text is internally consistent in terms of terminology and framework. Well looked into the background of each and every topic, definition and supported by examples and diagrams, right from the beginning to the end.

Consistency Rating: 5 out of 5

Q: The text is easily and readily divisible into smaller reading sections that can be assigned at different points within the course (i.e., enormous blocks of text without subheadings should be avoided). The text should not be overly self-referential, and should be easily reorganized and realigned with various subunits of a course without presenting much disruption to the reader.

The textbook is very organized with the content matter. The topics are broken down into modules with increasing complexity. The entire Database design process is introduced in a modular basis making it easier for the students to see what the entire process from the start to the end.

Modularity Rating: 5 out of 5

Q: The topics in the text are presented in a logical, clear fashion

The content in the text book is well organized in a manner where the topics are introduced and arranged from lower to higher complexity. The structure and flow of the matter is managed very well. There is a minor alignment issues of the text in terms of margins and page layout from one page to another, but totally rectifiable.

Organization Rating: 5 out of 5

Q: The text is free of significant interface issues, including navigation problems, distortion of images/charts, and any other display features that may distract or confuse the reader

The pictures, diagrams and tables in the book are well organized, in a clear and simple manner making it easy for the learner to comprehend the subject matter.

Interface Rating: 5 out of 5

Q: The text contains no grammatical errors

The text contains no grammatical errors. If there are any minor errors whatsoever, they are not hindering factor to the learner's learning experience. So, not a big issue.

Grammar Rating: 5 out of 5

Q: The text is not culturally insensitive or offensive in any way. It should make use of examples that are inclusive of a variety of races, ethnicities, and backgrounds

The content, examples, and pictures in the book does not seem offensive for any given learner community’s cultural background or ethnicity.

Cultural Relevance Rating: 5 out of 5

Q: Are there any other comments you would like to make about this book, for example, its appropriateness in a Canadian context or specific updates you think need to be made?

This book is a very useful resource for the general audience. Not just for students, this book can be used by industry professionals as a quick reference or a part of the training manual for those who are considering to get involved in the Database Design and implementation process for their organization. The implementation section of the book can be updated, if possible. Overall, the book is a good resource for use in the classrooms and for Information Systems design and development teams.

This book can be used for the First year courses where Database Design process in introduced. It is also suitable for the Second year students with additional topics on the implementation. Having said that, I feel that it was a well thought out idea to use it teach the second year students.