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: openlibrary.ecampusontario.ca

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

Adaptations: Support for adapting an open textbook

Open Textbooks:

Creative Commons License
Database Design-2nd Edition by Adrienne Watt, Douglas College, Nelson Eng, Douglas College is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted.


Review this book

Reviews for 'Database Design - 2nd Edition'

Number of reviews: 2
Average Rating: 3.4 out of 5

1. Reviewed by: Dr. Milan Frankl
  • Institution: University Canada West
  • Title/Position: Professor of Business
  • Overall Rating: 1.8 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 textbook does not cover all the material one would need to address in an academic course covering the topic of Database Design – in spite of a detailed chapter list in the table of content.

Most chapters contain superficial, non-descriptive, point form lists with incomplete or inadequate substantive information.

Chapter structure is valid (chapter title, content (poor and limited) ,
key terms (poorly defined), exercises (weak, mostly inadequate, and
sometime not related to the chapter’s topic).

Comprehensiveness Rating: 1 out of 5

Q: Content is accurate, error-free and unbiased

Numerous topics are incorrectly introduced and contain inadequate
formalism as well as inaccurate information.

For example GEAC (a defunct company since 2006) is referenced ?!

Moreover, most of the “design” examples are simplistic, incomplete
and irrelevant in the present Internet-based development environment.

This form of content weakness is present even in chapters of more
than one page in length.

Content Accuracy Rating: 1 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 poorly structured, with topics jumping from one to another
without proper transition or idea flow.

Relevance is inadequate, presenting some outdated topics in name only.
Current material like OOD, Metadata framework, Jason Parser, SQL Light
arrays, Android apps (Microsoft, Apple, device specific), and so on are
missing.

Maintaining content up to date will require a complete rewriting of the
textbook.

Relevance Rating: 1 out of 5

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

The writing style is colloquial and patronizing. The students are addressed
in a non-professional manner throughout the text in the form of “you” –
second person.

One needs to consider that in an online environment, mature students
could form the majority of the reading audience.

Clarity Rating: 2 out of 5

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

Some inconsistencies appear in various chapters. The terminology is
adequate but lacks formality – an essential element in computer science.

Consistency Rating: 2 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 text consists mostly of short chapters with some exercises not
always relating to the chapter’s content.
Of course, this results in a reference book inadequate for teaching in
a higher education environment.

Lack of formal rigour is present throughout the book.

Some self-referencing exists - one main source is:

Database System Concepts by Nguyen Kim Anh

Modularity Rating: 2 out of 5

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

The theory is presented in short segments without proper substance –
mostly referring the reader to one main outside source –
Database System Concepts by Nguyen Kim Anh

Again, lack of formality is a major weakness – this book is supposed to
cover computer science material were rigour is essential

Organization Rating: 2 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

Because the vast majority of the text consists in short chapter, these are
easily identifiable.

However, the relation between the table of content and the text is
misleading because chapter content is minimal (one to three pages on average) – except when covering SQL in Chapter 16 - (which requires more scrutiny and depth).

The format of the pdf file is inconsistent – with pages containing poor picture resolution, and low readability making navigation awkward.

Interface Rating: 2 out of 5

Q: The text contains no grammatical errors

The writing style is colloquial and patronizing. The students are addressed in a non-professional manner throughout the text in the form of “you” – second person.

One needs to consider that in an online environment, mature students could form the majority of the reading audience.
Some inconsistencies appear in various chapters. The terminology is adequate but lacks formality – an essential element in computer science.

The text consists mostly of short chapters with some exercises not always relating to the chapter’s content.
Of course, this results in a reference book inadequate for teaching in a higher education environment.
Lack of formal rigour is present throughout the book
The theory is presented in short segments without proper substance – mostly referring the reader to one main outside source – Database System Concepts by Nguyen Kim Anh

Again, lack of formality is a major weakness – this book is supposed to cover computer science material were rigour is essential
Because the vast majority of the text consists in short chapter, these are easily identifiable.
However, the relation between the table of content and the text is misleading because chapter content is minimal (one to three pages on average) – except when covering SQL in Chapter 16 - (which requires more scrutiny and depth).

The format of the pdf file is inconsistent – with pages containing poor
picture resolution, and low readability making navigation awkward.

Using the online Grammarly to analyze the grammar and writing style
resulted in issues covering:

Use of conjunctions
Incorrect use of prepositions
Comparing two or more things
Confusing modifiers
Wordiness
Spelling
Vocabulary use
Use of articles
Subject and verb agreement
Punctuation within a sentence
Formal punctuation
Sentence structure
Passive voice use
Capitalization
Writing style
Vocabulary use

Based on the above, the text contains numerous grammar and style errors,
including punctuations weaknesses not acceptable in an academic textbook.

Grammar Rating: 2 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

Except for addressing the reader, the text is acceptable and reader
background independent.

Cultural Relevance Rating: 3 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?

I do not recommend this textbook for various reasons detailed in the
review above..

This textbook is obviously a work in progress.

The list of 16 chapters in the table of content is misleading.
Many “chapters” are no more than a page or two in length, containing mostly
point-form statements, with little or no substance.

Definitions of most technical terms are inadequate, incomplete or missing.
Exercises are poorly related to the content of the chapter’s topic.
The few examples are incomplete, simplistic, and inadequately solved or
not solved at all..

Referencing is inadequate, inappropriate, does not follow any academic format,
, and is mostly related to a limited source like Database System Concepts by Nguyen Kim Anh licensed under Creative Commons Attribution License 3.0 license [mostly a verbatim copy].

There is no bibliography, nor an index limiting the capability of
finding information or references in a quick and straightforward, manner.

2. 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.