Database Design - 2nd Edition

(5 reviews)


Adrienne Watt, City University

Pub Date: 2014

ISBN 13:

Publisher: BCcampus

Conditions of Use



  All reviews are licensed under a CC BY-ND license.

Learn more about reviews.


Reviewed by Benjamin Branch, Professor-LSIS, North Carolina Central University, on 2/2/2018.

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



Reviewed by Adam Lee, Fellow, University of Maryland, on 2/2/2018.

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



Reviewed by Sally Hamouda, Assistant Professor, Rhode Island College, on 2/2/2018.

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



Reviewed by mary gable, instructor, tidewater community college, on 8/16/2017.

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



Reviewed by Krishnendu Ghosh, Assistant Professor, Miami University, on 6/21/2017.

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


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:

  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


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.