Modern System Analysis and Design Chapter 8
A
The data manipulation operation (insert, delete, or update) that initiates the operation is called a(n): A) event B) user rule C) action D) condition
B
The data modeling perspective that derives the business rules for a data model from an intimate understanding of the nature of the business, rather than from any specific information requirements in screens, reports, or business forms, is referred to as the: A) bottom-up approach B) top-down approach C) overview approach D) business approach
A
The minimum cardinality of a relationship is the minimum number of instances of entity B that may be associated with each instance of entity A. A True B False
D
Which of the following refers to an assertion or rule that governs the validity of data manipulation operations such as insert, update, and delete? A) domains B) referential integrity constraints C) entity integrity D) triggering operations
C
Which of the following specifies that an entity instance can simultaneously be a member of two (or more) subtypes? A) disjoint rule B) partial specialization rule C) overlap rule D) total specialization rule
D
A collection of entities that share common properties or characteristics defines: A) entity occurrence B) entity collection C) entity instance D) entity type
A
A concise statement of the business rule to be enforced by the triggering operation refers to: A) user rule B) event C) condition D) action
B
A plural relationship is a relationship that the data modeler chooses to model as entity type. A True B False
A
A true data entity will have many possible instances, each with a distinguishing characteristic, as well as one or more other descriptive pieces of data. A True B False
A
Book, supplier, and state are entity types. A True B False
B
Business rules are specifications that preserve the integrity of the physical data model. A True B False
B
Conceptual data modeling for an Internet-based electronic commerce application differs significantly from the process followed when analyzing the data needs for other types of applications. A True B False
A
If each employee can have more than one skill, then SKILL is referred to as a: A) multivalued attribute B) gerund C) nonexclusive attribute D) repeating attribute
D
Some systems developers believe that a data model is the most important part of the statement of information system requirements because: A) data rather than processes are the most complex aspects of many modern information systems and thus require a central role in structuring system requirements B) the characteristics of data captured during data modeling are crucial in the design of databases, programs, computer screens, and printed reports C) the characteristics about data are reasonably permanent D) all of the above
D
The primary deliverable from the conceptual modeling step within the analysis phase is a(n): A) state-transition diagram B) context data flow diagram C) decision tree D) E-R diagram
A
Triggering operations are other business rules that protect the validity of attribute values. A True B False
B
Triggers are constraints on valid values for attributes. A True B False
A
Universal data models and industry-specific data models are two types of packaged conceptual data models. A True B False
B
Use a verb or verb phrase to name an entity. A True B False
D
Which of the following addresses the rules concerning the relationships between entity types? A) domains B) entity integrity C) triggering operations D) referential integrity constraints
