I have five E-R model questions: Question 24 1. When converting an E-R model to
ID: 3730666 • Letter: I
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 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
A.
many-to-many
B.
many-to-one
C.
one-to-many
D.
one-to-one
Explanation / Answer
1.
Option B
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 many-to-one
2.
Option A
In the E-R model, an attribute that can be broken down into smaller attributes is called composite attribute.
3.
Option A
completeness constraints tell us whether a specialization
4.
Option D
An entity set is related to itself, we have a Recursive relationship.
5.
Option D
In the relational model, the table in which a foreign key appears as the primary key is called its foreign relation.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.