~/ 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/098c0936-de00-4cb8-bca7-91d26a30aa91/flashcard utf-8 LF