Questão 1
Questão
1) An ERM is dependent on the database type.
Questão 2
Questão
2) The word “entity” in the ER model corresponds to a table.
Questão 3
Questão
3) The Crow’s Foot model is less implementation-oriented than the Chen model.
Questão 4
Questão
4) The ER diagram represents the conceptual database as viewed by the end user.
Questão 5
Questão
5) The ER model refers to a specific table row as an entity instance.
Questão 6
Questão
6) In both the Chen and Crow’s Foot models, an entity is represented with a rectangle containing the entity’s name.
Questão 7
Questão
7) The ER model refers to a specific table row as an entity occurrence.
Questão 8
Questão
8) Attributes are types of entities.
Questão 9
Questão
9) In the original Chen model, each attribute is represented using an oval with the
attribute name connected to the entity with a line.
Questão 10
Questão
10. Software vendors have adopted the Chen representation because of its compact
representation.
Questão 11
Questão
11) Attributes have a domain that specifies the data type of the attribute.
Questão 12
Questão
12) Attributes cannot share a domain.
Questão 13
Questão
13) In an ER diagram, primary keys are usually bolded.
Questão 14
Questão
14. Ideally, a primary key is composed of several attributes.
Questão 15
Questão
15. A composite identifier is a primary key composed of more than one attribute.
Questão 16
Questão
16. All attributes are either simple or composite.
Questão 17
Questão
17) All simple attributes are also single-valued.
Questão 18
Questão
18) In the Chen model, a multivalued attribute is connected to the owning entity
with a double line.
Questão 19
Questão
19) The DBMS can easily handle multivalued attributes.
Questão 20
Questão
20) Derived attributes are stored in a special database table.
Questão 21
Questão
21) A relationship is identified by a name that describes the relationship.
Questão 22
Questão
22) Cardinality expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.
Questão 23
Questão
23) In Chen notation, there is no way to represent cardinality.
Questão 24
Questão
24) Connectivities and cardinalities are established by business rules.
Questão 25
Questão
25) A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.
Questão 26
Questão
26) You should always load data from the 1 side of a 1:M relationship.
Questão 27
Questão
27) A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship
Questão 28
Questão
28. The existence of a mandatory relationship indicates that the minimum cardinality is 0 or 1 for the mandatory entity.
Questão 29
Questão
29) Relationships operate only in one direction.
Questão 30
Questão
30. A recursive relationship is one in which a relationship can exist between occurrences of the same entity set