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