~/ 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/f60c9a7a-44f6-425b-954d-bd2a4d92737f/flashcard utf-8 LF