RELATIONAL DATABASE RULES

Rule 1: All table names must be unique (within a connection).

Rule 2: All column names must be unique (within a table).

Rule 3: All columns must be unordered to guarantee that any column can be queried in any order

Rule 4: All column data must be atomic (contains no more than one indivisible datum).

Rule 5: All column data must be the same datatype to preserve domain integrity.

Rule 6: All rows must be unique (no duplicate primary keys) to guarantee row accessibility and to preserve entity integrity..

Rule 7: All rows must be unordered to guarantee row sortability