Discuss the functionality and importance of the Integrity Enhancement Feature (IEF).

What will be an ideal response?


Required data: NOT NULL of CREATE/ALTER TABLE.
Domain constraint: CHECK clause of CREATE/ALTER TABLE and CREATE

DOMAIN.

Entity integrity: PRIMARY KEY (and UNIQUE) clause of CREATE/ALTER

TABLE.

Referential integrity: FOREIGN KEY clause of CREATE/ALTER TABLE.
General constraints: CHECK and UNIQUE clauses of CREATE/ALTER TABLE and

(CREATE) ASSERTION.

Computer Science & Information Technology

You might also like to view...

A computer’s word size

a. is the number of bits that a computer processes as a single unit of information b. is the size of the computer’s random access memory c. is dependent upon the size of the operating system d. is the number of instructions in the computer’s instruction set

Computer Science & Information Technology

A given set of conditions is known as a(n) ________

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Si una galería de la Cinta tiene más opciones de las que se pueden mostrar en la Cinta, se hace clic en el botón ____ para abrir la galería completa.

A. Más B. Además C. Expandir D. Abrir

Computer Science & Information Technology

Shapes can be added to a SmartArt.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology