Developing a Set of Rules (Designing Databases)

From InterBase
Jump to: navigation, search

Go Up to Designing Databases


When designing a table, you need to develop a set of rules for each table and column that establishes and enforces data integrity. These rules include:

  • Specifying a data type
  • Choosing international character sets
  • Creating a domain-based column
  • Setting default values and NULL status
  • Defining integrity constraints and cascading rules
  • Defining CHECK constraints

Topics

Advance To: