Data Models into Database Designs Which is not true about surrogate keys? They are fixed. They have meaning to the user. They are short. They are numeric. They are fixed. They have meaning to the user. They are short. They are numeric. 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. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table? A range constraint An intrarelation constraint An interrelation constraint A domain constraint A range constraint An intrarelation constraint An interrelation constraint A domain constraint ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A primary key should be defined as: Either of the above can be used. NULL. None of these NOT NULL. Either of the above can be used. NULL. None of these NOT NULL. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Cascading updates refers to child rows being automatically deleted when a parent row is deleted. 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 a foreign key any alternate key a surrogate key the primary key a foreign key any alternate key a surrogate key ANSWER DOWNLOAD EXAMIANS APP