Database Design: Creating a valid Table
V22.0380 - Databases - Spring, 2005
- Each row or record contains data about a specific entity
- Each column or field contains data about the attributes of an entity
- Each cell of a table or any given field within a specific record may only
contain one value.
- All entries of a specific column or field are of the same kind; i.e. they
are of the same data type.
- Every column or field has a unique name within the table.
- The order of the columns is not important
- The order of the rows is not important
In addition, with respect to the data:
- No two rows may be identical
Adapted from Database Concepts, Second Edition, by David
Kroenke, page 26