Copy and Edit

Chapter 4 (True/False)

Description

asdf Quiz on Chapter 4 (True/False), created by . . on 08/09/2016.
. .
Quiz by . ., updated more than 1 year ago
. .
Created by . . almost 8 years ago
158
2
0

Resource summary

Question 1

Question
1) An ERM is dependent on the database type.
Answer
  • True
  • False

Question 2

Question
2) The word “entity” in the ER model corresponds to a table.
Answer
  • True
  • False

Question 3

Question
3) The Crow’s Foot model is less implementation-oriented than the Chen model.
Answer
  • True
  • False

Question 4

Question
4) The ER diagram represents the conceptual database as viewed by the end user.
Answer
  • True
  • False

Question 5

Question
5) The ER model refers to a specific table row as an entity instance.
Answer
  • True
  • False

Question 6

Question
6) In both the Chen and Crow’s Foot models, an entity is represented with a rectangle containing the entity’s name.
Answer
  • True
  • False

Question 7

Question
7) The ER model refers to a specific table row as an entity occurrence.
Answer
  • True
  • False

Question 8

Question
8) Attributes are types of entities.
Answer
  • True
  • False

Question 9

Question
9) In the original Chen model, each attribute is represented using an oval with the attribute name connected to the entity with a line.
Answer
  • True
  • False

Question 10

Question
10. Software vendors have adopted the Chen representation because of its compact representation.
Answer
  • True
  • False

Question 11

Question
11) Attributes have a domain that specifies the data type of the attribute.
Answer
  • True
  • False

Question 12

Question
12) Attributes cannot share a domain.
Answer
  • True
  • False

Question 13

Question
13) In an ER diagram, primary keys are usually bolded.
Answer
  • True
  • False

Question 14

Question
14. Ideally, a primary key is composed of several attributes.
Answer
  • True
  • False

Question 15

Question
15. A composite identifier is a primary key composed of more than one attribute.
Answer
  • True
  • False

Question 16

Question
16. All attributes are either simple or composite.
Answer
  • True
  • False

Question 17

Question
17) All simple attributes are also single-valued.
Answer
  • True
  • False

Question 18

Question
18) In the Chen model, a multivalued attribute is connected to the owning entity with a double line.
Answer
  • True
  • False

Question 19

Question
19) The DBMS can easily handle multivalued attributes.
Answer
  • True
  • False

Question 20

Question
20) Derived attributes are stored in a special database table.
Answer
  • True
  • False

Question 21

Question
21) A relationship is identified by a name that describes the relationship.
Answer
  • True
  • False

Question 22

Question
22) Cardinality expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.
Answer
  • True
  • False

Question 23

Question
23) In Chen notation, there is no way to represent cardinality.
Answer
  • True
  • False

Question 24

Question
24) Connectivities and cardinalities are established by business rules.
Answer
  • True
  • False

Question 25

Question
25) A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.
Answer
  • True
  • False

Question 26

Question
26) You should always load data from the 1 side of a 1:M relationship.
Answer
  • True
  • False

Question 27

Question
27) A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship
Answer
  • True
  • False

Question 28

Question
28. The existence of a mandatory relationship indicates that the minimum cardinality is 0 or 1 for the mandatory entity.
Answer
  • True
  • False

Question 29

Question
29) Relationships operate only in one direction.
Answer
  • True
  • False

Question 30

Question
30. A recursive relationship is one in which a relationship can exist between occurrences of the same entity set
Answer
  • True
  • False
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

El Perdón
Alonso Linares
Investiga las transformaciones de la cultura y de la vida cotidiana a lo largo del tiempo.
Sherlyn Muñoz
Irene
i.biza
Funciones Polinomiales
Julieta Maya
10.THE VALUATION PROCESS AND PRICING PROPERTIES
Brigita Safyra
Effective Citizens
Lauren Petrouleas
asdfas
bevan7
Sean doce balines (a,b,c,d,e,f,g,h,i,j,k,l)
andres parra
S C I E X
guohao.lam
Perspectives of learning
nilemon
Mind Idea
rodrigo.cespedes
Browse Library