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.

View comments in LiveDocs