Data Models into Database Designs Each entity is represented as a(n): tuple. file. attribute. table. tuple. file. attribute. table. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000? Data constraints Null status Data type Default value Data constraints Null status Data type Default value 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): foreign key. primary key. surrogate key. composite key. foreign key. primary key. surrogate key. composite key. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs An ideal primary key is short, numeric and seldom changing. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value. the primary key any alternate key a surrogate key a foreign key the primary key any alternate key a surrogate key a foreign 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
EXAMIANS