Copyright © 2019 Pearson Education, Inc.
Database Processing, 15e (Kroenke)
Appendix F: The Semantic Object Model
1) Whether a developer uses an E-R model or a semantic object model, the eventual database
design that is created should be exactly the same.
Answer: FALSE
2) Semantic objects represent the user’s perceptions more closely than the E-R model.
Answer: TRUE
3) Semantic objects represent distinct identities.
Answer: TRUE
4) A semantic object must represent something with a physical existence.
Answer: FALSE
5) A simple attribute has only one element.
Answer: TRUE
6) The cardinalities of an attribute operate only between the attribute and the container of the
attribute.
Answer: TRUE
Copyright © 2019 Pearson Education, Inc.
7) Group attributes are composites of other attributes.
Answer: TRUE
8) An object identifier is one or more attributes that the users employ to identify object instances.
Answer: TRUE
9) Object identifiers may or may not be unique.
Answer: TRUE
10) The key of an attribute is a description of an attribute’s possible values.
Answer: FALSE
11) A “simple object” can contain only simple attributes.
Answer: TRUE
12) A “composite object” cannot contain more than one multivalued attribute.
Answer: FALSE
Copyright © 2019 Pearson Education, Inc.
13) A “hybrid object” is a semantic object that relates two or more objects and stores data that
are peculiar to that relationship.
Answer: FALSE
14) An association object relates two (or more) objects and stores data that are peculiar to that
relationship.
Answer: TRUE
15) The first attribute of a subtype object is the childID attribute.
Answer: FALSE
16) A subtype inherits all the attributes of its parent.
Answer: TRUE
17) The term semantic means ________.
A) meaning
B) data
C) detailed
D) attribute
Answer: A
Copyright © 2019 Pearson Education, Inc.
18) Semantic objects are grouped into ________.
A) composites
B) entities
C) objects
D) classes
Answer: D
19) What type of attribute has a single element?
A) Single
B) Simple
C) Link
D) Compound
Answer: B
20) What type of attribute is composed of other attributes?
A) Simple
B) Group
C) Compound
D) Composite
Answer: B
21) A group identifier ________.
A) has more than one attribute
B) identifies a group of instances
C) identifies a group of attributes in an object
D) is the identifier for a group of semantic objects
Answer: A
Copyright © 2019 Pearson Education, Inc.
22) A simple object is a semantic object that contains only ________.
A) single-value, simple or group attributes
B) single-value, object attributes
C) single-value, simple attributes
D) multi-value, simple or group attributes
Answer: A
23) A composite object is a semantic object that contains ________.
A) single-value, simple or group attributes, but no object attributes
B) at least one object attribute
C) at least one multi-value, simple or group attribute but no object attributes
D) at least one multi-value, object attribute
Answer: C
24) A compound object is a semantic object that contains at least one ________.
A) single-value, group attribute
B) multi-value, simple or group attribute
C) object attribute
D) multi-value attribute
Answer: C
25) A hybrid object is a semantic object that contains at least one ________.
A) single-value group attribute that includes a multi-value semantic object attribute
B) single-value group attribute that includes any semantic object attribute
C) multiple-value group attribute that includes a multi-value semantic object attribute
D) multiple-value group attribute that includes any semantic object attribute
Answer: D
Copyright © 2019 Pearson Education, Inc.
26) A parent object is also known as a(n) ________.
A) supertype object
B) child object
C) subtype object
D) multiple-value object
Answer: A
27) The relationship between a parent object and its associated subtype objects is a(n) ________.
A) HAS-A relationship
B) WANTS-A relationship
C) NEEDS-A relationship
D) IS-A relationship
Answer: D
28) Which of the following statements about Subtype objects is not true?
A) Subtypes can be Inclusive (an object may be more than one subtype).
B) Subtypes can be Exclusive (an object may only be one of the subtypes).
C) Subtypes can be Nested.
D) All relations between the parent and subtype are 1:N.
Answer: D
29) A version object ________.
A) may be a composite object
B) typically contains the archetype object in its identifier
C) is typically a simple object
D) produces archetype objects
Answer: B
Copyright © 2019 Pearson Education, Inc.
30) Semantic objects are said to be ________.
A) Semantically self-contained
B) Semantically complete
C) Semantically inclusive
D) Both A and B are correct
Answer: D
31) Explain the concept of semantic objects as being a sufficient description.
Answer: A semantic object is said to be a sufficient description because: (1) it contains all the
32) Explain why semantic object attributes are called paired attributes.
Answer: Semantic object attributes are used to indicate a relationship between two semantic
33) Distinguish between the physical description and the semantic description of an attribute
domain.
Answer: The physical description of an attribute defines the data type, data length, and other
Copyright © 2019 Pearson Education, Inc.
34) Describe the two ways that semantic object views can be used.
Answer: A semantic view can be used: (1) during database design to reverse-engineer a data
35) Explain the differences between the E-R model and the semantic object model.
Answer: The primary differences between the E-R model and the semantic object model are