~/ learn/ comp-378/ cards/ Physical Database Design & Infrastructure
1 of 23

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/b10d170c-e17a-4ada-9bba-dc2e8ff91f1f/flashcard utf-8 LF