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 8 years ago
88
2
0
1 2 3 4 5 (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

0 comments

There are no comments, be the first and leave one below:

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

Similar

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
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