Understanding Database Basics

You do not need a thorough knowledge of databases to develop a data-driven ColdFusion application, but you need to know some basic concepts and techniques.

A database is a structure for storing information. Databases are organized in tables, which are collections of related items. For example, a table might contain the names, street addresses, and phone numbers of individuals. Think of a table as a grid of columns and rows. In this case, one column contains names, a second column contains street addresses, and the third column contains phone numbers. Each row constitutes one data record. In this case, each row is unique because it applies to one individual. Rows are also referred to as records. Columns are also referred to as fields.

You can organize data in multiple tables. This type of data structure is known as a relational database and is the type used for all but the simplest data sets.

Database design guidelines

From this basic description, a few database design rules emerge:

Each record should contain a unique identifier, known as the primary key. This can be an employee ID, a part number, or a customer number. The primary key is typically the column used to maintain each record's unique identity among the tables in a relational database.
After you define a column to contain a specific type of information, you must enter data in that column in a consistent way.
To enter data consistently, you define a data type for the column, such as allowing only numeric values to be entered in the salary column.
Assessing user needs and incorporating those needs in the database design is essential to a successful implementation. A well-designed database accommodates the changing data needs within an organization.

The best way to familiarize yourself with the capabilities of your database product or database management system (DBMS) is to review the product documentation.

Developing ColdFusion Applications
Querying a Database