Developing a Set of Rules (Designing Databases)
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