systems midterm
A BPMN process flow can start in one pool and end in the collaborating pool
f
Access offers modules, which are defined by users to automate processes like opening a specific form
f
Application controls limit access to viewing and changing records in a system.
f
Application controls limit who can change records in a system
f
Business rules are unrelated to COSO control activities, although they serve an important purpose
f
Classes could be grouped into Resources (R), Entity (E), and Assets (A) in data modeling
f
Each attribute in a table can have several names
f
In Access, users can edit database information in reports
f
In a collaboration model using BPMN, the interaction between participants is called orchestration
f
In a hierarchical data model, data elements are related in many-to-many relationships
f
Many-to-many relationships are implemented by posting a foreign key
f
Obligatory business rules state what should not occur.
f
One-to-one relationships are implemented by creating a linking table
f
Queries in Access are utilized by users to enter data into tables and view existing records
f
The SQL command "Group by" can be used to order an amount in a descending order
f
A Class is a separately identifiable collection of business relationships.
false
A database should have exactly the same number of tables as there are Classes in the Unified Modeling Language (UML) Class diagram from which the database is developed
false
An aggregation relationship is a form of generalization relationships
false
In Unified Modeling Language (UML) primary keys may be blank
false
In Unified Modeling Language (UML) the options for maximum multiplicity values are 0 and
false
In Unified Modeling Language (UML) the options for minimum multiplicity values are 0, 1, and 2.
false
In Unified Modeling Language (UML) the options for minimum multiplicity values are 1 and
false
in Unified Modeling Language (UML) Class diagrams, Associations are represented by dashed lines.
false
A labor plan class would establish standard overhead allocation rates
t
A pool in a BPMN model does not actually have to display any activities
t
Access is a simple database management system that can be used to run databases for individuals and small firms
t
An intermediate error event can be used to model process exceptions
t
BPMN models can describe the collaboration between two organizations using pools
t
Business rules describe appropriate actions to take based on process conditions
t
Business rules set criteria for branching in activity models
t
Cloud computing is an internet-based computing where shared resources, software, and information is provided to firms on demand.
t
Conversion labor costs become part of cost of goods sold
t
Gateways can direct sequence flow to support looping
t
In a database, while queries allow the user to access, read and report on desired data, the responsibility of actually making physical changes to the relational database belongs to the Database Management System (DBMS).
t
One-to-many relationships are implemented by posting a foreign key
t
SQL is based on relational algebra and allows a user to query and update the database.
t
Segregation of duties is an example of a COSO control activity
t
The "Where" SQL clause can be used to link two tables.
t
The asterisk (*) following the SELECT SQL statement is a wild card indicating all columns should be selected
t
Three types of data models used today are: the hierarchical model, the network model and the relational model.
t
Type images can be used to allow process information to be summarized by category
t
When building a database from Unified Modeling Language (UML) Class diagrams, each instance of each Class becomes a row in the corresponding table
t
While hierarchical and network data models require relationships to be formed at the database creation, relational data models can be made up as needed
t
A generalization relationship models a grouping of things that share common characteristics
true
Associations can indicate the roles that one Class takes in its business relationship with another Class
true
In Unified Modeling Language (UML) attributes are characteristics of individual instances of a Class.
true
In Unified Modeling Language (UML) foreign keys allow tables to be linked together in a database
true
In Unified Modeling Language (UML) the options for maximum multiplicity values are 1 and
true
The Object Management Group maintains the standard for Unified Modeling Language (UML) Class diagrams.
true
Unified Modeling Language (UML) Class diagrams describe the logical structure of a database system.
true
in Unified Modeling Language (UML) Class diagrams, a Class is represented by a rectangle.
true
in Unified Modeling Language (UML) primary keys cannot by NULL
true