Midterm Flashcards

1
Q

Which question below can be answered using business intelligence?

A

Lowest sales per week compared with the economic interest rate

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Data and information are the same thing. (T / F)

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which executive-level person is responsible for overseeing and managing the organization’s information systems?

A

CIO

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

A computer-based information system includes:

A

Data

Hardware

Software

People

Telecommunication Networks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is a way of monitoring the entire system in a company, by viewing the multiple inputs being processed to produce outputs?

A

Systems thinking.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

MIS is a business function. Which of the following does MIS perform to help aid the company in decision making and problem solving?

A

Moves information about people.

Moves information about processes.

Moves information about products.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Blockchain refers to interconnected Internet enabled devices or things collecting and sharing data without human intervention. (T/F)

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

A well-educated professional who creates, modifies, and/or synthesizes information/knowledge as a fundamental part of their job is a:

A

knowledge worker

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which of the following represents the core drives of the information age?

A

Data, Information, Business Intelligence, Knowledge.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

IS personnel are extremely valuable to a company because they possess integrated knowledge and skills in all of the following areas except:

A

secretarial knowledge

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

The functional area/department that is responsible for identifying and selecting potential vendors/suppliers is the Warehouse functional area/department. (T/F)

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

One of the disadvantages of the business process approach is increased lead times. (T/F)

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Stock status inquiry is done by the Procurement department. (T/F)

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Business Process Reengineering (BPR) involves the radical redesign of core business processes to achieve dramatic improvements in productivity, cycle times and quality. (T/F)

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Most business processes are cross-functional or cross-departmental processes that span the entire organization. Which of the following does NOT represent a cross-functional business process?

A

Processing payroll

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Strategic Planning is a customer facing process. (T/F)

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Which of the following are characteristics of business processes?

A

Has internal or external customers

Produces one or more outputs of value to customers

Usually cross-functional

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

In Company XYZ workers complete separate functional tasks in their own departments without regard to the consequences for the other components of the process or areas in the organization. Which of the following terms reflects this situation?

A

Silo Effect

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

The delivery date on a Purchase Order refers to when the Purchase Order document will be delivered to the Customer. (T/F)

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Harry manages the warehouse and is delegating responsibilities to his employees on the show floor. Which of the following warehouse activities are related to the procurement process? (multiple answer question with 2 correct answers, partial credit is possible)

A

Receive packing list

Create goods receipt document

Receive packing list

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

In the fulfillment (COM) process, the sales order is created after we receive the invoice from the customer. (T/F)

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Which of the following is not among the responsibilities of the Operations/production functional area/department?

A

Creating Quotations to be sent to potential customers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

In a business process all activities must be completed sequentially. (T/F)

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

System

A

Collection of interrelated parts that work together to achieve a common goal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Systems thinking
A way of monitoring the entire system by viewing multiple inputs being processed to produce outputs while continuously gathering feedback on each part.
26
Information System (IS)
Combinations of hardware, software, and telecommunications networks that people build and use to collect, create, and distribute useful data in organizations.
27
Management information systems (MIS)
the study and use of IT to help meet business goals. The name of the field. A business function which moves information about people, products, and processes across the company to facilitate decision-making and problem-solving.
28
VoIP
Use of Internet technologies for placing telephone calls High quality of transmission possible Ability to call from any place with Internet connection
29
Knowledge worker
A well-educated professional who creates, acquires, processes, synthesizes, disseminates, analyze and uses information
30
Knowledge Society
Also called digital society, new economy, Downside: Digital divide The contrast over available information technology
31
Business Process
Set of logically related business activities in which an organization engages to create customer value. Manner in which work is organized, or coordinated in an organization
32
Characteristics of Business Processes
Has internal or external customers Takes inputs and produces outputs of value to the customers Usually cross-functional Uses information to tailor or complete the activities Requires resources
33
Silo Effect
People complete their tasks in their functional silos without regard to the consequences to the other departments and the company.
34
Lead time
Time required to manufacture an item (e.g. How far in advance should we obtain the raw materials from suppliers?)
35
Cycle time
Time required to process an order
36
List of departments
Purchasing, warehouse, operations/production, sales & marketing, research & development, finance & accounting, HR, and IT
37
Purchasing Department Duties
Buying materials Contacting/identifying/evaluating suppliers Responsible for creating and sending out purchase orders
38
Warehouse Department Duties
Responsible for receiving materials/products from suppliers (inbound logistics) Quality inspection on received materials (inbound logistics) Store the materials (inbound logistics) ``` Inventory management (Identify the need) -Purchase requisition document Pick, pack, and ship products to customers (outbound logistics) ```
39
Operations/Production Department Duties
``` Managing operations/production -Design workflow -Plan capacity -Schedule operations Execute productions Quality inspection on finished goods ```
40
Sales & Marketing Department Duties
Marketing Related Activities - Pre-sales - Advertising - Creating demand - Pricing products Sales Related Activities - Receive customer’s order - Create sales orders After sales -Customer complaints Returns
41
Research & Development Department Duties
Conduct research Improve existing products/services Create new products/services Improve processes used for creating products/services
42
Finance & Accounting Department Duties
Financial statements Incoming/outgoing payments to suppliers Budgeting Capital/investment management
43
HR Department Duties
Hiring, training, promoting, and firing employees benefits /sick time and paid time off Resolving conflicts/unions Payroll
44
IT Department Duties
Infrastructure - Executing business transactions - Information about the processes, people, and products
45
Which of the following does NOT represent a cross-functional business process?
Processing payroll
46
Automation
Computerizing manual tasks: answering phones with computers
47
Streamlining
Improving business processes by removing duplicate jobs in the process or by removing bottlenecks
48
Business Process Reengineering (BPR)
Involves the radical redesign of core business processes to achieve dramatic improvements in productivity, cycle times and quality.
49
Customer facing process
Results in a product or service that is received by an organization’s external customer
50
Business facing process
Invisible to the external customer but essential to the effective management of the business
51
4 Major business processes
Buying Making Selling Financing
52
Sales Order
A document that is prepared by the company, which | Specifies products requested by the customer
53
Purchase Order
Contract with a supplier to purchase certain materials or services under specific conditions (quantity, price, delivery date, etc.)
54
Database
Organized collection of related data Maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses)
55
Database management system (DBMS)
A software application that manages the database and controlling access and security of the data stored in the database Create, update, delete, store, and retrieve data in the database Ex. Microsoft Access, Oracle
56
Database Administrator (DBA):
Person who is responsible for developing and managing the organization’s database
57
Table
Collection of data about a specific topic For each topic we create a separate table: - Student table, Course table, Instructor table - Rows (Records): Each row includes data about a different student - Columns (Fields): Each column includes different kinds of data such as student_ID, first name, last name, and major - -Each column has a name (field name)
58
Primary Key (PK)
A field (or a group of fields) that uniquely identifies each record Each student can be uniquely identified by Student ID field If we know the value of the PK, we can find out the values of other fields in that record
59
Data Model
A data model represents all the tables in the database and their relationships in a simple graphical format
60
Entity-Relationship (E-R) Diagram (ERD)
Most commonly used technique for data modeling - documenting the entities and relationships in a database environment
61
An ERD consists of the following:
ENTITIES (Tables) ATTRIBUTES (Fields) RELATIONSHIPS (Relationships btw tables)
62
Three types of relationships
One-to-Many Relationships (1:m) Many-to-Many Relationships (m:m) One-to-One Relationships (1:1)
63
One-to-Many Relationships (1:m)
Each HERD has many COWS assigned to it (m) Each COW is assigned to one HERD (1) PRIMARY KEY ALWAYS MIGRATES FROM THE ENTITY ON THE ONE SIDE TO THE ENTITY ON THE MANY SIDE
64
Many-to-Many Relationships (m:m)
Each employee is assigned to many projects (m) Each project has many employees assigned to it (m)
65
One-to-One Relationships (1:1)
Each person can have only one passport (1) Each passport belongs to only one person (1)
66
Query by example:
is a technique that uses templates to retrieve and display data from a database
67
What represents all the tables in the database and their relationships in a simple graphical format?
Data model
68
The relationship example of each painter painting many paintings, and each painting being painted by one painter is an example of _______________________ type of relationship.
One-to-many
69
Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?
Database management system
70
Each table in a database must have a primary key (PK). (T/F)
True
71
What is the role of a foreign key in a database?
It is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables
72
In order to connect the entities in a one-to-many relationship, we put the primary key from the “many” side of the relationship as a foreign key onto the “one” side. (T/F)
False
73
In an ERD, _____ is a person, place, event, or thing for which we intend to collect and store data about.
Entity
74
When creating a database table, we should always select “auto number” as the Primary Key’s data type. (T/F)
False