ACCY 310 TEST 1

Public Company Accounting Oversight Board (PCAOB) Auditing Standard No. 5 (AS 5) encourages auditors to start from the basic/bottom of financial records to identify the key controls.

False

Queries in Access are utilized by most users to enter data into tables and view existing records.

False

Rascall Flatts manages his store in a very hands off manner.

False

Symmetric-key encryption method is used to authenticate users.

False

Taylor Swift manages customer complaints and refunds, sending all refund checks from her office location.

False

The goal of information security management is to enhance the confidence, integrity and authority (CIA) of a firm's management.

False

The process for most not-from-concentrate orange juice consists primarily of squeezing the juice from the orange, filtering it, then bottling it.

False

There is no need to prepare a project plan for your work on Sy's Fish.

False

According to the assigned reading, one key limitation to our brain's capacity is the amount of cerebrospinal fluid required to protect the brain from sudden impact.

False.

In the reading on "Amplfied Intelligence," a contributor recommends that new professionals become conversant in many different practice areas, and wait to develop deep expertise in a single area until the market direction has become clear.

False

In a collaboration model using BPMN, the interaction between participants is called orchestration.

False

In reading "Amplified Intelligence," a contributor recommends that new professionals become conversant in many different practice areas and wait to develop deep expertise in a single area until the market has become clear.

False

Internal controls guarantee the accuracy and reliability of accounting records.

False

Maintaining two sets of books for a company is illegal in all states.

False

Many-to-many relationships in databases are implemented by posting a foreign key.

False

Natalie Merchant pays her fishermen vendors once per month.

False

One-to-one relationships are implemented by creating a linking table.

False

Production of a 1040 tax form from the AIS to be delivered to the Internal Revenue Service is an example of discretionary information.

False

Is Moore's Law consistent?

No, it is starting to stagnate in recent yrs.

suppliers

in the UML diagram of the purchases and payments process, the external agents from whom goods and services are purchased and to whom payments are made.

Associations can indicate the roles that one Class take in a business relationship with another Class.

True

CFOs are preparing their companies for compliance with the latest version of COSO, which goes into effect December 15, 2014.

True

COBIT (Control Objectives for Information and related Technology) is a generally accepted framework for IT governance in the U.S.

True

CRM software often includes the use of database marketing tools to learn more about the customers and to develop strong firm-to-customer relationships.

True

Cloud computing is an internet-based computing where shared resources, software, and information is provided to firms on demand.

True

Conversion labor costs become part of cost of goods sold.

True

Corporate governance is a set of processes and policies in managing an organization with sounds ethics to safeguard the interests of its stakeholders.

True

exclusive gateway

all branches are exclusive (x)

accounts payable

amounts owed to suppliers for goods and services received.

Primary key

an attribute or a combination of attributes that uniquely identifies an instance of a class in a data model or a specific row in a table

Documentation

an information transmission and communication tool that explains how business processes and business systems work

Error event

an intermediate event in a BPMN model showing processing for exceptions to the normal process flow

purchase discount

an offer from the supplier to reduce the cost of a purchase if payment is made according to specified terms, usually within a specified time.

swimlanes

indicate different departments/ functions within the primary organization of interest, connected within the larger organizational pool

pools

indicate separate entities, separated by a gap (vendor/customer)

Data flow diagram (DFD)

another type of activity model that graphically shows the flow of data through a system and also incorporates elements of structure models

inclusive gateway

any number of paths (o)

Class

any separately identifiable collection of things (objects) about which the organization wants to collect and store information. Classes can represents organization resources, and conceptual structures. They are typically implemented as tables in a relational database, where individual instances of the class are represented as rows in the table

resources

assets controlled by an organization

blank gateway

assume that it is exclusive, one path

Form

forms are utilized by users to enter data into tables and view existing records

un-normalized data

found on a typical report of spreadsheet

Discretionary Information

generated according to one's judgement

Certified Information Technology Professional (CITP)

identifies accounts with a broad range of technology knowledge and experience

Marketing and sales activities

identify the needs and wants of their customers to help attract them to the firm's products and buy them

economic event

impacts financial statements

Events

important occurrences that affect the flow of activities in a business process

Orchestration

in BPMN the sequence of activities within one pool

orchestration

in BPMN, the sequence of activities within one pool

Activities

in a business process modeling, activities represent specific steps in a business process

Query

in access is a tool used to retrieve and display data derived from records stored within that database

Report

in access that are used to integrate data from one or more queries and tables to provide useful information to decision makers

Sequential activity

indicate that the activity may be performed multiple times, similar to looping activity, not used much in practice (three horizontal lines)

timer event (with clock)

indicates a delay, usually with an explanation

error/exception event (lighting)

indicates a problem that requires a different path, usually with an activity

looping activity

indicates that the activity may be repeated multiple times (with loop)

timer events

indication of a delay in the flow of a process to a specific date, and elapsed time or a relative repetitive date, such as every Friday.

Database considerations

information stored has value large volume maintain complex relationships between data privacy issues irreplaceable data

relevance

information that is capable of making a difference in a decision

Reliability

information that is free from bias or error

Mandatory information

information that is required to be generate or provided by law or regulation

An XBRL document that represents a 10-K filing is referred to in XBRL as a(n) ____________document.

instance

intermediate timer event

intermediate events that indicate a delay in the normal process flow until a fixed amount of time has elapsed

Cloud computing

internet based computing where shared resources, software and information are provided to firms on demand

Business Value

items, events, and interactions that determine the financial health and well-being of the firm

Access controls

limit who can use and change records in the system, passwords

outputs of an AIS

reports to management reports to investors/creditors files retaining transaction data files retaining current data about accounts

Subprocess

represent a series of process steps that are hidden from view in BPMN, the use of sub processes in modeling helps reduce complexity

subprocess

represent a series of process steps that are hidden from view in BPMN.

sequence flows

represented by arrows and indicate the progression of activity within the process

REA

resource event agent framework for modeling business processes, originally developed by McCarthy

REA model

resources, events, agents (data classes represent these three components)

REA

resources->events->agents primary model for AIS databases

Queries: key types

select insert update delete

gateway

shows process branching and merging as the result of decisions. Depicted as diamonds.

Process maps

simplified flowcharts that use a basic set of symbols to represent a business process activity

schema

simply a layout of the entire database

Supply chain management software (scm)

software that connects the focal firms with its suppliers. It generally addresses segments of the supply chain, including manufacturing, inventory control and transportation

Customer relationship management (CRM)

software used to manage and nurture a firm's interactions with its current and potential clients. Often includes the use of database marketing tools to learn more about the customers and to develop strong firm to customer relationships

Module

some microsoft applications come with modules built in that will be automatically added onto access

Business Process Modeling

started by the Object Management Group to do activity modeling

Relational data model

stores information in the form of related 2D tables

Class diagram

structure models prepared using UML notation

Business Rules

succinct statements of constraints on business processes, provide the logic that guide the behavior of the business in specific situations

Business rule

succinct statements of constraints on business processes; they provide the logic that guides the behavior of the business in specific situations

Technology

supports value creating activities in the value change, these technologies also include research and development to develop new products or determine ways to produce products at a cheaper price

Relationship

the business purpose for the association between two classes or two database tables

While hierarchical and network data models require relationships to be formed at the database creation, relational data models can be made up as needed.

true

business value includes all those items, events, and interactions that determine the financial health and well-being of the firm

true

the Certified Information Systems Auditor (CISA) is a professional designation generally sought by those performing IT audits

true

primary key

unique to each record

accounting roles

user, manager, designer, evaluater

Flowcharts

visualizations of a process activity; they are activity models much like models using BPMN

Asymmetric-key encryption is suitable for encrypting large data sets or messages.

False

Bruce Springsteen runs payroll on a bi-weekly basis.

False

Consulting revenues at all Big Four firms are greater than audit revenues

False

Data flow diagrams start with a circle indication the start event.

False

Disaster recovery plans and business continuity management are preventive controls.

False

Elton John maintains detailed customer receivables records, with up-to-date balances outstanding.

False

In Unified Modeling Language (UML) Class diagrams, Associations are represented by dashed lines.

False

subschema

focuses on a more specific area of interest withing the over all database

3 attributes of relevance

1) Predictive Value (helps forecast future) 2)Feedback Value (Evaluate past decisions) 3)Timeliness (received in time to affect decision)

3 attributes of reliability

1)Verifiable (can be confirmed) 2) Representational faithfulness (Truthful) 3) Neutrality (info not biased)

AIS is the nexus of these 2 traditional disciplines:

1. Information Systems 2. Accounting

According to an assigned reading, purchasing habits on this number of items can provide strong evidence of an impending life change.

25

Which of following are possible options for minimum multiplicities? A. 0 and 1 B. 0 and * C. * and 1 D. 0, 1, and *

A. 0 and 1

Which of the following is not a form of business rules? A. Compulsory B. Obligatory C. Prohibited D. Allowed

A. Compulsory

Consider an association between a Cities class and a Neighborhoods class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Cities class are 1..1 and the multiplicities next to the Neighborhoods class are 1..*. Which of the following is the best way to implement that association in your database? A. Post the primary key of Cities as a foreign key in Neighborhoods. B. Post the primary key of Neighborhoods as a foreign key in Cities. C. Create a linking table. D. None of the above.

A. Post the primary key of Cities as a foreign key in Neighborhoods.

Consider an association between a Customers class and a Sale class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Customers class are 1..1 and the multiplicities next to the Sale class are 0..*. Which of the following is the best way to implement that association in your database? A. Post the primary key of Customers as a foreign key in Sales. B. Post the primary key of Sales as a foreign key in Customers. C. Create a linking table. D. None of the above.

A. Post the primary key of Customers as a foreign key in Sales.

Consider an association between a Pet Owners class and a Pets class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Pet Owners class are 1..1 and the multiplicities next to the Pets class are 1..*. Which of the following is the best way to implement that association in your database? A. Post the primary key of Pet Owners as a foreign key in the Pets. B. Post the primary key of Pets as a foreign key in Pet Owners. C. Create a linking table. D. None of the above.

A. Post the primary key of Pet Owners as a foreign key in the Pets.

False

According to one of the assigned readings, Proctor & Gamble use heat maps to save on energy costs in their production facilities.

AIS stands for?

Accounting Information System(AIS)

Which of the following statements about foreign keys is not true? A. A foreign key can be a combination of attributes. B. A foreign key cannot be NULL. C. Foreign key must match values of the linked primary key. D. Foreign keys support a defined association.

B. A foreign key cannot be NULL.

Entity-relationship diagrams (ERDs) are similar in content and purpose to Unified Modeling Language (UML) Class diagrams. Which of the following is not a basic building block of ERDs? A. Relationships B. Associations C. Attributes D. Entities

B. Associations

Which of the following is not a best practice in preparing Unified Modeling Language (UML) Class diagrams? A. Opt for simplicity. B. Model each process separately. C. Avoid crossing lines whenever possible. D. Avoid confusing abbreviations.

B. Model each process separately.

Consider an association between a Cash Disbursements class and a Cash Accounts class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Cash Disbursements class are 0..* and the multiplicities next to the Cash Accounts class are 1..1. Which of the following is the best way to implement that association in your database? A. Post the primary key of Cash Disbursements as a foreign key in Cash Accounts. B. Post the primary key of Cash Accounts as a foreign key in Cash Disbursements. C. Create a linking table. D. None of the above.

B. Post the primary key of Cash Accounts as a foreign key in Cash Disbursements.

Consider an association between a Deliveries class and a Shipping Companies class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Deliveries class are 0..* and the multiplicities next to the Shipping Companies class are 1..1. Which of the following is the best way to implement that association in your database? A. Post the primary key of Deliveries as a foreign key in Shipping Companies. B. Post the primary key of Shipping Companies as a foreign key in Deliveries. C. Create a linking table. D. None of the above.

B. Post the primary key of Shipping Companies as a foreign key in Deliveries.

Consider an association between a Cash Disbursements class and a Vendors class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Cash Disbursements class are 0..* and the multiplicities next to the Vendors class are 1..1. Which of the following is the best way to implement that association in your database? A. Post the primary key of Cash Disbursements as a foreign key in Vendors. B. Post the primary key of Vendors as a foreign key in Cash Disbursements. C. Create a linking table. D. None of the above.

B. Post the primary key of Vendors as a foreign key in Cash Disbursements.

Which of the following would be least likely to be represented with a Unified Modeling Language (UML) Class? A. Trucks B. The number of trucks used in the delivery C. The employee driving the truck D. The customer receiving the delivery

B. The number of trucks used in the delivery

Give the requirement of the Sarbanes-Oxley Act of 2002 (SOX), the Public Company Accounting Oversight Board (PCOB) established the SEC to provide independent oversight of public accounting firms.

False

Which of the following is not something a model of database structures must be able to describe? A. The entities or things in the domain of interest B. The sequence that entities are accessed C. The cardinalities that describe how many instances of one entity can be related to another D. The attributes or characteristics of the entities and relationships

B. The sequence that entities are accessed

sequence flow

BPMN building block, represent by arrow to indicate progression

activities

BPMN building block, represent specific steps in the business process, described with short verb phrase (rounded rectangle)

Gateways

BPMN building block, show process branching and merging as the result of decisions (diamond)

events

BPMN building blocks, include start, intermediate, and ending (circles)

Merging flows

BPMN represents exchanges between two participants (pools) in the same process as message flows, which are modeled as dashed arrows

Swimlanes

BPMN symbols that provide subdivisions of pools to show, for example, functional responsibilities within an organization, indicate different departments/ functions within the primary organization of interest, lanes are connected within the larger organization

Sequence flows

BPMN symbols that show the normal sequence of activities in a business process. Sequence flows are modeled as solid arrows, with the arrowhead showing the direction of process flow

Pools

BPMN symbols used to identify participants, actors, or persons that perform activities and interact with other participants in a process; indicate separate entities

Consider an association between a Sales class and an Inventory class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Sales class are 0..** and the multiplicities next to the Inventory class are 1..**. Which of the following is the best way to implement that association in your database? A. Post the primary key of Sales as a foreign key in Inventory. B. Post the primary key of Inventory as a foreign key in Sales. C. Create a linking table. D. None of the above.

C. Create a linking table.

Consider an association indicating professional licensing status between an Accountant class and a States class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Accountants class are 0..** and the multiplicities next to the States class are 0..**. Which of the following is the best way to implement that association in your database? A. Post the primary key of Accountants as a foreign key in States. B. Post the primary key of States as a foreign key in Accountants. C. Create a linking table. D. None of the above.

C. Create a linking table.

Which of the following is not a step in using a Unified Modeling Language (UML) Class model to prepare a database? A. Map Classes to Tables. B. Map Attributes to Table Fields. C. Map Associations to Primary Keys. D. Map Associations to Foreign Keys.

C. Map Associations to Primary Keys.

Which of the following is the best description of an association? A. A group of classes B. The lines in a UML Class diagram C. The relationship between two classes D. The number of times one class is related to another

C. The relationship between two classes

Application controls limit access to viewing and changing records in a system

False

Which of the following is a well-formed business rule? A. Customers must be over 18 years of age. B. Customers may not be under 18 years of age. C. Customers must pay in U. S. dollars. D. All of these are well-formed business rules.

D. All of these are well-formed business rules.

Which of the following is not a criterion for selection of a primary key? A. The primary key cannot be NULL (blank). B. The primary key should be controlled by the organization assigning it. C. Primary keys with sequential values make it easier to spot gaps in the data. D. Longer key values are better than shorter key values.

D. Longer key values are better than shorter key values.

Application controls limit who can change records in a system.

False

Which of the following best describes the purpose of a primary key? A. Allows linking two or more tables B. Indicates the minimum multiplicities for an association C. Matches values of foreign keys in other classes D. Uniquely identifies each instance of the class

D. Uniquely identifies each instance of the class

In UML the options for minimum multiplicity values are 1 and *

FALSE

A BPMN process flow can start in one pool and end in the collaborating pool.

False

A Class is a separately identifiable collection of business relationships.

False

A company's audit committee is responsible for fraud risk assessments.

False

According to an assigned reading, one key limitation to our brain's capacity is the amount of cerebrospinal fluid required to protect the brain from sudden impact.

False

According to an assigned reading, the key to becoming extremely successful is taking on many different projects in order to find out what you're best at.

False

According to an assigned reading, the stirrup changed warfare dramatically by allowing the rider to mount the horse more easily.

False

According to one of the assigned readings, Proctor & Gamble use heat maps to save on energy costs in the production facilities.

False

According to one of the assigned readings, SAP's main consideration in targeting Silicon Valley acquisitions is to increase its dominance in the client-server software market.

False

According to one of the readings, technology has been a key enabler of real cost reductions in the prices of manufactured goods as well as services.

False

According to the Sarbanes-Oxley Act of 2002, it is the responsibility of the Board of Directors to establish and maintain the effectiveness of internal control.

False

According to the assigned readings, the primary aim for new tools designed to monitor the "Internet of Things" is management react faster to issues.

False

Accounting and finance is a primary activity in the value chain.

False

3rd normal form

remove transitive dependencies

Data Warehouses/ OLAP

STAR schema more accurate historical reporting capabilities used for business intelligence, data mining, identifying new patterns in data

BPMN Events

Start, end, intermediaries /circles

SQL

Structured Query Language, most commonly used database language

3D printing poses challenges for auditors.

True

A business model is typically graphical depiction of the essential business process information

True

A generalization relationship models a grouping of things that share common characterisitics

True

A pool in a BPMN model does not actually have to display any activities.

True

A strategy map depicts the cause and effect relationship between objectives across the balanced scorecard perspectives.

True

According to one of the assigned readings, XBRL needs to be audited because it introduces a new area of risk.

True

According to one of the assigned readings, a risk heat map is a good way to get an overview an organization's portfolio of risks.

True

According to one of the assigned readings, one the key causes for many of today's ethical problems is the rapidly changing context in which we have to apply our moral principles.

True

An activity can depict a single action or some logical combination of actions depending on the required level of detail to achieve the objective of the business process analysis.

True

An intermediate error event can be used to model process expectations.

True

Data Mining is a process of using sophisticated statistical techniques to extract and analyze data from large databases to discern patterns and trends that were not previously known.

True

Encryption is a preventive control that helps to ensure data confidentiality and privacy during transmission and for storage.

True

Function IT can be used without affecting more than one skilled worker.

True

In UML attributes are characteristics of individual instances of a Class.

True

In Unified Modeling Language (UML) Class diagrams, a Class is represented by a rectangle.

True

In activity diagrams, gateways can result in looping.

True

Information overload is defined as the difficulty a person faces in understanding a problem and making a decision as a consequence of too much information.

True

Internal control is a process consisting of ongoing tasks and activities. It is a means to an end, not an end in itself.

True

One type of fault tolerance is using redundant units to provide a system the ability to continue functioning when part of the system fails.

True

One-to-many relationships are implemented by posting a foreign key.

True

One-to-many relationships in databases are implemented by posting a foreign key.

True

SQL is based on relational algebra and allows a user to query and update the database.

True

Segregation of duties is an example of a COSO control activity.

True

Swimlanes identify participants, departments, in a process.

True

Sy's expansion plans have led him to realize the need for improved technology in his business.

True

The Object Management Group maintains the standard for Unified Modeling Language (UML) Class diagrams.

True

The balanced scorecard framework describes performance from 4 different perspectives based on a firm's strategy to achieve shareholder value.

True

The goal of information security management is to maintain confidentially, integrity and availability of a firm's information.

True

The main objective of the ISO 27000 series is to provide a model for establishing, implementing, operating, monitoring, maintaining, and improving information security.

True

The object management group maintains the standard for Unified Modeling Language (UML)

True

Type images can be used to allow process information to be summarized by category.

True

UML class diagrams describe the logical structure of a database system.

True

Association

UML symbol that depicts the relationship between two classes; it is modeled as a solid line that connects two classes in a model

Multiplicities

UML symbol that describes the minimum and maximum number of times an instance of one class can be associated with instances of another class for a specific association between those two classes, they indicate whether the two classes are part of one-to-one, one-to-many, or many-to-many relationships

Parallel Activity

activity is performed multiple times simultaneously (III)

Collaboration

a BPMN model showing two participant pools and the interaction between them within a process

collaboration

a BPMN model showing two participant pools and the interactions between them within a process

Enterprise System (ES)

a centralized database that collects data from throughout the firm

Value chain

a chain of critical business processes at a company that creates value

Database

a collection of date that is stored in related files

purchase order

a commitment event that precedes the economic purchase event. It records formal offers to suppliers to pay them if the supplier complies with the terms of the purchase order.

Structured query language (SQL)

a computer language designed to retrieve data from a relational database

Database management system (DBMS)

a computer program that creates, modifies, and queries the database. Specifically the DBMS is designed to manage a database's storage and retrieval of information

Structured model

a conceptual depiction of a database such as a UML class model or an entity relationship model

structural model

a conceptual depiction of a database, analogous map (UML class model)

business event

does not impact financial statements

Business process

a defines sequence of business activities that use resources to transform specific inputs into specific outputs to achieve a business goal; to evaluate the effectiveness of each business process a firm can use porters value chain analysis

SOX

a federal law in the U.S. that set new and enhanced standards for all public companies, management, and public accounting firms

Network data model

a flexible model representing objects and their relationships, allows each record to have multiple parent and child records or M:N mapping, also known as many to many relationships

Data models

a graphic representation of the conceptual contents of databases; data models support communication about database content between users and designers of the database

Entity Relationship Diagram (ERD)

a graphical view of a database's contents and how tables are related to each other

normalization

a process that reduces data redundancy in order to prevent anomalies

business model

a simple abstract representation of one or more business processes

Business model

a simple, abstract representation of one or more business processes. Typically a graphical depiction of the essential business process information

Composition relationship

a special purpose UML notation representing the relationship between two classes that are often considered together. Similar to aggregation relationships, except in composition relationships, one class cannot exist without the other

Aggregation relationship

a special-purpose UML notation representing the relationship between two classes that are often considered together, such as when a sport league is made up of a collection of teams

Generalization relationships

a special-purpose UML that supports grouping of things that share common characteristics; it reduces redundancy because the shared characteristics need only be modeled once

Business process modeling notation (BPMN)

a standard for the description of activity models

AIS

a system that records, processes and reports on transactions to provide financial and nonfinancial information to make decisions and have appropriate levels of internal controls for those transactions

Accounting Information System (AIS)

a system that records, processes and reports on transactions to provide financial and nonfinancial information to make decisions and have appropriate levels of internal controls for those transactions, must be relevant and reliable

Pages

access pages allow data to be entered into the database in real time from outside the database system

Inbound logistics

activities associated with receiving and storing raw materials and other partially completed materials and distributing those materials to manufacturing when and where they are needed

Human Resource Management

activities include recruiting, hiring, training, and compensating employees

Procurements

activities involve purchasing inputs

Firm infrastructure

activities needed to support the firm, including the CEO and the finance, accounting, and legal departments.

Operations

activities that transform inputs into finished goods and services

Outbound logistics

activities that warehouse and distribute the finished goods to the customers

Foreign key

attribute that allow database tables to be linked together; foreign keys are the primary keys of other tables placed in the current table to support the link between the two tables

data stores

available across processes

According to an assigned reading, the amount of non-classroom preparation time an average college student should plan on spending outside the classroom for each classroom hour in order to do well in a university course is: A. None. All required preparation should be done in class. B. 2-3 hours C. 1 hour D. 4 hours

b

at least 1 of the assigned readings for this course references the Internet Of Things, which is: A. all of the computers, tablets and phones that are connected to the internet B. a network of objects that can communicate with an information center, an operator, or other connected objects C. thermostats that can be controlled by apps D. catalog of all the web pages and filters on internet

b

in the "Filling Caveties" case, the case report notes that the fraudster charged which of the following to the dentists business account? A. furniture for personal residence B. personal dry cleaning C. house cleaning services for personal residence D. all of the above

b

data hierarchy

bits bytes/characters field record file/table database

accounting cycle

business/economic event -> journal -> ledger -> reporting

exclusive gateways

by default are exclusive, declare exclusivity (diamond with X)

Moore's Law

doubling transistors on silicon chips over 18 months

Product

class representing the organization's goods held for sale, that is, the organization's inventory. (resource)

product

class representing the organization's goods held for sale, that is, the organization's inventory. This is considered a resource.

Type image

class that represents information to help manage a business process. It often allows process information to be summarized by category

type image

class that represents management information to help manage a business process

new AIS tech and development

cloud computing sustainability reporting suspicious activity reports (SARS)

business process

collection of activities creates value for organization AIS collects and reports data related to processes

Enterprise system

commercialized information system that integrates and automates business processes across a firm's value chain located within and across organizations

BPMN Activities

curved rectangles

association

dashed line with arrowhead; used to connect data objects/stores with activities

DDL

data definition langauge

Attributes

data elements that describe instances in a class, very much like fields in a database table

referential integrity rule

data in a foreign key must match primary key of the related table

STAR schema

data is denormalized for quick querying and reporting

DML

data manipulation language

Information

data organized in a meaningful way to the user

Macro

defined by access users to automate processes such as opening a specific form

Data dictionary

describes the data fields in each database record such as field description, field length, field type

Quote

description of the products and/or services to be provided to a customer if ordered

Cardinality

determines numerical relationship between entities

steps in documenting a business process

discover the activities that take place, list activities in sequence, determine who/what performs each activity, group activity into logical chunks or activities

According to one of the assigned readings, facial recognition technology has improved to the point that accurate facial recognition can take place for which of the following? A. People wearing sunglasses B. Through car windshields C. People wearing hats D. Two of the other answers E. Three of the other answers

e

XBRL stands for

eXtensible Business Reporting Language

The accounting cycle

economic event, journal, ledger, financial statements

design considerations should be

effective and expectations for outputs

data definition language (DDL)

enables DBMS users to define the record structure of any particular database table

Data manipulation Language

enables DBMS users to perform tasks such as querying, changing records, and deleting records

Application controls

ensure data integrity and an audit trail; for example, new invoices are assigned sequential numbers

Sales order

event documenting commitments by customers to purchase products. The sales order event precedes the economic event

Sales

events documenting the transfer of goods and services to customer and the corresponding recognition of revenue for the organization

Many to many relationships

exists when instances of one class (sales) are related to many instances of another class (inventory) these relationships are implemented in access and relational databases by adding a linking table to convert the many to many relationship into two one to many relationships

many-to-many relationship

exists when instances of one class are related to many instances of another class and vice versa. The relationships are implemented in Access

One to many relationships

exists when instances of one class are related to multiple instances of another class (customer can participate in many sales but each sale involves only one customer

one-to-one relationship

exists when instances of one class are related to only instance of another class and each instance of the other class is related to only one instance of the original class

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 UML class diagram from which the database is developed

false

According to one of the assigned readings, penetration testing should be a key consideration when evaluating the physical controls in place at cloud service providers.

false

According to one of the assigned readings, the primary aim for new tools designed to monitor the "Internet of Things" is to help industrial management react faster to issues.

false

Accounting and Finance is a primary activity in the value chain.

false

An aggregation relationship is a form of generalization relationships

false

BPMN start events are shown using ovals and flowchart start event are shown using circles

false

California's new digital privacy law is fairly similar to the new EU privacy law in that its focus is on positive consumer confirmation for each new use of personal information by companies.

false

Classes can (and in our class, should) be grouped into Resources (R), Entities (E), and Assets (A) in data modeling.

false

Data Flow Diagrams start with a circle indicating the start event.

false

Each attribute in a table can have several names.

false

In Access, users can edit database information in reports.

false

In UML class diagrams, associations are represented by dashed lines

false

In UML primary keys may be blank

false

In UML the options for maximum multiplicity values are 0 and *

false

In 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 0, 1, and 2.

false

In the "Filling Cavities" case, the computer containing the accounting records was hacked from outside the business.

false

Obligatory business rules state what should not occur

false

The SQL "Group by" clause can be used to order results in descending order for a particular field.

false

The following is a "well formed" XML document: <?xml version="1.0"?> <note> <to age=29>Tove</to> <from>Jani</from> </note>

false

activity models are a relatively new process modeling tool

false

because business models are simpler than the process they depict, they are limited in their ability to integrate local views of a process

false

data is defined as being info organized in a meaningful way to be useful to the user

false

in BPMN activity diagrams depict activities as circles

false

Annotations

model elements that allow the modeler to add additional descriptive information to the model. Annotations are models with text inside a bracket connected to the model symbol with a dashed line

activity model

models that describe a sequence of workflow in a business process, directional map (flow diagrams, flowcharts, business process maps)

Activity models

models that describe the sequence of workflow in a business process or processes

Accounts receivable

monies owed by customers for prior sales of goods or services. In a data modeling context, AR are calculated as each customer's sales less corresponding care receipts

structured query language

most common DDL,DML used today; designed for relational databases, nearly all databases support this SELECT-Product ID, purchase order id, creation date, etc FROM-suppliers, purchase orders, purchase order details WHERE- [Purchase orders] [exp]=[][] ORDER BY-creation date

parallel gateway

multiple branches to be executed (diamond with +)

secondary key

not necessarily unique, used for searching

intermediate event

occurs between start and end events and affects the flow of the process

data object

only available during this process

three basic types of software

operating systems, application software, programming languages/compilers

Constraints

optional or mandatory guidance about how a process should perform in certain situations

record structure in file or database

organization of fields within each record

Hierarchical data model

organizes data into a tree like structure that allows repeating information using defined parent/child relationships

agents

people associated with the activities

According to the assigned readings, facial recognition technology has improved to the point that accurate facial recognition can take place when

people wear sunglasses, through car windshields, and people wearing hats

System analyst

person responsible for both determining the information needs of the business and designing a system to meet those needs

entity integrity rule

primary key cannot be null

Normalization

process that reduces data redundancy in order to prevent anomalies

Service activities

provide the support of customers after the products and services are sold to them (warrenty)

Data

raw facts of statistics that, absent a context, may have little meaning

cash disbursements

record payments of cash to external agents and the corresponding reduction in cash accounts This is considered an event.

Cash receipts

record receipts of cash from external agents and the corresponding deposit of those receipts into cash accounts (event)

purchases

records the receipt of goods or services from a supplier and the corresponding obligation to pay the supplier. These are considered events.

foreign key

refers to a primary key in another table/file

Collapsed sub-process activity

refers to another BPMN activity diagram that has been prepared (with plus sign)

Information from AIS must both be __________ and ______________

relevant and reliable

2nd normal form

remove partial dependencies

1st normal form

remove repeating fields

Certified information systems auditor (CISA)

the certification for internal auditors and is the standard to demonstrate competency and professionalism in the internal auditing field

Referential integrity rule

the data value for a foreign key must either be null or match on of the data values that already exists in the corresponding table

Information overload

the difficulty a person faces in understanding a problem and making a decision as a consequence of too much information

Customer

the external agent in the sales and collection process

Supply chain

the flow of materials, information, payments, and service from raw materials suppliers, through factories and warehouses, all the way to the final customers of the firms products

Choreography

the interaction between two participants (modeled as pools) in a process model using BPMN

choreography

the interaction between two participants in a process modeled using BPMN.

cash

the organization's monies in bank or related accounts. The instances of the class are individual accounts. This is considered a resource.

Cash

the organization's monies in the bank or related accounts. (resource)

Information value chain

the overall transformation from a business need and business event to the collection of data and information to an ultimate decision

Agents

the people or organizations who participate in business events, such as customers and salespeople

agents

the people or organizations who participate in business events, such as customers and salespeople

Entities

the people, things, or events in the domain of interest; in UML notation, entities are primary keys of other tables placed in the current table to support the link between the two tables

Database administrator

the person responsible for the design, implementation, repair, and security of a firm's database

Entity integrity rule

the primary key of a table cannot be null

Business analysis

the process of defining business process requirements and evaluating potential improvements. Business analysis involves ascertaining, documenting, and communicating information about current and future business processes using business process modeling and related tools

Transform

the use of computer technology to fundamentally redefine business processes and relationships

Informate down

the use of computer technology to provide information about business activities to employees across the firm

informate up

the use of computer technology to provide information about business activities to senior management

Automate

the use of technology to replace human labor in automating business processes

Resources

those things that have economic value to a firm, such as cash and products

A business model is typically a graphical depiction of the essential business process information.

true

An activity can depict a single action or some logical combination of actions depending on the required level of detail to achieve the objectives of the business process analysis.

true

Associations can indicate the roles that one class takes in its business relationship with another class

true

Business rules set criteria for branching in activity models

true

EU's new privacy law hampers companies' ability to reuse individuals' personal information by requiring them to obtain positive permission for each new type of use.

true

In Business Process Modeling Notation (BPMN), activities are named with a short verb phrase placed within the rectangle.

true

In UML attributes are characteristics of individual instances of a class

true

In UML class diagrams, a class is represented by a rectangle

true

In UML foreign keys allow tables to be linked together in a database

true

In UML primary keys cannot be NULL

true

In UML the options for maximum multiplicity values are 1 and *

true

In Unified Modeling Language (UML) attributes are characteristics of individual instances of a Class.

true

The asterisk (*) following the SELECT SQL statement is a wild card indicating all columns should be selected.

true

Three types of data models used today are: the hierarchical model, the network model and the relational model.

true

UML Class diagrams describe the logical structure of a database

true

Unified Modeling Language (UML) Class diagrams describe the logical structure of a database system.

true

When building a database from UML class diagrams, each instance of each class becomes a row in the corresponding table

true