67) ________ rules are specifications that preserve the integrity of the logical data model.A) BusinessB) DisjointC) OverlapD) Total specializationAnswer:A Show 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. How many types of business rules are there in conceptual data modeling?There are three types of conceptual, logical, and physical. The main aim of conceptual model is to establish the entities, their attributes, and their relationships.
Is a specification that indicates how many objects participate in a given relationship?Multiplicity defines how many objects participate in a relationship and it is the number of instances of one class related to one instance of the other class. For each association and aggregation, there are two multiplicity decisions to make, one for each end of the relationship.
What is a logical grouping of attributes?A variable is a logical set of attributes.
Which of the following addresses the rules concerning the relationships between entity types?Referential integrity constraints are rules concerning the relationships between entity types.
|
Rules are specifications that preserve the integrity of the logical data model
zusammenhängende Posts
Urheberrechte © © 2024 paraquee Inc.
