~/ learn/ comp-378/ cards/ Physical Design: Fields, Data Types, Denormalization & Partitioning
1 of 5

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.

space flip · ← → navigate · esc to exit
NORMAL ~/memra/library/b24a626a-cba2-4a21-93ad-c0de158f94f2/flashcard utf-8 LF