BCIS 3610 CH 5 + some from previous

20. (T/F) When a business finds that many of its business applications have to be updated or rewritten, it will be better if they replace them with an ERP system.

False

23. (T/F) A set of random or unrelated tasks performed to achieve a definite outcome is called a process.

False

24. (T/F) Another name for the World Wide Web is the Internet of Things

False

7. (T/F) Suppose an organization wishes to change for the better. It can accomplish that just by changing people's roles, responsibilities, and lines of authorities.

False

An example of the concept of feedback is a factory information system that is programmed to alert the manager if there is any decrease in productivity so the manager can take corrective steps to improve productivity.

False

T/F) One of the final steps in installing and using a large database involves "telling" the database management system (DBMS) the logical and physical structure of the data and the relationships among the data for each user.

False

T/F) Systems development projects should always be outsourced in order to allow an organization to focus on what it does best.

False

14. In a manufacturing organization, the supply chain is a key value chain whose primary activities include all of the following EXCEPT:

Finance and accounting (include inbound logistics, marketing and sales, customer service)

8. Sarah, as the head of a business division, wants to set up a network access account for a new employee. She should call the _____ to get this done.

Network Administrator

7. For most companies, the spheres of influence are _____, workgroup, and enterprise.

Personal

An information system that improves the productivity of individual users in performing stand-alone tasks is called a(n):

Personal IS

17. To develop software you need all these except ________.

Personal application software

11. _____ is a personal application software that includes a wide range of built-in functions for statistical, financial, logical, database, graphics, and date and time calculations.

Spreadsheet

5. Providing value to a _____ is the primary goal of any organization.

Stakeholder; NOT PRODUCT

_____ is a special-purpose programming language for accessing and manipulating data stored in a relational database.

Structured Query Language (SQL)

18. In the contemporary view of information systems, they are considered an integral part of the supply chain management process mainly because they: _________.

Are a means of producing output, and providing input into the process Aid in product transformation

In the context of the relational database model, projecting involves eliminating columns in a table.

true

It is possible to restrict access to data depending on the database user's privileges.

true

27. Suppose an oil exploration company wishes to collect, codify, and store knowledge that is used in the organization, they should use _______.

a knowledge management system

Suppose we have a table that stores student data. In that table we have a field - Student ID - that uniquely identifies each student. This field is known as the ____.

primary key

(T/F) When an organization uses cloud computing, they do not have to buy and maintain expensive hardware.

true

A database management system (DBMS) serves as an interface between an application program and a database.

true

For each data item, a data dictionary usually contains information such as the name of the data item, the range of values that can be used, and the amount of storage needed for the item.​

true

17. One zettabyte is _____ exabytes of data.

1000

9. A friend's computer came with Windows 8 operating system. Which of the following years was the computer most likely bought in?

2012

25. Which of the following are considered transactions in an information system? (1) money deposited in a bank account, (2) student recording her answer to a question in an online test, (3) customer adding an item to the online shopping cart, are

All of them; a transaction is any business-related exchange of information.

3. Google has developed its own mobile operating system called _____.

Android

1. "Kaizen" is the Japanese word for _________.

Continuous Improvement

17. The idea of _____ is a form of innovation that constantly seeks ways to improve business processes and add value to products and services.

Continuous Improvement

Last week Jake and Gina used their computer programming skills to illegally gain access to a local veterinary clinic's customer database. They stole the customers' names, addresses, and credit card numbers, and they're now using this information to purchase things from the Internet. Jake and Gina are _________.

Cybercriminals

2. A(n) _____ is a detailed description of all data used in a database.

Data Dictionary

12. A _____ is a subset of a data warehouse that is used by small- and medium-sized businesses and departments within large companies to support decision making.

Data Mart

27. _____ is the process of detecting and then correcting or deleting incomplete, incorrect, inaccurate, irrelevant records that reside in a database.

Data cleansing

7. A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

Data definition language

1. If an organization is taking a "store everything" approach to data, it will save all the data in its raw and unaltered form in a _____.

Data lake

Harrison works at a nationally known grocery store chain. He is analyzing sales data from the past five years to determine which low-selling products should be discontinued. Harrison is most likely a(n):

Data scientist

16. MySQL is a popular:

Database software; Database Management System (DBMS)

15. Which of the following theories explains how a new idea or product gains acceptance and spreads through a specific population or subset of an organization?

Diffusion of innovation theory

13. Each attribute in a relational database model can be constrained to a range of allowable values called a _____.

Domain

3. _____ involves reducing the number of employees to cut costs.

Downsizing

13. You might be an information systems worker if you _________.

Enjoy learning new techniques and enjoy working with people.

21. _____ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization.

Enterprise data modeling

____________ is a network based on Web technologies that allows selected outsiders, such as business partners and customers, to access authorized resources of a company's intranet.

Extranet

(T/F) A management information system (MIS) is exactly the same as a transaction processing system (TPS); the two terms can be used interchangeably.

FALSE

(T/F) Cybercriminals are hackers who try to steal business information or government data related to a nation's infrastructure, all for personal gain.

False

(T/F) Using a computer to forecast future sales and order more inventory before a shortage can occur is an example of information system feedback.

False

10. (T/F) A sustaining innovation is one that initially provides a lower level of performance than the marketplace has grown to accept.

False

10. (T/F) Data modeling usually involves setting a specific business goal and then analyzing the data and information needed to reach that goal.

False

15. (T/F) Proprietary software is mass-produced by software vendors to address needs that are common across businesses, organizations, or individuals.

False

18. (T/F) Either system software or application software, but not both, are needed for all types of computers.

False

2. (T/F) Windows 10 is an example of application software.

False

A clothing store chain tracks the sale of each product at each location. Managers use this information to calculate the organization's profits, to track inventory needs, and to determine which styles and fabrics are the most popular among its customers. This is an example of quality information that is ___________.

Flexible

26. _______ is an open-source software framework that includes several software modules that provide a means for storing and processing extremely large data sets.

Hadoop

25. Together, bits, characters, fields, records, files, and databases form the ______.

Hierarchy of data

28. The _____ is the world's largest computer network consisting of thousands of interconnected networks, all freely exchanging information.

Internet

14. One of the disadvantages of proprietary software is that ______________.

It can take a long time and significant resources to develop the required software features

14. Which of the following statements is true of a database?

It helps companies analyze information to open new market opportunities. NOT It provides an essential foundation for an organization's knowledge management and artificial intelligence systems.

A(n) _____ is an organized collection of people, procedures, software, databases, and devices that provides routine information to managers and decision makers.

Management information system (MIS)

4. The _____ task management technique of an operating system supports running a program on more than one central processing unit (CPU).

Multiprocessing

12. The process used to obtain the information system resources needed to provide the services necessary to meet a specific set of _______, no matter how broad or narrow, is known as system acquisition.

Needs

14. _____ is the principle that Internet service providers should be required to treat all Internet traffic running over their wired and wireless broadband networks the same, without favoring content from some sources and/or blocking or slowing content from others.

Net Neutrality

One method an IS professional might use to find a new job would be ____________.

Networking through an IS professionals' organization; Searching and applying for open positions on Internet job sites; Seeking referrals from colleagues, friends, and family members

22. Sara Beth and Taylor have developed a new software that they plan to distribute for free, allowing other software professionals to study, change, and improved it. Their software is an example of _________.

Open source software

2. The _____ group of a typical information systems organization is responsible for the day-to-day running of IS hardware to process the organization's information systems workload.

Operations

6. _____ refers to organizational subunits and the way they relate to the overall organization.

Organizational Structure

9. _____ is a long-term business arrangement in which a company contracts for services with an outside organization that has expertise in providing a specific function.

Outsourcing

19. A collection of fields all related to a single object, activity, or individual is a(n) _____.

Record

8. If you wish to develop expertise in database management, you must learn popular language known as ______.

SQL (Structured Query Language)

5. The use of middleware to connect disparate systems has evolved into an approach for developing software and systems called _____.

Service Oriented architecture

13. One of the advantages of off-the-shelf software is that ________________.

The initial cost is lower because the software firm can spread the development costs over many customers

1. One advantage of proprietary software versus off-the-shelf software is that _____.

The software provides a company a competitive advantage by solving problems in a unique manner

5. While building a data warehouse, you are converting dates to months. This second step in the ETL process is known as ______.

Transform (Extract, Transform, Load)

(T/F) A database is essential to the operation of a computer-based information system.

True

(T/F) A software suite is a collection of programs packaged together as a bundle and typically includes a word processor, spreadsheet program, graphics program, and more.

True

10. (T/F) Your friend has a Mac that runs OS X. If she needs to run a Windows app on it, she can set it to run Windows also.

True

11. (T/F) A field is typically a name, number, or combination of characters that describes an aspect of a business object.

True

11. (T/F) The successful implementation for change only happens when people accept the need for change and believe that it will improve factors such as productivity and/or customer satisfaction.

True

12. (T/F) An embedded system is a computer system that is implanted in and dedicated to the control of another device.

True

12. (T/F) When an organization hires another firm in another country to perform a specific function on its behalf, it is known as offshoring.

True

16. (T/F) Natural language processing involves the computer interacting in natural languages - like spoken English.

True

18. (T/F) The database approach to managing data is superior to the file-based approach.

True

19. (T/F) An example of the concept of feedback is a factory information system that is programmed to alert the manager if there is any decrease in productivity so the manager can take corrective steps to improve productivity.

True

24. (T/F) A database, a database management system, and the application programs that use the data, make up a database environment.

True

26. (T/F) The term data is used to label raw facts such as height and weight of a patient

True

4. (T/F) A relational model splits the information up into many two dimensional data structures.

True

4. (T/F) Perceived usefulness and ease of use of a system influence an individual's attitude toward the system.

True

8. (T/F) An operating system is a set of programs that controls the computer hardware and acts as an interface with applications.

True

9. (T/F) If "color" is an attribute, then "green" is a data item.

True

13. In terms of information systems, Wikipedia would be an example of _________.

a group IS

20. Haley's employer has asked her to review tens of thousands of social media posts about their company's products and compile this data into a database. In terms of the characteristics of big data, Haley is dealing with ________.

Variety

18. With _____, a software engineer drags and drops graphical objects such as buttons and menus onto an application form.

Visual programming

16. _____ programs can reduce the amount of disk space required to store a file or reduce the time it takes to transfer a file over the Internet.

Zip (File/Data Compression)

An enterprise data model is created only for documentation, but is otherwise inconsequential.

false

The smallest piece of data used by a computer is a(n) _____.

bit

Suppose a new tech startup wants to define the data model. They would then ____.

create the entity-relationship model

Kyle works for National Sporting Goods, where he manages critical data elements, such as identifying and acquiring new data sources, creating consistent reference data, and analyzing data for quality. Kyle is a _______.

data steward

In the relational database model, each row of a table represents a(n) _____.

entity

A database administrator (DBA) is an important nontechnical position responsible for defining and implementing consistent principles for a variety of data issues, including setting data standards and data definitions that apply across all the databases in an organization.

false

An attribute is a general class of people, places, or things for which data is collected, stored, and maintained.

false

DBMSs are used primarily for modeling data.

false

The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.

false

Two sets of fields can have a common primary key.

false

A _____ is a simple database program whose records have no relationship to one another.

flat file

The ____ model database makes it easy to develop queries that involve joining two tables.

relational

Suppose you wish to find what tables are in a database, what fields they have, and how they are related you would review the _____.

schema

Sometimes a database can contain "bad data," meaning incomplete, incorrect, inaccurate, or irrelevant records, which can be corrected or deleted through data cleansing.​

true

Most of the data that an organization must deal with is _____ data, meaning that it is not organized in any predefined manner.

unstructured

Haley's employer has asked her to review tens of thousands of social media posts about their company's products and compile this data into a database.​ In terms of the characteristics of big data, Haley is dealing with ________.

variety