info systems final
Which of the following is a true statement?
An information system design based on a data orientation, rather than a process or logic orientation, should have a longer useful life.
The primary deliverable from the conceptual modeling step within the analysis phase is a(n):
E-R diagram
A collection of entities that share common properties or characteristics defines:
Entity Type
Which of the following properties of a relation states that an entry at the intersection of each row and column is single-valued?
Entries in cells are simple.
A business process can only come from certain business functions.
False
A unary relationship is the most common type of relationship encountered in data modeling.
False
Business Process Modeling Notation is much more simple than data flow diagrams.
False
If a gateway is inclusive, the downstream activities that follow it must also be followed by a congregated gateway.
False
In an activity diagram, the fast lane represents the organizational unit responsible for a certain action.
False
In business process modeling, an action that may take place is called an activity.
False
Processes, rather than data, are the most complex aspects of many modern information systems.
False
Sequence diagrams represent dynamic models of how objects change their states in response to events.
False
Triggers are constraints on valid values for attributes.
False
A deliverable from conceptual data modeling is a set of entries about data objects to be stored in the project dictionary or repository.
True
A gateway can be exclusive or inclusive.
True
A sequence diagram depicts the interactions among objects during a certain period of time.
True
A swimlane is a way to visually encapsulate a process.
True
An activity diagram clearly shows parallel and alternative behaviors.
True
An activity diagram should only be used when it adds value to the project.
True
An activity diagram shows the conditional logic for the sequence of system activities needed to accomplish a business process.
True
An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.
True
An event is a trigger that starts a process in business process modeling.
True
Employee identification number, name, address, and skill are attributes.
True
Entity integrity means each instance of an entity type must have a unique identifier that is not null.
True
In Business Process Modeling Notation, a gateway is represented by a diamond.
True
In business process modeling, a gateway is a decision point.
True
Relationships are labeled with verb phrases.
True
The more complex a business process is, the harder it is to automate.
True
The names of data stores on primitive-level data flow diagrams often correspond to the names of data entities in entity-relationship diagrams
True
When selecting an identifier, one should choose a candidate key that will not change its value over the life of each instance of the entity type.
True
The symbol for an activity is:
a rectangle with rounded edges
In UML, a class is represented by:
a rectangle with three compartments separated by horizontal lines
A relationship that the data modeler chooses to model as an entity type best defines:
associative entity
A message in which the sender does not have to wait for the recipient to handle the message best describes:
asynchronous message
Which of the following represents how an object acts and reacts?
behavior
All of the following are symbols used in business process modeling EXCEPT:
decision
To convert a relation to second normal form, you decompose the relation into new relations using the attributes, called:
determinants
The set of all data types and ranges of values that an attribute can assume defines:
domain
Which of the following refers to the set of all data types and values that an attribute can assume?
domains
For a binary one-to-one relationship between two entities A and B, the relationship is represented by
either adding the primary key of A as a foreign key of B or adding the primary key of B as a foreign key of A
The technique of hiding the internal implementation details of an object from its external view is called:
encapsulation
Which of the following specifies that each instance of an entity type must have a unique identifier that is not null?
entity integrity
All business processes begin and end with a(n):
event
A data marker is a field of data that can be used to locate a related field or row of data.
false
Designing the database for an Internet-based electronic commerce application differs significantly from the process followed when designing the database for other types of applications.
false
The primary deliverable from logical database design is a conceptual model.
false
if order number serves as the primary key in the ORDER relation and also appears as a nonprimary key attribute in the INVOICE relation, then order number is said to be a:
foreign key
A particular relationship between two attributes best defines:
functional dependency
A candidate key that has been selected as the unique, identifying characteristic for an entity type is called a(n):
identifier
Sequence diagrams can be presented in:
instance or generic form
On a sequence diagram, the destruction of an object is shown as a:
large X
The primary deliverable from logical database design is:
normalized relations
An entity that has a well-defined role in the application domain and has state, behavior, and identity characteristics defines:
object
Each regular entity type in an E-R diagram is transformed into a:
relation
An association between the instances of one or more entity types that is of interest to the organization best defines:
relationship
When each nonprimary key attribute is identified by the whole key, the relation is said to be in at least:
second normal form
When an operation calls upon another operation within the same object, this is known as:
self-delegation
Which of the following depicts the interactions among objects during a certain period of time?
sequence diagrams
Which of the following represent dynamic models of interactions between objects
sequence diagrams
Which of the following encompasses an object's properties and the values those properties have?
state
In business process modeling, a way to encapsulate a process is called a(n):
swimlane
For a unary M:N relationship:
the entity type is modeled as one relation; using as its primary key a composite key, a separate relation is created to represent the M:N relationship
If entity B is a mandatory participant, then:
the minimum cardinality of the relationship is one
The relation state specifying that nonprimary key attributes do not depend on other nonprimary key attributes is:
third normal form
An activity diagram can be used for all of the following except:
to show the links between objects
When two 3NF relations are merged to form a single relation:
transitive dependencies may result
A functional dependency between two (or more) nonprimary key attributes in a relation defines a:
transitive dependency
Which of the following refers to an assertion or rule that governs the validity of data manipulation operations such as insert, update, and delete?
triggering operations
A physical file is a named set of table rows stored in a contiguous section of secondary memory.
true
A relation is in second normal form if every nonprimary key attribute is functionally dependent on the whole primary key.
true
An aggregation expresses a Part-of relationship between a component object and an aggregate object.
true
An object class is a logical grouping of objects that have the same attributes and behaviors.
true
File restoration can be achieved through backup copies of a file, audit trails, and row image files.
true
The selection of the appropriate storage format for each attribute from the logical database model is made during physical database design.
true
An entity whose primary key depends on the primary key of another entity is called a:
weak entity
