Contents > Developing ColdFusion MX Applications > Introduction to Databases and SQL > What is a database? > Database design guidelines

Database design guidelines

From this basic description, the following database design rules emerge:

• Each record should contain a unique identifier as the primary key such as 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. Databases allow you to use multiple columns for the primary key.
• When you define a column, you define a SQL 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.

Contents > Developing ColdFusion MX Applications > Introduction to Databases and SQL > What is a database? > Database design guidelines

ColdFusion 9 | ColdFusion 8 | ColdFusion MX 7 | ColdFusion MX 6.1 | ColdFusion MX | Forums | Developer Center | Bug Reporting

Version 6.1

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.