mis exam 3

all of the following are guidelines for choosing indexes for relational databases except _.

-specify multiple keys for each table

Which business rule specifies the validity of attribute values?A) Triggering operationsB) Referential integrityC) Entity integrityD) Domains

A) Triggering Options

Similar attributes of different entity types should use ________ but distinguishing names.A) SimilarB) DifferentC) UniqueD) Duplicate

A) similar

A unary relationship is a relationship between the instances of ________ entity type(s).

A.One

A(n) _ diagram shows the conditional logic for the sequence of system activities needed to accomplish a business process

Activity diagram

Violations of DFD drawing rules can produce _.

An audit

Which relation is created with a composite primary key using the primary keys of the related entities and additional primary key attributes associated with the relationship or associative entity. Plus any non-key attributes of the relationship or associative entity?

Associative entity with additional key

which relation is created with the primary key associated with the relationship or associative entity, plus any nonkey attributes of the relationship or associative entity and the primary keys of the related entites (as foreign key attributes)

Associative entity with its own key

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 ________.

B) Composition

Which business rule specifies that each instance of an entity type must have a unique identifier that is not null?A) Triggering operationsB) Referential integrityC) Entity integrityD) Domains

C) Entity Integrity

A ________ key is an attribute (or combination of attributes) that uniquely identifies each instance of an entity type.A) PrimaryB) UniqueC) CandidateD) Duplicate

Candidate

n attribute (or combination of attributes) that uniquely identifies each instance of an entity type

Candidate key

The concept of DFD ________ refers to whether you have included in your DFDs all of the components necessary for the system you are modeling.

Completeness

A class that can have direct instances (e.g., Outpatient or Resident Patient) is called a(n) ________ class.

Concrete

The concept of DFD ________ refers to whether or not the depiction of the system shown at one level of a nested set of DFDs is compatible with the depictions of the system shown at other levels.

Consistency

Which business rule specifies constraints on valid values for attributes?A) Triggering operationsB) Referential integrityC) Entity integrityD) Domains

D) Domains

Data cannot move directly from a source to a sink. It must be moved by a process if the data are of any concern to our system. Otherwise, the data flow is not shown on the ________.

DFD

typically process names begin with _.

Decomposition

four basic concepts of BPMN

Event, activity, Gateway, Flow

a candidate key that has beenselected as the unique, identifying characteristicfor an entity type

Identifier

A(n) ________ arises when one use case uses another use case and is shown diagrammatically as a dotted-line arrow pointed toward the use case that is being used.

Include relationship

________ DFD development recognizes that requirements determination and requirements structuring are interacting, not sequential, subphases of the analysis phase of the SDLC.

Iterative

karen is creating an E-r model. Skill is on the attributes of worker. but a worker can have more than one skill, therefore Karen knows this is a(n) _.

Multivalued attribute

The ________ rule specifies that an entity instance can simultaneously be a member of two (or more) subtypes.A) BusinessB) OverlapC) DisjointD) Total specialization

Overlap

The lowest level of a DFD is called a ________ data flow diagram.

Primitive

a set of two or moremultivalued attributes that are logically related

Repeating group

The ________ of an object encompasses its properties (attributes and relationships) and the values of those properties.

State

which of the following s a reason some developers believe a data model is the most important part of the information system requirements?

Structural information about process improvement is essential for automatic program generation

A _ lists what it takes to satisfy stakeholders if the use case is completed successfully.

Success guarantee

A ________ lists what it takes to satisfy stakeholders if the use case is completed successfully.

Success guarantee

what is the purpose of a conceptual data model?

To show as many rules about the meaning and interrelationships among data as are possible

There is/are ________ principal type(s) of packaged data model(s)

Two

A recursive relationship is also known as a ________ relationship.A) BinaryB) TernaryC) SecondaryD) Unary

Unary

all of the following are business rules except _.

Unary relationship

a(n)_class is a class that has no direct instances but whose descendants may have direct instances.

abstract class

which relation is created with the primary key associated with the relationship or associative entity, plus any nonkey attributes of the relationship or associative entity and the primary keys of the related entities (as foreign key attributes)?

associative entity with its own key

An entity ________ is a collection of entities that share common properties or characteristics.A) ObjectB) TypeC) SubjectD) Relationship

b. type

Use cases written at the fish and _ levels (sometimes called the clam level) are much more detailed and focus on subfunction goals.

black

_ is NOT a valid type of partitioning method in a relational database products.

boundary

all of the following are deliverables for process modeling except

database DFD with metadata

_ is the process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields.

denormalization

all of these are steps to transforming an E-R diagram into normalized relations except __.

denormalize the relations

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 subtype.

disjoint rule

All of the following are advantages to incorporating business rules in the repository except _.

does not promote ease of use of a database

a database designer chooses a file organization for a specific file that will provide which of the following?

efficient use of storage space

a default value is the value that a _ will assume unless an explicit value is entered for it.

field

With only ________ symbols, you can use DFDs to represent both physical and logical information systems.

four

_ data models are generic data models that are designed to be used by organizations within specific industries.

industry-specific

Both the white and _ levels provide a summary of the use case goals.

kite

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.

logical

At the ________ level of DFDs, new data flows may be added to represent data that are transmitted under exceptional conditions. These data flows typically represent error messages or confirmation notices.

lowest

a(n) - is a specification that indicates how many objects participate in a given relationship.

multiplicity

a _ value is special field value, distinct from zero, blank, or any other value, that indicates that the value for the field is missing or otherwise unknown.

null value

the _ is a logical grouping of objects that have the same (or similar) attributes, relationships, and behaviors also called _ class.

object class

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.

partial specialization

a _ table is a named set of rows and columns that specifies the fields in each row of the table.

physical

a computer operating system stores data in a _, which is a named set of table rows stored in a contiguous section of secondary memory.

physical file

A(n) _ is a field of data tha can be used to locate a related field or row of data

pointer

The fact the same operation may apply to two or more classes in different ways is known as _.

polymorphism

11) What unique characteristic(s) distinguish(es) each object from other objects of the same type?A) Secondary keyB) Primary keyC) Composite keyD) Index

primary key

A ________ is the work or actions performed on data so that they are transformed, stored, or distributed.

process

________ is NOT one of the levels of details suggested by Cockburn.

red

which relation is created with primary key and nonkey attributes only?

regular entity

a _ is a simultaneous relationship among instances of three entity types.

ternary

which of the following is an advanced rule governing data flow diagramming

the inputs to a process must be sufficient to produce the outputs

the _ rule specifies that each entity instance of the supertype must be a member of some subtype of the relationship.

total specialization rule

A data flow to a data store means ________.

update

A user-case consists of a set of possible sequences of interactions between a system and __ in a particular environment, possible sequences that are related to a particular goal.

user

what is the relational representation for a binary relationship in the E-R structure?

weak-entity - or maybe many-to many