CHAPTER 2The Language of Data Modeling

The Simpsons is filmed before a live studio audience.

—"Lisa's Sax," The Simpsons

If the database that is being modeled is done correctly, the data model is often the best form of documentation a system gets. It gives you an overview of the foundation of the system, and programmers and end users alike can read it to get an idea of how their system works and how tables are related. Best of all, using a good tool, you can practically design the basics of a system live, right with your clients as they describe what you want (hopefully, someone else would be gathering other requirements that are not data structure related).

The first step, however, is to get a grasp on the language that the graphical depiction ...

Get Pro SQL Server 2008 Relational Database Design and Implementation now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.