Developing a Set of Rules (Designing Databases)
From InterBase
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
NULLstatus - Defining integrity constraints and cascading rules
- Defining
CHECKconstraints
Topics
- Specifying a Data Type
- Choosing International Character Sets
- Specifying Domains
- Setting Default Values and NULL Status
- Defining Integrity Constraints
- Defining CHECK Constraints