With which of the four types of constraints in Exercise 4 is a requirement that an attribute not contain a null value associated?

QUESTION: With which of the four types of constraints in Exercise 4 is a requirement that an attribute not contain a null value associated?   [signinlocker] SOLUTION   A not null constraint is associated with a CHECK clause. [/signinlocker]
Continue reading »

What is the difference between a column-level constraint and a row-level constraint?

QUESTION: What is the difference between a column-level constraint and a row-level constraint?   [signinlocker] SOLUTION   A column-level constraint is imposed on a single column in the table while a row-level constraint is imposed on a set of columns in the table. [/signinlocker]
Continue reading »

What are the minimum elements that must be included in the CREATE TABLE statement in defining the structure of a table?

QUESTION: What are the minimum elements that must be included in the CREATE TABLE statement in defining the structure of a table?   [signinlocker] SOLUTION   The CREATE TABLE statement must contain the table name, the names of the columns in the table, and the...
Continue reading »