The Relational Model: Integrity - Attribute and Type

• Integrity is provided through constraints
• We already saw attribute constraints
• Each attribute has a type
• Types are constraints
• part_number: integer, > 0
• part_name: string, length >= 2
• color: string, one of "red", "green", "blue", "yellow"