O'Reilly logo

Dreamweaver MX: The Missing Manual by David Sawyer McFarland

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Databases Explained (in Five Minutes or Less)

A database is like an electronic filing cabinet that stores related information. You encounter them every day, whether charging a dinner on a credit card or calling Moviefone to get local movie listings. At home, you might have a low-tech database in the form of a filing cabinet containing folders for insurance statements, phone bills, car service records, and so on.

Tables and Records

Databases have an electronic equivalent to filing folders: tables. A table is a container for information about a set of similar items.

In the Cosmo Farmer classified ads database, a table stores information on a list of classified ads. It tracks the names of the products for sale, their prices, short descriptions, and a few other items. Each piece of information, like price, is stored in a column. All the information for each ad (all the columns taken together, in other words) make up a single record, which is stored in a row (see Figure 21-7).

This diagram shows the structure of the Ads table, in which four records are stored. Each row in a table represents a single record or item, while each piece of information for a record is stored in a single field or column.

Figure 21-7.  This diagram shows the structure of the Ads table, in which four records are stored. Each row in a table represents a single record or item, while each piece of information for a record is stored in a single field or column.

If you were designing a database, you’d try to model a table on some real-world item you needed to track. In a database for generating invoices for your business, you might have a ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required