Skip to content

Read more about Database Design - 2nd Edition

Database Design - 2nd Edition

(12 reviews)

Adrienne Watt, City University

Copyright Year: 2014

Publisher: BCcampus

Language: English

Formats Available

Conditions of Use

Attribution Attribution
CC BY

Reviews

Learn more about reviews.

Reviewed by Karen Scott, Senior Lecturer, University of Texas at Arlington on 3/26/24

The book is relatively short compared to most database texts, even those of an introductory nature, but it's still fairly comprehensive. It includes all the major topics necessary to understand the standard database concepts like data modeling,... read more

Reviewed by Simon Jin, Associate Professor, Metropolitan State University on 3/6/24

Considering this is a textbook for introductory class for Database Management/Design, this book well covered most of the necessary basics required for new learners who may not have any prior experience / knowledge. In most cases, however, little... read more

Reviewed by David Barbella, Assistant Professor, Earlham College on 3/29/21

This is very much a Database Design text, not a Database Implementation text, and in those grounds is reasonably comprehensive. The text covers much of the terminology I would want students to become familiar with, as well as the major concepts... read more

Reviewed by Amit Deokar, Associate Professor, University of Massachusetts Lowell on 6/29/20

This book is quite comprehensive in its coverage of key topic areas expected to be covered in an introductory database course at the undergraduate (bachelor's degree) level. The authors should also consider including an introduction to star schema... read more

Reviewed by Thyago Mota, Assistant Professor, Metropolitan State University of Denver on 10/25/19

The book does not cover relational algebra, which provides an important foundation for relational model mechanisms. From my personal experience teaching databases, discussing relational algebra makes it easier for students to later grasp SQL... read more

Reviewed by Carolyn LaMacchia, Associate Professor, Bloomsburg University of Pennsylvania on 3/9/19

Content walks through the various pieces to build understanding. All components are there for relational database design. read more

Reviewed by Morgan Benton, Associate Professor, JMU on 11/26/18

While the book at least mentions all of the key terms, it is not clear that these concepts are covered in sufficient depth to really serve as a practical guide for new practitioners. More explanation follows. read more

Reviewed by Sally Hamouda, Assistant Professor, Rhode Island College on 2/1/18

The texts covers all the topics required for an introduction to data base management course. read more

Reviewed by Adam Lee, Fellow, University of Maryland on 2/1/18

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. read more

Reviewed by Benjamin Branch, Professor-LSIS, North Carolina Central University on 2/1/18

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... read more

Reviewed by mary gable, instructor, tidewater community college on 8/15/17

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... read more

Reviewed by Krishnendu Ghosh, Assistant Professor, Miami University on 6/20/17

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 read more

Table of Contents

  • 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

Ancillary Material

Submit ancillary resource

About the Book

This second edition of Database Design book covers the concepts used in database systems and the database design process. Topics include:

  1. The history of databases
  2. Characteristics and benefits of databases
  3. Data models
  4. Data modelling
  5. Classification of database management systems
  6. Integrity rules and constraints
  7. Functional dependencies
  8. Normalization
  9. 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

Author

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.

Contribute to this Page

Suggest an edit to this book record