Midterm Flashcards
Which question below can be answered using business intelligence?
Lowest sales per week compared with the economic interest rate
Data and information are the same thing. (T / F)
False
Which executive-level person is responsible for overseeing and managing the organization’s information systems?
CIO
A computer-based information system includes:
Data
Hardware
Software
People
Telecommunication Networks
What is a way of monitoring the entire system in a company, by viewing the multiple inputs being processed to produce outputs?
Systems thinking.
MIS is a business function. Which of the following does MIS perform to help aid the company in decision making and problem solving?
Moves information about people.
Moves information about processes.
Moves information about products.
Blockchain refers to interconnected Internet enabled devices or things collecting and sharing data without human intervention. (T/F)
False
A well-educated professional who creates, modifies, and/or synthesizes information/knowledge as a fundamental part of their job is a:
knowledge worker
Which of the following represents the core drives of the information age?
Data, Information, Business Intelligence, Knowledge.
IS personnel are extremely valuable to a company because they possess integrated knowledge and skills in all of the following areas except:
secretarial knowledge
The functional area/department that is responsible for identifying and selecting potential vendors/suppliers is the Warehouse functional area/department. (T/F)
False
One of the disadvantages of the business process approach is increased lead times. (T/F)
False
Stock status inquiry is done by the Procurement department. (T/F)
False
Business Process Reengineering (BPR) involves the radical redesign of core business processes to achieve dramatic improvements in productivity, cycle times and quality. (T/F)
True
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?
Processing payroll
Strategic Planning is a customer facing process. (T/F)
False
Which of the following are characteristics of business processes?
Has internal or external customers
Produces one or more outputs of value to customers
Usually cross-functional
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?
Silo Effect
The delivery date on a Purchase Order refers to when the Purchase Order document will be delivered to the Customer. (T/F)
False
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)
Receive packing list
Create goods receipt document
Receive packing list
In the fulfillment (COM) process, the sales order is created after we receive the invoice from the customer. (T/F)
False
Which of the following is not among the responsibilities of the Operations/production functional area/department?
Creating Quotations to be sent to potential customers
In a business process all activities must be completed sequentially. (T/F)
False
System
Collection of interrelated parts that work together to achieve a common goal
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.
Information System (IS)
Combinations of hardware, software, and telecommunications networks that people build and use to collect, create, and distribute useful data in organizations.
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.
VoIP
Use of Internet technologies for placing telephone calls
High quality of transmission possible
Ability to call from any place with Internet connection
Knowledge worker
A well-educated professional who creates, acquires, processes, synthesizes, disseminates, analyze and uses information
Knowledge Society
Also called digital society, new economy,
Downside: Digital divide
The contrast over available information technology
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
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
Silo Effect
People complete their tasks in their functional silos without regard to the consequences to the other departments and the company.
Lead time
Time required to manufacture an item (e.g. How far in advance should we obtain the raw materials from suppliers?)
Cycle time
Time required to process an order
List of departments
Purchasing, warehouse, operations/production, sales & marketing, research & development, finance & accounting, HR, and IT
Purchasing Department Duties
Buying materials
Contacting/identifying/evaluating suppliers
Responsible for creating and sending out purchase orders
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)
Operations/Production Department Duties
Managing operations/production -Design workflow -Plan capacity -Schedule operations Execute productions Quality inspection on finished goods
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
Research & Development Department Duties
Conduct research
Improve existing
products/services
Create new products/services
Improve processes used for creating products/services
Finance & Accounting Department Duties
Financial statements
Incoming/outgoing payments to suppliers
Budgeting
Capital/investment management
HR Department Duties
Hiring, training, promoting, and firing employees
benefits /sick time and paid time off
Resolving conflicts/unions
Payroll
IT Department Duties
Infrastructure
- Executing business transactions
- Information about the processes, people, and products
Which of the following does NOT represent a cross-functional business process?
Processing payroll
Automation
Computerizing manual tasks: answering phones with computers
Streamlining
Improving business processes by removing duplicate jobs in the process or by removing bottlenecks
Business Process Reengineering (BPR)
Involves the radical redesign of core business processes to achieve dramatic improvements in productivity, cycle times and quality.
Customer facing process
Results in a product or service that is received by an organization’s external customer
Business facing process
Invisible to the external customer but essential to the effective management of the business
4 Major business processes
Buying
Making
Selling
Financing
Sales Order
A document that is prepared by the company, which
Specifies products requested by the customer
Purchase Order
Contract with a supplier to purchase certain materials or services under specific conditions (quantity, price, delivery date, etc.)
Database
Organized collection of related data
Maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses)
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
Database Administrator (DBA):
Person who is responsible for developing and managing the organization’s database
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)
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
Data Model
A data model represents all the tables in the database and their relationships in a simple graphical format
Entity-Relationship (E-R) Diagram (ERD)
Most commonly used technique for data modeling - documenting the entities and relationships in a database environment
An ERD consists of the following:
ENTITIES (Tables)
ATTRIBUTES (Fields)
RELATIONSHIPS (Relationships btw tables)
Three types of relationships
One-to-Many Relationships (1:m)
Many-to-Many Relationships (m:m)
One-to-One Relationships (1:1)
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
Many-to-Many Relationships (m:m)
Each employee is assigned to many projects (m)
Each project has many employees assigned to it (m)
One-to-One Relationships (1:1)
Each person can have only one passport (1)
Each passport belongs to only one person (1)
Query by example:
is a technique that uses templates to retrieve and display data from a database
What represents all the tables in the database and their relationships in a simple graphical format?
Data model
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
Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?
Database management system
Each table in a database must have a primary key (PK). (T/F)
True
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
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
In an ERD, _____ is a person, place, event, or thing for which we intend to collect and store data about.
Entity
When creating a database table, we should always select “auto number” as the Primary Key’s data type. (T/F)
False
