Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

If you want to build databases that are robust, flexible, and accurate, you have to come to grips with design theory. But this theory is riddled with difficult terms and concepts that don’t seem to have much to do with design in practice. In this two-day master class, renowned expert C.J. Date bridges the gap by introducing design theory in ways practitioners can understand. This painless introduction to design theory is for database professionals familiar with the relational model.

Subscriber Reviews

Average Rating: 4.8 out of 5 rating Based on 5 Ratings

"An absolute must" - by desmond54 on 25-APR-2012
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
Any developer who uses a database - and if you don't, why do you think you are a developer - should watch this. I did so as part of my Safari subscription - what a great deal - and have also bought the digital version of the book.

I recommend downloading the presentation slides from the Extras tab for reference as you are watching.

Watch the video and then read the book.

Well done O'Reilly and C.J. !!!

Report as Inappropriate

Table of Contents

Chapter/Selection

Time

Preamble

Play Video

00:29:37

A Review of Relational Basics

Preview

00:29:29

Normalization - Preliminaries

Preview

00:16:06

Normalization - FDs and BCNF (informal) - Part 1

Preview

00:35:23

Normalization - FDs and BCNF (informal) - Part 2

Preview

00:27:02

Normalization - FDs and BCNF (formal)

Preview

00:36:25

Normalization - Preserving FDs

Preview

00:33:10

Normalization - FD Axiomatization

Preview

00:13:14

Denormalization

Preview

00:20:42

Normalization - JDs and 5NF (informal)

Preview

00:27:10

Normalization - JDs and 5NF (formal) - Part 1

Preview

00:22:42

Normalization - JDs and 5NF (formal) - Part 2

Preview

00:27:11

Normalization - Implicit Dependencies - Part 1

Preview

00:29:50

Normalization - Implicit Dependencies - Part 2

Preview

00:11:21

Normalization - The Chase

Preview

00:18:03

Normalization - MVDs and 4NF

Preview

00:36:41

Normalization - Other Normal Forms - Part 1

Preview

00:28:18

Normalization - Other Normal Forms - Part 2

Preview

00:27:14

Orthogonality

Preview

00:30:25

Redundancy - Part 1

Preview

00:35:50

Redundancy - Part 2

Preview

00:11:57

Redundancy - Part 3

Preview

00:21:24

The Primacy of Primary Keys

Preview

00:20:18

Redundancy Revisited

Preview

00:19:37

Extras

The publisher has provided additional content related to this title.


Description
Content

Visit the errata page for C.J. Date's Database Design and Relational Theory: Normal Forms and All That Jazz Master Class

  • Errata

Visit the catalog page for C.J. Date's Database Design and Relational Theory: Normal Forms and All That Jazz Master Class

  • Catalog Page

Download the supplemental electronic content for C.J. Date's Database Design and Relational Theory: Normal Forms and All That Jazz Master Class

  • Supplemental Content