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 . . over 7 years ago
98
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
10.THE VALUATION PROCESS AND PRICING PROPERTIES
Brigita Safyra
Effective Citizens
Lauren Petrouleas
asdfas
bevan7
Funciones Polinomiales
Julieta Maya
S C I E X
guohao.lam
Perspectives of learning
nilemon
Mind Idea
rodrigo.cespedes
Sean doce balines (a,b,c,d,e,f,g,h,i,j,k,l)
andres parra
Browse Library