December 2010
Beginner to intermediate
368 pages
7h 19m
English
“The pure and simple truth is rarely pure and never simple.”
Oscar Wilde
This chapter presents a more complex system and introduces a model diagram and its representation in tables.
Sam’s system started off with a simple setup—a Customer table and a CD table. The CD table had an entry for each physical CD. This corresponded to Sam’s paper system, in which each CD had a separate index card that recorded its being rented. The table looked like this.

A system is often more complex than Sam’s example. There are more entities than just a CD, and there are relationships ...
Read now
Unlock full access