MIS 3301 Ch 8
One of the benefits of starting with and then tailoring a purchased data model is ___.
Anticipation of future requirements
A ___ relationship is a relationship between instances of two entity types.
Binary
32. Sometimes a combination of attribute is required to identify a unique entity. In this case, A ___ should be used.
Candidate Key
34. 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:
Composition
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.
Construction Operation
Which of the following is a reason some developers believe a data model is the most important part of the information systems requirement?
Data captured during data modeling is crucial to the design of the computer screen.
All of the following are advantages to incorporating business rules in the repository except:
Does not promote ease of use of a database
Which of the following is an advantage of the use of domains?
Domains ensure data manipulation operations are logical
The ____ is the technique of hiding the internal implementation details of an object from its external view.
Encapsulation
An ____ is the data manipulation operation (insert, delete, or update) that initiates the operation.
Event
31. 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?
Facilitates system analysis
Karen is creating an E-R model. Skill is one of the attributes of worker. But a worker can have more than one skill, therefore Karen knows this is a
Multivalued attributes
The ____ is a logical grouping of objects that have the same (or similar) attributes, relationships, and behaviors; also called class.
Object class
The ____ rule specifies that an entity instance of the supertype does not have to belong to any subtype
Partial Specialization
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.
Query operation
A ___ is a simultaneous relationship among instances of three entity types.
Ternary
What is the purpose of a conceptual data model?
To show as many rules about the meaning and interrelationships among data as are possible
33. Peter had to correct an E-R model because an entity instance of the supertype was not a member of some subtype in the relationship. The E-R model broke the ___ rule
Total Specialization
A ____ is an assertion or rule that governs the validity of data manipulation operations such as insert, update, and delete.
Triggering Operation
Which business rule specifies the validity of attribute values?
Triggering operations
All of the following are business rules except
Unary Relationship
In an entity relationship diagram if one person may only be married to one other person, the relationship is a
Unary relationship
35. A(n) ____ is a concise statement of the business rule to be enforced by the triggering operation.
User Rule
If a purchase model is proven through extensive experience it is said to be:
Validated
The ___ of a relationship is the number of entity types that participate in that relationship.
degree
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
disjoint
Which business rule specifies that each instance of an entity type must have a unique identifier that is not null?
entity integrity
The ____ rule specifies that an entity instance can simultaneously be a member of two (or more) subtypes.
overlap
A ____ is an entity type that is meaningful to the organization and that shares common attributes or relationships distinct from other sub-groupings.
subtype
