Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
88 Cards in this Set
- Front
- Back
1) A data model is a plan for a database design. |
Answer: TRUE
|
|
2) The method of constructing data models used in the text is the extended entity-relationship (E-R) model.
|
Answer: TRUE
|
|
3) An entity is something that users want to track.
|
Answer: TRUE
|
|
4) Entities of a given type are grouped into entity classes.
|
Answer: TRUE
|
|
5) An entity class is described by the structure of the entities in that class.
|
Answer: TRUE
|
|
6) An entity instance is the occurrence of a particular entity.
|
Answer: TRUE
|
|
7) An entity instance of an entity class is the representation of a particular entity and is described by the values of the attributes of the entity.
|
Answer: TRUE
|
|
8) An identifier of an entity instance is one or more attributes that name or identify entity instances.
|
Answer: TRUE
|
|
9) A compound identifier is an identifier consisting of two or more attributes.
|
Answer: FALSE
|
|
10) In E-R modeling, an attribute describes the characteristics of an entity.
|
Answer: TRUE
|
|
11) In E-R modeling, entities within an entity class may have different attributes.
|
Answer: FALSE
|
|
12) An identifier of an entity instance must consist of one and only one attribute.
|
Answer: FALSE
|
|
13) A composite identifier is defined as a composite attribute that is an identifier.
|
Answer: FALSE
|
|
14) An identifier serves the same role for a table that a key does for an entity.
|
Answer: FALSE
|
|
15) Entities can be associated with one another in relationships.
|
Answer: TRUE
|
|
16) The degree of a relationship is the number of entity classes in the relationship.
|
Answer: TRUE
|
|
17) A binary relationship is a relationship between two or more entities.
|
Answer: FALSE
|
|
18) Relationships of degree two are referred to as binary relationships.
|
Answer: TRUE
|
|
19) E-R modeling recognizes both relationship classes and relationship instances.
|
Answer: TRUE
|
|
20) In today's E-R models, attributes of relationships are still used.
|
Answer: FALSE
|
|
21) A single relationship class involves only one entity class.
|
Answer: FALSE
|
|
22) A binary relationship is a relationship based on numerical entity instance identifiers.
|
Answer: FALSE
|
|
23) The degree of a relationship is expressed as the relationship's maximum cardinality.
|
Answer: FALSE
|
|
24) When transforming a data model into a relational design, relationships of all degrees are treated as combinations of binary relationships.
|
Answer: TRUE
|
|
25) The principal difference between an entity and a table is that you can express a relationship between entities without using foreign keys.
|
Answer: TRUE
|
|
26) When designing a database, first identify the entities, then determine the attributes, and finally create the relationships.
|
Answer: FALSE
|
|
27) The notation 1:N shows the relationship's maximum cardinality.
|
Answer: TRUE
|
|
28) Relationships are classified by their cardinality.
|
Answer: TRUE
|
|
29) A relationship's maximum cardinality indicates the maximum number of entities that can participate in the relationship.
|
Answer: FALSE
|
|
30) In an E-R model, the three types of maximum cardinality are 1:1, 1:N and N:M.
|
Answer: TRUE
|
|
31) In a 1:N relationship, the term parent refers to the N side of the relationship.
|
Answer: FALSE
|
|
32) In a 1:N relationship, the parent entity is on the one side of the relationship, and the child entity is on the many side of the relationship.
|
Answer: TRUE
|
|
33) A relationship's minimum cardinality indicates the number of entity instances that must participate in the relationship.
|
Answer: TRUE
|
|
34) A relationship's minimum cardinality indicates whether or not an entity must participate in the relationship.
|
Answer: TRUE
|
|
35) In an E-R model, the three types of minimum cardinality are mandatory, optional and indeterminate.
|
Answer: FALSE
|
|
36) An entity that represents something that can exist on its own is called a strong entity.
|
Answer: TRUE
|
|
37) E-R models use an identifying relationship to connect entities that are ID-dependent.
|
Answer: TRUE
|
|
38) An ID-dependent entity is an entity whose identifier includes the identifier of another entity.
|
Answer: TRUE
|
|
39) ID-dependent entities are associated by a nonidentifying relationship.
|
Answer: FALSE
|
|
40) A weak entity is an entity that cannot exist in the database without (and is logically dependent upon) another type of entity also existing in the database.
|
Answer: TRUE
|
|
41) ID-dependent entities are a common type of weak entity.
|
Answer: TRUE
|
|
42) All weak entities must have a minimum cardinality of 1 on the entity on which it depends.
|
Answer: TRUE
|
|
43) Subtype entities contain only attributes unique to the subtypes.
|
Answer: TRUE
|
|
44) An attribute that determines which subtype is appropriate is called a discriminator.
|
Answer: TRUE
|
|
45) An exclusive subtype pattern has one supertype entity that relates to one or more subtype entities.
|
Answer: FALSE
|
|
46) Entities with an IS-A relationship should have the same identifier.
|
Answer: TRUE
|
|
47) One example of a database design using an ID-dependent relationship is the association pattern.
|
Answer: TRUE
|
|
48) One example of a database design using a strong relationship is the multivalued attribute pattern.
|
Answer: FALSE
|
|
49) One example of a database design using an ID-dependent relationship is the archetype/instance pattern.
|
Answer: TRUE
|
|
50) Data modelers agree that weak, non-ID-dependent entities exist and are important.
|
Answer: FALSE
|
|
51) Entities containing optional sets of attributes are often represented using subtypes.
|
Answer: FALSE
|
|
52) The supremetype entity contains the attributes that are common to all subtypes.
|
Answer: FALSE
|
|
53) An attribute that determines which subtype is appropriate is called a discriminator.
|
Answer: TRUE
|
|
54) Subtypes can be exclusive or inclusive.
|
Answer: TRUE
|
|
55) Relationships between supertypes and subtypes are called IS-A relationships.
|
Answer: TRUE
|
|
56) Relationships among instances of a single entity class are called redundant relationships.
|
Answer: FALSE
|
|
57) There are three types of recursive relationships: 1:1, 1:N and N:M.
|
Answer: TRUE
|
|
58) Recursive relationships only exist for one-to-one relationships.
|
Answer: FALSE
|
|
59) Which of the following is not a key element of an E-R model?
A) Identifiers B) Entities C) Objects D) Attributes E) Relationships |
Answer: C
|
|
60) Entities of a given type are grouped into an ________.
A) entity class B) entity relationship C) entity instance D) entity attribute E) None of the above. |
Answer: A
|
|
61) The occurrence of a particular entity is called an ________.
A) entity class B) entity relationship C) entity instance D) entity attribute E) None of the above. |
Answer: C
|
|
62) The characteristics of a thing are described by its ________.
A) identifiers B) entities C) objects D) attributes E) relationships |
Answer: D
|
|
63) Attributes may be ________.
A) composite B) element C) multivalued D) A and C E) B and C |
Answer: D
|
|
64) An identifier may be ________.
A) composite B) a single attribute C) a relationship D) A and B E) A, B, and C |
Answer: D
|
|
65) A composite attribute is an attribute that ________.
A) is multivalued B) describes a characteristic of the relationship C) consists of a group of attributes D) is calculated at run-time E) is an identifier |
Answer: C
|
|
66) For a relationship to be considered a binary relationship it must satisfy which of the following conditions?
A) It must involve exactly two entity classes. B) It must have a maximum cardinality of 1:1. C) It must have a maximum cardinality of 1:N. D) A and B E) A and C |
Answer: A
|
|
67) Common variants of the E-R model include:
A) IE Crow's Foot B) IDEF1X C) UML D) A and B E) A, B, and C |
Answer: E
|
|
68) Maximum cardinality refers to ________.
A) the most instances of one entity class that can be involved in a relationship instance with another entity class B) the minimum number of entity classes involved in a relationship C) whether or not an instance of one entity class is required to be related to an instance of another entity class D) whether or not an entity is a weak entity E) None of the above. |
Answer: A
|
|
70) You are given an E-R diagram with two entities, ORDER and CUSTOMER, as shown above, and are asked to draw the relationship between them. If a given customer can place many orders and a given order can be placed by at most one customer, which of the following should be indicated in the relationship symbol between the two entities?
A) 0:1 B) 1:1 C) 1:N D) N:1 E) N:M |
Answer: D
|
|
71) You are given an E-R diagram with two entities, ORDER and CUSTOMER, as shown above, and are asked to draw the relationship between them. If a given customer can place many orders and a given order can be placed by one or more customers, which of the following should be indicated in the relationship symbol between the two entities?
A) 0:1 B) 1:1 C) 1:N D) N:1 E) N:M |
Answer: E
|
|
72) Minimum cardinality refers to ________.
A) the most instances of one entity class that can be involved in a relationship with one instance of another entity class B) the minimum number of entity classes involved in a relationship C) whether or not an instance of one entity class is required to be related to an instance of another entity class D) whether or not an entity is a weak entity E) None of the above. |
Answer: C
|
|
73) In a minimum cardinality, minimums are generally stated as ________.
A) 0 B) 1 C) N D) A or B E) A, B, or C |
Answer: D
|
|
74) A hash mark across the relationship line near an entity indicates ________.
A) a maximum cardinality of "zero" B) a maximum cardinality of "one" C) a minimum cardinality of "optional" D) a minimum cardinality of "required" E) None of the above. |
Answer: D
|
|
75) A circle across the relationship line near an entity indicates ________.
A) a maximum cardinality of "zero" B) a maximum cardinality of "one" C) a minimum cardinality of "optional" D) a minimum cardinality of "required" E) None of the above. |
Answer: C
|
|
77) You are given an E-R diagram with two entities, ORDER and CUSTOMER, as shown above. What does the symbol next to the CUSTOMER entity indicate?
A) A maximum cardinality of "zero" B) A maximum cardinality of "one" C) A minimum cardinality of "optional" D) A minimum cardinality of "required" E) None of the above. |
Answer: D
|
|
78) An entity whose identifier includes the identifier of another entity is a(n) ________.
A) strong entity B) weak entity C) ID-dependent entity D) A and C E) B and C |
Answer: E
|
|
79) An entity whose existence depends on the presence of another entity but whose identifier does not include the identifier of the other entity is a(n) ________.
A) strong entity B) weak entity C) ID-dependent entity D) A and C E) B and C |
Answer: B
|
|
80) Which of the following is considered to be a weak entity?
A) ID-dependent entity B) subtype entity C) association entity D) B and C E) A, B, and C |
Answer: E
|
|
81) An entity that holds specialized attributes that distinguish it from one or more other similar entities is a ________.
A) supertype B) subtype C) discriminator D) A and C E) B and C |
Answer: B
|
|
82) Which of the following is not true about subtype entities?
A) Subtypes may be exclusive. B) The supertype and subtypes will have the same identifier. C) Subtypes are used to avoid a situation in which some attributes are required to be null. D) Subtypes have attributes that are required by the supertype. E) Subtypes can produce a closer-fitting data model. |
Answer: E
|
|
83) An attribute that determines which subtype should be used is a ________.
A) supertype B) subtype C) discriminator D) A and C E) B and C |
Answer: C
|
|
84) Discriminators can be ________.
A) exclusive only B) inclusive only C) decisive only D) A or B E) B or C |
Answer: D
|
|
85) Supertype/subtype entities are said to have a(n) ________ relationship.
A) HAS-A B) IS-A C) recursive D) redundant E) multivalue |
Answer: B
|
|
86) To represent an association pattern in an E-R model, ________.
A) create a new ID-dependent entity with a 1:1 relationship to one other entity B) create a new weak, but not ID-dependent entity with a 1:1 relationship to one other entity C) create a new strong entity with a 1:1 relationship to one other entity D) create a new ID-dependent entity with a 1:N relationship to one of two parent entities E) create a new weak, but not ID-dependent entity with a 1:N relationship to one of two parent entities |
Answer: D
|
|
87) To represent a multivalued attribute in an E-R model, ________.
A) create a new ID-dependent entity with a 1:N relationship B) create a new weak, but not ID-dependent entity with a 1:N relationship C) create a new strong entity with a 1:1 relationship D) create a new ID-dependent entity with a 1:1 relationship E) create a new weak, but not ID-dependent entity with a 1:1 relationship |
Answer: A
|
|
88) To represent an archetype/instance pattern in an E-R model, ________.
A) create a new ID-dependent entity with a 1:N relationship B) create a new weak, but not ID-dependent entity with a 1:N relationship C) create a new strong entity with a 1:1 relationship D) create a new ID-dependent entity with a 1:1 relationship E) create a new weak, but not ID-dependent entity with a 1:1 relationship |
Answer: A
|
|
89) When an entity has a relationship to itself, we have a(n) ________.
A) supertype/subtype relationship B) archetype/instance relationship C) recursive relationship D) A or C E) B or C |
Answer: C
|
|
90) Recursive relationships can have which of the following maximum cardinalities?
A) 1:1 B) 1:N C) N:M D) A or B E) A, B, or C |
Answer: E |