A Database Primer

You have just seen a practical use for a database. The movie list is a simple database that involves a single table and a small set of columns. Most well-designed database applications require many tables and ways to link them. You’ll revisit the movie list when we discuss relational databases.

Your first table was a hit. You have been able to accommodate any list request, sorted any way anyone could need. But just as you are beginning to wonder what you’re going to do with all your newfound spare time, your boss informs you that he’ll need reports sorted by the director name.

“No problem,” you say. You open your database application and modify your table. You add two new columns, one for the director’s first name and one for ...

Get Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.