Database Design – A Practical Focus: Learn to design databases, from the conceptual model to the relational, using this practical guide and its examples.

Database design is a critical and most important topic when it comes to the creation of software applications.
Beginning with rules that are clear, well-explained and consistently accompanied by
examples, you can learn to design databases in an easy and quick fashion.
Learn to move from a simple description, or requirements, onto a conceptual model, also
called the entity relationship, and ultimately transform it into a relational model, which we
will utilise for an application.
By following the norms offered in this book, you will be able to bring about quality designs
free of errors.
The author is a Senior Computer Science Engineer with vast professional experience.
Translated from the Spanish by Donald Duffy III

Table of Contents
--------------------------------------------
What is data modelling?
The entity relationship model
Entities
Attributes
Relationships
Types of entities
Key selection
Relationships
Other relationship types
Cardinalities
Relationships with attributes
Inheritance relationships (ISA)
Other notations
Transforming the Entity-Relationship into the Relational Model
Important concepts for the Relational Model
Transformation of 1-to-1 relationships
Transformation of 1-to-N relationships
Transformation of N-to-M relationships
Transformation of other types of relationships
Case study
To conclude…