67) ________ rules are specifications that preserve the integrity of the logical data model.A) BusinessB) DisjointC) OverlapD) Total specializationAnswer:A
68) How many types of business rules are there in conceptual data modeling?D
69) Which business rule specifies that each instance of an entity type must have a uniqueidentifier that is not null?C
70) Which business rule specifies the validity of attribute values?A
71) Which business rule specifies constraints on valid values for attributes?A) Triggering operationsB) Referential integrityC) Entity integrityD) DomainsAnswer:D
72) Which business rule specifies rules concerning the relationships between entity types?B
73) A domain is the set of all data types and ranges of values that ________ may assume.C
74) A(n) ________ is an assertion or rule that governs the validity of data manipulationoperations such as insert, update, and delete.D
75) A(n) ________ is a concise statement of the business rule to be enforced by the triggeringoperation.A) EventB) User ruleC) ActionD) ConditionAnswer:B
76) A(n) ________ is the data manipulation operation (insert, delete, or update) that initiates theoperation.
C) ActionD) ConditionAnswer:A77) There is/are ________ principal type(s) of packaged data model(s).B
78) The disjoint rule specifies that if an entity instance of the supertype is a member of onesubtype, it can simultaneously be a member of any other subtype.
79) Domain definitions typically specify some (or all) of the following characteristics ofattributes: data type, length, format, range, allowable values, meaning, uniqueness, and nullsupport (whether an attribute value may or may not be null).
80) Projects with purchased models take less time and cost more because the initial discoverysteps are no longer necessary, leaving only iterative tailoring and refinement to the localsituation.
81) Define domains for the following attributes: Account number.
82) Define triggering operation. Provide an example and include the components.
92.Specifications that preserve the integrity of the logical data model are:a.requirements specificationsb.integrity restrictionsc.business limitationsd.business rulesAnswer: dDifficulty: MedReference:p. 328
93.Which of the following addresses the rules concerning the relationships between entity types?Difficulty: MedReference:p. 328
94.Which of the following specifies that each instance of an entity type must have a unique identifier thatis not null?Difficulty: HardReference:p. 328
95.Which of the following are constraints on valid values for attributes?Difficulty: MedReference:p. 328
96.Which of the following protects the validity of attribute values?a.referential integrity constraintsb.triggering operationsc.entity integrityd.domainsAnswer: bDifficulty: HardReference:p. 328
231Structuring System Requirements:Conceptual Data Modeling97.The set of all data types and ranges of values that an attribute can assume defines:Difficulty: MedReference:p. 329
98.An assertion or rule that governs the validity of data manipulation operations such as insert, update,and delete is:Difficulty: MedReference:p. 329
99.The data manipulation operation (insert, delete, or update) that initiates the operation is called a(n):Difficulty: HardReference:p. 329
100.A concise statement of the business rule to be enforced by the triggering operation refers to:a.user ruleb.conditionc.actiond.eventAnswer: aDifficulty: HardReference:p. 329
Fill In the Blanks101.Aconceptual data modelis a detailed model that shows the overall structure of organizational datawhile being independent of any database management system or other implementation considerations.Difficulty: MedReference:p. 306102.Anentity-relationship diagramis a detailed, logical, and graphical representation of the entities,associations, and data elements for an organization or business area.Difficulty: MedReference:p. 311
Chapter 10Structuring System Requirements:Conceptual Data Modeling232103.Anentity-relationship data modelis a detailed, logical representation of the entities, associations, anddata elements for an organization or business area.Difficulty: MedReference:p. 311104.Anentity typeis a collection of entities that share common properties or characteristics.Difficulty: MedReference:p. 311105.Anentity instanceis a single occurrence of an entity type.Difficulty: MedReference:p. 312106.Anattributeis a named property or characteristic of an entity that is of interest to the organization.