Data Models into Database Designs Which of the following column properties specifies whether or not cells in a column must contain a data value? Default value Data constraints Null status Data type Default value Data constraints Null status Data type ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The identifier of an entity will become the ________ of the new table. primary key identity key main attribute foreign key primary key identity key main attribute foreign key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table? A range constraint An intrarelation constraint A domain constraint An interrelation constraint A range constraint An intrarelation constraint A domain constraint An interrelation constraint ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The terms alternate key and candidate key mean the same thing. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n): primary key. composite key. foreign key. surrogate key. primary key. composite key. foreign key. surrogate key. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The DBMS allows surrogate keys to be changed. True False True False ANSWER DOWNLOAD EXAMIANS APP