Data Models into Database Designs A primary key should be defined as: NOT NULL. None of these Either of the above can be used. NULL. NOT NULL. None of these Either of the above can be used. NULL. 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 contain a monetary value that is less than another monetary value in the same row? Data constraints Null status Default value Data type Data constraints Null status Default value Data type ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Intersection tables are ID-dependent on both their parent tables. 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. a foreign key a surrogate key any alternate key the primary key a foreign key a surrogate key any alternate key the primary key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs For every relationship, how many possible sets of minimum cardinalities are there? Six Three Two Four Six Three Two Four ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following situation requires the use of ID-dependent entities? Association relationships only Multivalued attributes only All of these Archetype/instance relationships only Association relationships only Multivalued attributes only All of these Archetype/instance relationships only ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS