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
Q

Systems thinking

A

A way of monitoring the entire system by viewing multiple inputs being processed to produce outputs while continuously gathering feedback on each part.

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

Information System (IS)

A

Combinations of hardware, software, and telecommunications networks that people build and use to collect, create, and distribute useful data in organizations.

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

Management information systems (MIS)

A

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.

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

VoIP

A

Use of Internet technologies for placing telephone calls

High quality of transmission possible
Ability to call from any place with Internet connection

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

Knowledge worker

A

A well-educated professional who creates, acquires, processes, synthesizes, disseminates, analyze and uses information

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

Knowledge Society

A

Also called digital society, new economy,

Downside: Digital divide
The contrast over available information technology

31
Q

Business Process

A

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
Q

Characteristics of Business Processes

A

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
Q

Silo Effect

A

People complete their tasks in their functional silos without regard to the consequences to the other departments and the company.

34
Q

Lead time

A

Time required to manufacture an item (e.g. How far in advance should we obtain the raw materials from suppliers?)

35
Q

Cycle time

A

Time required to process an order

36
Q

List of departments

A

Purchasing, warehouse, operations/production, sales & marketing, research & development, finance & accounting, HR, and IT

37
Q

Purchasing Department Duties

A

Buying materials

Contacting/identifying/evaluating suppliers

Responsible for creating and sending out purchase orders

38
Q

Warehouse Department Duties

A

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
Q

Operations/Production Department Duties

A
Managing operations/production
-Design workflow
-Plan capacity
-Schedule operations
Execute productions
Quality inspection on finished goods
40
Q

Sales & Marketing Department Duties

A

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
Q

Research & Development Department Duties

A

Conduct research

Improve existing

products/services

Create new products/services

Improve processes used for creating products/services

42
Q

Finance & Accounting Department Duties

A

Financial statements
Incoming/outgoing payments to suppliers
Budgeting
Capital/investment management

43
Q

HR Department Duties

A

Hiring, training, promoting, and firing employees
benefits /sick time and paid time off
Resolving conflicts/unions
Payroll

44
Q

IT Department Duties

A

Infrastructure

  • Executing business transactions
  • Information about the processes, people, and products
45
Q

Which of the following does NOT represent a cross-functional business process?

A

Processing payroll

46
Q

Automation

A

Computerizing manual tasks: answering phones with computers

47
Q

Streamlining

A

Improving business processes by removing duplicate jobs in the process or by removing bottlenecks

48
Q

Business Process Reengineering (BPR)

A

Involves the radical redesign of core business processes to achieve dramatic improvements in productivity, cycle times and quality.

49
Q

Customer facing process

A

Results in a product or service that is received by an organization’s external customer

50
Q

Business facing process

A

Invisible to the external customer but essential to the effective management of the business

51
Q

4 Major business processes

A

Buying
Making
Selling
Financing

52
Q

Sales Order

A

A document that is prepared by the company, which

Specifies products requested by the customer

53
Q

Purchase Order

A

Contract with a supplier to purchase certain materials or services under specific conditions (quantity, price, delivery date, etc.)

54
Q

Database

A

Organized collection of related data

Maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses)

55
Q

Database management system (DBMS)

A

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
Q

Database Administrator (DBA):

A

Person who is responsible for developing and managing the organization’s database

57
Q

Table

A

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
Q

Primary Key (PK)

A

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
Q

Data Model

A

A data model represents all the tables in the database and their relationships in a simple graphical format

60
Q

Entity-Relationship (E-R) Diagram (ERD)

A

Most commonly used technique for data modeling - documenting the entities and relationships in a database environment

61
Q

An ERD consists of the following:

A

ENTITIES (Tables)
ATTRIBUTES (Fields)
RELATIONSHIPS (Relationships btw tables)

62
Q

Three types of relationships

A

One-to-Many Relationships (1:m)

Many-to-Many Relationships (m:m)

One-to-One Relationships (1:1)

63
Q

One-to-Many Relationships (1:m)

A

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
Q

Many-to-Many Relationships (m:m)

A

Each employee is assigned to many projects (m)

Each project has many employees assigned to it (m)

65
Q

One-to-One Relationships (1:1)

A

Each person can have only one passport (1)

Each passport belongs to only one person (1)

66
Q

Query by example:

A

is a technique that uses templates to retrieve and display data from a database

67
Q

What represents all the tables in the database and their relationships in a simple graphical format?

A

Data model

68
Q

The relationship example of each painter painting many paintings, and each painting being painted by one painter is an example of _______________________ type of relationship.

A

One-to-many

69
Q

Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?

A

Database management system

70
Q

Each table in a database must have a primary key (PK). (T/F)

A

True

71
Q

What is the role of a foreign key in a database?

A

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
Q

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)

A

False

73
Q

In an ERD, _____ is a person, place, event, or thing for which we intend to collect and store data about.

A

Entity

74
Q

When creating a database table, we should always select “auto number” as the Primary Key’s data type. (T/F)

A

False