Copy and Edit

Chapter 5 (True/False)

Description

asdf Quiz on Chapter 5 (True/False), created by . . on 15/09/2016.
. .
Quiz by . ., updated more than 1 year ago
. .
Created by . . over 7 years ago
57
2
0

Resource summary

Question 1

Question
1. The entity super type contains the common characteristics and the entity subtypes contain the unique characteristics of each entity subtype.
Answer
  • True
  • False

Question 2

Question
2. Entity super types and subtypes are organized in a specialization hierarchy.
Answer
  • True
  • False

Question 3

Question
3. The relationships depicted within the specialization hierarchy are sometimes described in terms of “is-a” relationships.
Answer
  • True
  • False

Question 4

Question
4. Within a specialization hierarchy, a super type can exist only within the context of a subtype.
Answer
  • True
  • False

Question 5

Question
5. One important inheritance characteristic is that all entity subtypes inherit their primary key attribute from their super type.
Answer
  • True
  • False

Question 6

Question
6. At the implementation level, the super type and its subtype(s) depicted in the specialization hierarchy maintain a 1:1 relationship.
Answer
  • True
  • False

Question 7

Question
7. Entity subtypes do not inherit the relationships in which the super type entity participates.
Answer
  • True
  • False

Question 8

Question
8. In specialization hierarchies with multiple levels of super type/subtypes, a lower-level super type inherits all of the attributes and relationships from all of its upper-level subtypes.
Answer
  • True
  • False

Question 9

Question
9. The property of subtype discriminator enables an entity super type to inherit the attributes and relationships of the subtype.
Answer
  • True
  • False

Question 10

Question
10. An entity super type can have disjoint or overlapping entity subtypes
Answer
  • True
  • False

Question 11

Question
11. Disjoint subtypes are subtypes that contain non unique subsets of the super type entity set.
Answer
  • True
  • False

Question 12

Question
12. Overlapping subtypes are subtypes that contain a unique subset of the super type entity set
Answer
  • True
  • False

Question 13

Question
13. Implementing non-overlapping subtypes requires the use of one discriminator attribute for each subtype.
Answer
  • True
  • False

Question 14

Question
14. The completeness constraint can be partial or total.
Answer
  • True
  • False

Question 15

Question
15. Specialization is the top-down process of identifying lower-level, more specific entity subtypes from a higher-level entity super type.
Answer
  • True
  • False

Question 16

Question
16. Generalization is based on grouping unique characteristics and relationships of the subtypes.
Answer
  • True
  • False

Question 17

Question
17. An entity cluster is a "virtual" entity type used to represent multiple entities and relationships in the ERD.
Answer
  • True
  • False

Question 18

Question
18. To model time-variant data, you must create a new entity in a M:N relationship with the original entity.
Answer
  • True
  • False

Question 19

Question
19. A design trap occurs when a relationship is improperly or incompletely identified and is therefore represented in a way that is not consistent with the real world.
Answer
  • True
  • False

Question 20

Question
20. Some designs use redundant relationships as a way to simplify the design.
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
Sean doce balines (a,b,c,d,e,f,g,h,i,j,k,l)
andres parra
Effective Citizens
Lauren Petrouleas
asdfas
bevan7
Funciones Polinomiales
Julieta Maya
10.THE VALUATION PROCESS AND PRICING PROPERTIES
Brigita Safyra
S C I E X
guohao.lam
Perspectives of learning
nilemon
Mind Idea
rodrigo.cespedes
Browse Library