Data Models into Database Designs In a 1:N relationship, the foreign key is placed in: 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. the child table. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Each entity is represented as a(n): attribute. tuple. file. table. attribute. tuple. file. table. 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): composite key. surrogate key. foreign key. primary key. composite key. surrogate key. foreign key. primary key. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which is not true about surrogate keys? They are fixed. They are numeric. They have meaning to the user. They are short. They are fixed. They are numeric. They have meaning to the user. They are short. 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. any alternate key a foreign key the primary key a surrogate key any alternate key a foreign key the primary key a surrogate key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs An intersection table is required to represent M:N relationships. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS