Which of the following situation requires the use of ID-dependent entities? Association relationships only Archetype/instance relationships only Multivalued attributes only All of these TRUE ANSWER : ? YOUR ANSWER : ?
In a 1:1 relationship, the foreign key is placed in: the parent table. the child table. either the parent table or the child table. either table without specifying parent and child tables. TRUE ANSWER : ? YOUR ANSWER : ?
Intersection tables are ID-dependent on both their parent tables. True False TRUE ANSWER : ? YOUR ANSWER : ?
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? Data constraints Data type Null status Default value TRUE ANSWER : ? YOUR ANSWER : ?
The terms alternate key and candidate key mean the same thing. True False TRUE ANSWER : ? YOUR ANSWER : ?
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 child table. the parent table. TRUE ANSWER : ? YOUR ANSWER : ?
When transforming an entity-relationship model into a relational database design, each entity is represented as a table. False True TRUE ANSWER : ? YOUR ANSWER : ?
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 domain constraint An interrelation constraint An intrarelation constraint A range constraint TRUE ANSWER : ? YOUR ANSWER : ?
Which is not true about surrogate keys? They are numeric. They have meaning to the user. They are short. They are fixed. TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values? An interrelation constraint A range constraint A domain constraint An intrarelation constraint TRUE ANSWER : ? YOUR ANSWER : ?