Quiz 8: Structuring System Data Requirements
Computing
Q 1Q 1
The most common format used for data modeling is ________ diagramming.
A)Entity-class
B)Entity-object
C)Entity-subject
D)Entity-relationship
Free
Multiple Choice
D
Q 2Q 2
During requirements structuring,a ________ model represents conceptual data requirements for a particular system.
A)Business
B)Project
C)Data
D)Relationship
Free
Multiple Choice
C
Q 3Q 3
A(n)________ data model is a detailed model that captures the overall structure of organizational data that is independent of any database management system or other implementation considerations.
A)Conceptual
B)Physical
C)Logical
D)Entity
Free
Multiple Choice
A
Q 4Q 4
A physical data model is a detailed model that captures the overall structure of organizational data that is independent of any database management system or other implementation considerations.
Free
True False
Q 5Q 5
Conceptual data modeling is not done in parallel with other requirements analysis and structuring steps during systems analysis.
Free
True False
Q 6Q 6
The process of conceptual data modeling begins with developing a conceptual data model for the system being replaced,if a system already exists.This is essential for planning the conversion of the current files or database into the database of the new system.
Free
True False
Q 7Q 7
The primary deliverable from the physical data modeling step within the analysis phase is an E-R diagram.
Free
True False
Q 8Q 8
The other deliverable from conceptual data modeling is a full set of entries about data objects that will be stored in the project dictionary,repository,or data modeling software.
Free
True False
Q 9Q 9
Why do some systems developers believe the data model is the most important part of IS requirements?
Free
Essay
Free
Essay
Q 11Q 11
What unique characteristic(s)distinguish(es)each object from other objects of the same type?
A)Secondary key
B)Primary key
C)Composite key
D)Index
Free
Multiple Choice
Q 12Q 12
On what basis are objects referenced,selected,qualified,sorted,and categorized?
A)Attributes and secondary keys
B)Entities
C)Primary keys
D)Index
Free
Multiple Choice
Q 13Q 13
An ________ model is a detailed,logical representation of the entities,associations,and data elements for an organization or business area.
A)E-D
B)E-O
C)E-R
D)E-A
Free
Multiple Choice
Q 14Q 14
A(n)________ is a person,place,object,event,or concept in the user environment about which the organization wishes to maintain data.
A)Dimension
B)Attribute
C)Object
D)Entity
Free
Multiple Choice
Q 15Q 15
An entity ________ is a collection of entities that share common properties or characteristics.
A)Object
B)Type
C)Subject
D)Relationship
Free
Multiple Choice
Q 16Q 16
Each entity type in an E-R model is given a ________ because it represents a class or set,it is singular.
A)Class
B)Type
C)Name
D)Degree
Free
Multiple Choice
Q 17Q 17
An entity ________ is a single occurrence of an entity type.
A)Instance
B)Object
C)Attribute
D)Class
Free
Multiple Choice
Q 18Q 18
An entity ________ is described just once in a data model,whereas many ________ of that may be represented by data stored in the database.
A)Type; instances
B)Type; classes
C)Instance; types
D)Class; objects
Free
Multiple Choice
Q 19Q 19
A common mistake many people make when they are just learning to draw E-R diagrams,especially if they already know how to do data flow diagramming,is to confuse data entities with ________ and relationships with data flows.
A)Classes
B)Sinks
C)Relationships
D)Attributes
Free
Multiple Choice
Q 20Q 20
Event entity types should be named for the result of the ________,not the activity or process of the event.
A)Event
B)Class
C)Entity
D)Object
Free
Multiple Choice
Q 21Q 21
A(n)________ is a named property or characteristic of an entity that is of interest to the organization.
A)Event
B)Instance
C)Relationship
D)Attribute
Free
Multiple Choice
Q 22Q 22
Similar attributes of different entity types should use ________ but distinguishing names.
A)Similar
B)Different
C)Unique
D)Duplicate
Free
Multiple Choice
Q 23Q 23
A ________ key is an attribute (or combination of attributes)that uniquely identifies each instance of an entity type.
A)Primary
B)Unique
C)Candidate
D)Duplicate
Free
Multiple Choice
Q 24Q 24
A(n)________ is an attribute that may take on more than one value for each entity instance.
A)Multi-valued attribute
B)Single-valued attribute
C)Identifier
D)Candidate key
Free
Multiple Choice
Q 25Q 25
A(n)________ is an attribute that must have a value forevery entity instance.
A)Derived attribute
B)Composite attribute
C)Required attribute
D)Optional attribute
Free
Multiple Choice
Q 26Q 26
A(n)________ is an attribute that may not have a value forevery entity instance.
A)Required attribute
B)Derived attribute
C)Composite attribute
D)Optional attribute
Free
Multiple Choice
Q 27Q 27
A(n)________ is an attribute that has meaningful component parts.
A)Optional attribute
B)Composite attribute
C)Required attribute
D)Derived attribute
Free
Multiple Choice
Q 28Q 28
A(n)________ is an attribute whose value can be computed from related attribute values.
A)Derived attribute
B)Composite attribute
C)Required attribute
D)Optional attribute
Free
Multiple Choice
Q 29Q 29
A(n)________ is an association between the instances of one or more entity types that is of interest to the organization.
A)Attribute
B)Repeating group
C)Relationship
D)Identifier
Free
Multiple Choice
Q 30Q 30
The ________ of a relationship is the number of entity types that participate in that relationship.
A)Object
B)Degree
C)Identifier
D)Measure
Free
Multiple Choice
Q 31Q 31
A unary relationship is a relationship between the instances of ________ entity type(s).
A)One
B)Two
C)Three
D)Five
Free
Multiple Choice
Q 32Q 32
A recursive relationship is also known as a ________ relationship.
A)Binary
B)Ternary
C)Secondary
D)Unary
Free
Multiple Choice
Q 33Q 33
A ________ relationship is a relationship between instances of two entity types and is the most common type of relationship encountered in data modeling.
A)Secondary
B)Binary
C)Primary
D)Ternary
Free
Multiple Choice
Q 34Q 34
A ternary relationship is a simultaneous relationship among instances of ________ entity type(s).
A)One
B)Two
C)Three
D)Ten
Free
Multiple Choice
Q 35Q 35
The ________ defines the number of instances of entity B that can (or must)be associated with each instance of entity A.
A)Cardinality
B)Relationship
C)Identifier
D)Association
Free
Multiple Choice
Q 36Q 36
A(n)________ is an entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances.
A)Relationship
B)Associative entity
C)Identifier
D)Cardinality
Free
Multiple Choice
Free
True False
Free
True False
Q 39Q 39
An entity instance (also known simply as an instance)is a single occurrence of an entity type and is described just once in a data model,whereas many instances of that entity type may be represented by data stored in the database.
Free
True False
Q 40Q 40
Event entity types should be named for the result of the event,not the activity or process of the event.
Free
True False
Q 41Q 41
A state is a named property or characteristic of an entity that is of interest to the organization.
Free
True False
Q 42Q 42
A primary key is an attribute (or combination of attributes)that uniquely identifies each instance of an entity type.
Free
True False
Q 43Q 43
An identifier is a candidate key that has been selected to be used as the unique characteristic for an entity type.
Free
True False
Q 44Q 44
An aggregation is an association between the instances of one or more entity types that is of interest to the organization.
Free
True False
Free
Essay
Q 46Q 46
List at least four requirements for determination questions for data modeling.Include a question and which asset is related to that determination.
Free
Essay
Q 47Q 47
List and explain the following key data modeling terms: entity,attribute,relationship,degree,cardinality,and associative entity.
Free
Essay
Q 48Q 48
A ternary relationship is a relationship between instances of two entity types and is the most common type of relationship encountered in data modeling.
Free
True False
Q 49Q 49
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.
Free
True False
Q 50Q 50
A relationship definition explains what action is being taken and possibly why it is important.It may be important to state who or what does the action,but it is not important to explain how the action is taken.
Free
True False
Q 51Q 51
An entity type that associates the instances of only one type and contains attributes that are peculiar to the relationship between those entity instances.
Free
True False
Q 52Q 52
One situation in which a relationship must be turned into an associative entity is when the associative entity has other relationships with entities besides the relationship that caused its creation.
Free
True False
Free
Essay
Free
Essay
Q 55Q 55
Naming relationships can be difficult.Describe at least three guidelines for naming relationships.
Free
Essay
Q 56Q 56
A ________ is an entity type that is meaningful to the organization and that shares common attributes or relationships distinct from other sub-groupings.
A)Repeating group
B)Multi-valued
C)Super-type
D)Subtype
Free
Multiple Choice
Q 57Q 57
The ________ rule specifies that an entity instance of the super type does not have to belong to any subtype.
A)Total specialization
B)Partial specialization
C)Overlap
D)Disjoint
Free
Multiple Choice
Q 58Q 58
The ________ rule specifies that each entity instance of the super-type must be a member of some subtype of the relationship.
A)Partial specialization
B)Business
C)Overlap
D)Total specialization
Free
Multiple Choice
Q 59Q 59
The ________ rule specifies that if an entity instance of the super type is a member of one subtype,it cannot simultaneously be a member of any other subtype.
A)Business
B)Overlap
C)Disjoint
D)Partial specialization
Free
Multiple Choice
Free
True False
Free
Essay
Q 62Q 62
The ________ rule specifies that an entity instance can simultaneously be a member of two (or more)subtypes.
A)Business
B)Overlap
C)Disjoint
D)Total specialization
Free
Multiple Choice
Q 63Q 63
________ rules are specifications that preserve the integrity of the logical data model.
A)Business
B)Disjoint
C)Overlap
D)Total specialization
Free
Multiple Choice
Q 64Q 64
How many types of business rules are there in conceptual data modeling?
A)One
B)Two
C)Three
D)Four
Free
Multiple Choice
Q 65Q 65
Which business rule specifies that each instance of an entity type must have a unique identifier that is not null?
A)Triggering operations
B)Referential integrity
C)Entity integrity
D)Domains
Free
Multiple Choice
Q 66Q 66
Which business rule specifies the validity of attribute values?
A)Triggering operations
B)Referential integrity
C)Entity integrity
D)Domains
Free
Multiple Choice
Q 67Q 67
Which business rule specifies constraints on valid values for attributes?
A)Triggering operations
B)Referential integrity
C)Entity integrity
D)Domains
Free
Multiple Choice
Q 68Q 68
Which business rule specifies rules concerning the relationships between entity types?
A)Triggering operations
B)Referential integrity constraints
C)Entity integrity
D)Domains
Free
Multiple Choice
Q 69Q 69
A domain is the set of all data types and ranges of values that ________ may assume.
A)Entities
B)Instances
C)Attributes
D)Events
Free
Multiple Choice
Q 70Q 70
A(n)________ is an assertion or rule that governs the validity of data manipulation operations such as insert,update,and delete.
A)Domain
B)Event
C)Referential integrity
D)Triggering operation
Free
Multiple Choice
Q 71Q 71
A(n)________ is a concise statement of the business rule to be enforced by the triggering operation.
A)Event
B)User rule
C)Action
D)Condition
Free
Multiple Choice
Q 72Q 72
A(n)________ is the data manipulation operation (insert,delete,or update)that initiates the operation.
A)Event
B)User rule
C)Action
D)Condition
Free
Multiple Choice
Q 73Q 73
There is/are ________ principal type(s)of packaged data model(s).
A)One
B)Two
C)Three
D)Five
Free
Multiple Choice
Q 74Q 74
The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype,it can simultaneously be a member of any other subtype.
Free
True False
Q 75Q 75
Domain definitions typically specify some (or all)of the following characteristics of attributes: data type,length,format,range,allowable values,meaning,uniqueness,and null support (whether an attribute value may or may not be null).
Free
True False
Q 76Q 76
Projects with purchased models take less time and cost more because the initial discovery steps are no longer necessary,leaving only iterative tailoring and refinement to the local situation.
Free
True False
Free
Essay
Free
Essay
Q 79Q 79
________ data models are generic data models that are designed to be used by organizations within specific industries.
A)Universal
B)Conceptual
C)Logical
D)Industry-specific
Free
Multiple Choice
Q 80Q 80
The term ________ data model means a conceptual data model with some additional properties associated with the most popular type of database technology like relational databases.
A)Universal
B)Physical
C)Logical
D)Industry-specific
Free
Multiple Choice
Q 81Q 81
Which benefit of purchased data models refers to the fact that they are very general,covering almost all options employed by the associated functional area or industry?
A)Consistent and complete
B)Validated
C)Cost reduction
D)Facilitates systems analysis
Free
Multiple Choice
Q 82Q 82
Which benefit of purchased data models provides database planning and analysis by providing a first data model,which we can use to generate specific analysis questions and concrete,not hypothetical or abstract,examples of what might be in the appropriate database?
A)Validated
B)Consistent and complete
C)Cost reduction
D)Facilitates systems analysis
Free
Multiple Choice
Q 83Q 83
A(n)________ has a well-defined role in the application domain,and it has state (data),behavior,and identity characteristics.
A)Event
B)Object
C)Activity
D)Class
Free
Multiple Choice
Q 84Q 84
The ________ of an object encompasses its properties (attributes and relationships)and the values of those properties.
A)State
B)Condition
C)Behavior
D)Event
Free
Multiple Choice
Q 85Q 85
The ________ shows the static structure of an object-oriented model: the object classes,their internal structure,and the relationships in which they participate.
A)Data model
B)Object class
C)Object diagram
D)Class diagram
Free
Multiple Choice
Q 86Q 86
The ________ is a logical grouping of objects that have the same (or similar)attributes,relationships,and behaviors; also called class.
A)Operation
B)Encapsulation
C)Object class
D)Object diagram
Free
Multiple Choice
Q 87Q 87
The ________ is the technique of hiding the internal implementation details of an object from its external view.
A)Query operation
B)Encapsulation
C)Constructor operation
D)Update operation
Free
Multiple Choice
Q 88Q 88
A(n)________ is an operation that does not have any side effects; it accesses the state of an object but does not alter the state.
A)Encapsulation
B)Constructor operation
C)Update operation
D)Query operation
Free
Multiple Choice
Q 89Q 89
A(n)________ is a specification that indicates how many objects participate in a given relationship.
A)Association role
B)Multiplicity
C)Association
D)Object class
Free
Multiple Choice
Q 90Q 90
A(n)________ class is a class that has no direct instances but whose descendants may have direct instances.
A)Abstract
B)Concrete
C)Object
D)Associative
Free
Multiple Choice
Q 91Q 91
A class that can have direct instances (e.g.,Outpatient or Resident Patient)is called a(n)________ class.
A)Object
B)Abstract
C)Associative
D)Concrete
Free
Multiple Choice
Q 92Q 92
A part-of relationship in which parts belong to only one whole object,and the parts live and die with the whole object is called ________.
A)Method
B)Composition
C)Aggregation
D)Polymorphism
Free
Multiple Choice
Q 93Q 93
The fact that the same operation may apply to two or more classes in different ways is known as ________.
A)Aggregation
B)Abstract operation
C)Polymorphism
D)Composition
Free
Multiple Choice
Q 94Q 94
The technique of hiding the internal implementation details of an object from its external view is known as encapsulation.
Free
True False
Q 95Q 95
Operations can be classified into four types,depending on the kind of service requested by clients.
Free
True False
Free
Essay