Question: I have five E-R model questions: Question 24 1. When converting an E-R model to a relational model, the table for a binary relationship can
I have five E-R model questions:
Question 24
1. When converting an E-R model to a relational model, the table for a binary relationship can be replaced by a foreign key provided the relationship is not
|
| A. | many-to-many |
|
| B. | many-to-one |
|
| C. | one-to-many |
|
| D. | one-to-one |
0.5 points
Question 31
1. In the E-R model, an attribute that can be broken down into smaller attributes is called
|
| A. | composite |
|
| B. | null |
|
| C. | a superattribute |
|
| D. | derived |
0.5 points
Question 34
1. In the EE-R model, completeness constraints tell us whether a specialization is
|
| A. | total or partial |
|
| B. | union or category |
|
| C. | disjoint or overlapping |
|
| D. | predicate-defined or user-defined |
0.5 points
Question 38
1. When an entity set is related to itself, we have a _______ relationship.
|
| A. | extended |
|
| B. | optional |
|
| C. | mandatory |
|
| D. | recursive |
0.5 points
Question 39
1. In the relational model, the table in which a foreign key appears as the primary key is called its
|
| A. | root relation |
|
| B. | home relation |
|
| C. | child relation |
|
| D. | foreign relation |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
