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 When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs An intersection table is required to represent M:N relationships. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs In a 1:1 relationship, the primary key placement is arbitrary. False True False True 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? Default value Data constraints Data type Null status Default value Data constraints Data type Null status ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A primary key should be defined as: None of these Either of the above can be used. NOT NULL. NULL. None of these Either of the above can be used. NOT NULL. NULL. ANSWER DOWNLOAD EXAMIANS APP