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.
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; Normalization; Database development process.
This open book is licensed under a Creative Commons License (CC BY). You can download Database Design ebook for free in PDF format (2.8 MB).
Table of Contents
Before the Advent of Database Systems
Characteristics and Benefits of a Database
Types of Data Models
Classification of Database Management Systems
The Relational Data Model
The Entity Relationship Data Model
Integrity Rules and Constraints
Database Development Process
SQL Structured Query Language
SQL Data Manipulation Language
University Registration Data Model Example
Sample ERD Exercises
SQL Lab with Solution