Type a physical field spec with all three integrity controls.
Type a physical field spec with all three integrity controls.
Answer
credits INTEGER NOT NULL DEFAULT 3 CHECK (credits BETWEEN 1 AND 6)
NOT NULL is a null control, the CHECK is a range control, and DEFAULT 3 is a default value — the three field-level integrity controls, all on one INTEGER field chosen so credit loads can still be summed.