Data Models into Database Designs Which of the following column properties would be used to specify that cells in a column must contain a monetary value? Data type Null status Default value Data constraints Data type Null status Default value Data constraints ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs When transforming an entity-relationship model into a relational database design, each entity is represented as a table. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The DBMS allows surrogate keys to be changed. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs In a 1:N relationship, the foreign key is placed in: the child table. either table without specifying parent and child tables. either the parent table or the child table. the parent table. the child table. either table without specifying parent and child tables. either the parent table or the child table. the parent table. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The identifier of an entity will become the ________ of the new table. main attribute primary key identity key foreign key main attribute primary key identity key foreign key 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. a surrogate key a foreign key the primary key any alternate key a surrogate key a foreign key the primary key any alternate key ANSWER DOWNLOAD EXAMIANS APP