MIS 204 Final Review

A _________________________ stores data in such a way that It becomes easier to retrieve It is easier to manipulate It is easier to produce information

Database Management System

An advertising manager is looking to do a "What-if" analysis as part of the decision to determine how to spend advertising dollars. This is a functionality of

Decision Support System

This attributes are the attributes that do not exist in the physical database, but their values are derived from other attributes present in the database. For example, average_salary in a department should not be saved directly in the database, instead it can be derived. For another example, age can be derived from data_of_birth.

Derived attribute

These are the group of people who actually work on the designing part of the database. They keep a close watch on what data should be kept and in what format. They identify and design the whole set of entities, relations, constraints, and views.

Designers

Which of the following is TRUE about data? Requires reflection and synthesis. Difficult to structure, capture and transfer. Discrete objective facts about the world. Often tacit.

Discrete objective facts about the world.

If your business has grown more complex due to the expansion of remote and global work environments, the accelerated pace of business operations, rapidly increasing amounts of data that workers have to contend with, trade knowledge, store and exchange files, create and jointly modify documents, and interact with each other in real time in collaborative workspaces. Which system will enable employees in your organization to achieve that?

Enterprise Collaboration System

The Entity Relation Model models

Entities and Relationships

Which system provides critical information from a wide variety of internal and external sources in easy-to-use displays to executives and managers.

Executive Information Systems

To provide critical information from a wide variety of internal and external sources in easy-to-use displays to executives and managers is the functionality of

Executive information Systems (EIS)

A computer based application that employs a set of rules based upon human knowledge to solve problems that require human expertise is

Expert System

There are lots of ways to make your business more successful. But if your company needs to communicate and share information with clients and other external parties, as a business owner who is considering to utilize Information technology, you will consider installing which type of network.

Extranet

Analog computers store and process data in the digital form. T/F

False

Companies use predictive information coupled with other information types to make decisions regarding corrective actions. T/F

False

In the Fetch Stage, the Control Unit or Arithmetic Logic Unit then performs (carry out) the instruction from the decode stage. T/F

False

Special purpose computers can work in all environments. T/F

False

The Machine Cycle goes in the following order:

Fetching, Decoding, Executing, Storing

The time dimension of information includes two aspects: having access to information when you need it and _______________.

Having access to information at the right moment of the time.

Which is NOT a fundamental role of IS in business? Support strategies for competitive advantage. IS has no role in Business. Support business processes and operations. Support decision-making.

IS has no role in Business

Receiving, storing, distributing inputs, raw materials to the product.

Inbound logistics

Knowledge derived from data, data presented in a meaningful context, or processed data.

Information

Equipment and programs used to process raw data into information are termed as

Information Technology

What is information?

Information with a particilar meaning within a specific context.

A function that involves capturing and assembling elements that enter the system to be processed is known as:

Input

Five basic functions of a computer system can be classified as

Input, Processing, Output, Feedback, and Control

Data is distributed throughout the computer system in the following order:

Input, Processing, Output, Storage

A local network that uses network technology as a tool to facilitate communication between people or workgroups to improve the data sharing capability and overall knowledge base of an organization's employees is called

Intranet

Which is NOT a good characteristic of a Management Information System? Relevance Accuracy Timeliness Irrelevance

Irrelevence

What is Waterfall Methodology?

It is a methodology that derives its name due to the cascading effect from one phase to the other. In this model each phase well defined starting and ending point, with identifiable deliveries to the next phase.

What is power in the Information Age?

Knowledge

Information System that manage processes for capturing and applying knowledge and expertise, collect relevant knowledge and make it available wherever needed, and link firm to external sources of knowledge is known as

Knowledge Management System

People who spend most of their time communicating and collaborating in teams and workgroups and creating, using, and distributing information are known as

Knowledge Workers

Which of the following systems deals with planning for, development, management, and use of information technology tools for management?

Management Information Systems

The main memory is referred to as the internal memory of primary memory of the computer. It is also known as RAM. RAM stands for

Random Access Memory

Heart rate monitoring is an example of

Real Time Processing System

CPU contains a few special purpose high-speed temporary memory storage units known as

Registers

Which is one of the limitations of the File Based System?

Seperation and Isolation.

A word processing program would be an example of:

Software

Maintaining records on customers, employees, and products is the functionality of which device.

Storage Device

A set of attributes (one or more) that collectively identifies an entity in an entity set.

Super Key

Activities of the value chain that either add value by themselves or through important relationships with primary and other support activities.

Support activities

The use of information systems because of necessity describes the business objective of

Survival

Software that controls and supports the operations of a computer system is known as

System Softwares

Knowledge that resides in worker are also known as

Tacit Knowledge

Which is NOT a Stakeholder in a Business Environment? The Process The Partners The Customers The Community

The Process

New entrants to an industry are important because, with new competitors, the intensity of competitive rivalry in an industry generally increases. One result may be a decline in sales and lower returns for many firms in the industry. The seriousness of the threat is affected by two factors: barriers to entry and expected reactions from established firms in the industry. This signifies which of the Five Forces?

Threat of New Entrants

All firms must recognize that they compete against firms producing substitute products, those products that are capable of satisfying similar customer needs but come from outside the industry and thus have different characteristics. The prices of the substitute products, the need to match quality the performance differences and the cost associated with creating perceived differentiation may significantly influence potential profits.

Threat of Substitutes

Which of the following is TRUE about Systems Thinking? To view something partially. Looking at what is right in front of you rather than figuring out what effects may be produced by changing that thing. To view something "with blinders on" or in a "stovepipe." To viewing something holistically

To viewing something holistically

A MIS also provides companies with diagnostic information. Companies use diagnostic information coupled with other information types to make decisions regarding corrective actions. T/F

True

A database schema is the skeleton structure that represents the logical view of the entire database. T/F

True

A management information system (MIS) is a set of systems and procedures that gather information from a range of sources, compile it and present it in a readable format. T/F

True

Agile management or agile project management is an iterative and incremental method of managing the design and build activities for engineering, information technology, and new product or service development in a highly flexible and interactive manner. T/F

True

An Integrated combinations of the several types of information systems to provide a variety of functions is also known as Cross Functional Information Systems. T or F

True

Data is stored in tables called relations. T/F

True

Descriptive information provides the "what is" state of the company. Example of "what is" information include Sales Reports. T/F

True

In the Decode Stage, the Control Unit translates the instruction into machine language or binary code. T/F

True

Information technology (IT) is the use of any computers, storage, networking and other physical devices, infrastructure and processes to create, process, store, secure and exchange all forms of electronic data. T/F

True

Management Information Technology is all about delivering the right information to the right people at the right time in the right format at a reasonable cost. T/F

True

Multi-value attributes may contain more than one values. T/F

True

Network resources refer to forms of data, information and hardware devices that can be accessed by a group of computers through the use of a shared connection. T/F

True

One significant advantage of a good MIS system is its ability to pool information from a range of sources into a single database and presenting the information in a logical format. T/F

True

Success should also be measured by the effectiveness of the information technology in enhancing its organizational structures and culture. T or F

True

The data resources of information systems are typically organized, stored, and accessed by a variety of data resource management technologies. T/F

True

The information you conceive from data → The value you add to the information system. T/F

True

The reason why the idea Systems Thinking is so important is to avoid "unintended consequences" at all costs. T/F

True

When the right data are in the right place at the right time and are organized in the right way they become information. T/F

True

VLSI stands for

Very Large Scale Integration Technology

A MIS basically provides companies with four different types of information regarding the state of the Business. Descriptive information answers the question...

What is?

A MIS basically provides companies with four different types of information regarding the state of the Business. Prescriptive information answers the question...

What should be done?

Control Unit is an important component of CPU that

controls the flow of data and information

The third generation of computers used

integrated circuits

An architecture that divides the whole system into related but independent n modules, which can be independently modified, altered, changed, or replaced.

n-tier Architecture

Segmenting customers who are accessible in different ways. Access can be customer geography or customer scale.

Access-based positioning

What drawback in waterfall is addressed in agile methodology?

Agile development addresses the inflexibility of waterfall as it pertains to changing requirements.

Establishing new business linkages and alliances with customers, suppliers, competitors, consultants, and other companies. These linkages may include mergers, acquisitions, joint ventures, formation of virtual companies, or other marketing, manufacturing, or distribution agreements between a business and its trading partners.

Alliance Strategies

Which of the following statements best decribes the function of an entity relation model?

An ER model provides a view of the logic of the data and not the physical implementation.

Language-based, machine-readable representations of what a software process is supposed to do, or how a software process is supposed to accomplish its task is known as:

Application Programs

At this tier reside the application server and the programs that access the database. For a user, this application tier presents an abstracted view of the database. End-users are unaware of any existence of the database beyond the application. At the other end, the database tier is not aware of any other user beyond the application tier. Hence, the application layer sits in the middle and acts as a mediator between the end-user and the database.

Application Tier

While firms seek to maximize their return on invested capital, buyers are interested in purchasing products at the lowest possible price (the price at which sellers will earn the lowest acceptable return). To reduce cost or maximize value, customers bargain for higher quality or greater levels of service at the lowest possible price by encouraging competition among firms in the industry. The bargaining power may increase the potential profits of the buyers and reduce the potential profits for the suppliers. This signifies which of the Five Forces?

Bargaining Power of Customers

A manufacturer produces a daily operational report for a production line that is run in a batch window and delivered to managers in the early morning. This is an example of

Batch Processing System

CPU stands for

Central Processing Unit

Which is not one of the phases of CPU? Decoding Executing Communicating Fetching

Communicating

The intensity of rivalry in an industry depends upon the extent to which firms in an industry compete with one another to achieve strategic competitiveness and earn above-average returns. Competition can be based on price, quality, or innovation, each of which changes the costs and revenue within the industry. Because of the interrelated nature of firms' actions, action taken by one firm generally will result in retaliation by competitors. This signifies which of the Five Forces?

Competitive Rivalry

Generating audible signals to indicate proper entry of sales data will fall under which kind of activity.

Control

To improve the performance of a business process, which of the following is most relevant?

Control and Feedback

A self-monitoring and self-regulating system is also known as

Cybernetic System

What is data redundancy?

Data redundancy occurs when the same data are stored in multiple places unnecessarily.

___________________ is a collection of related data and data is a collection of facts and figures that can be processed to produce information.

Database

Arranging for a product to occupy a clear, desirable, distinctive place relative to competing products in the minds of target consumer.

Market positioning

These are the processes you use to persuade clients to purchase from you instead of your competitors e.g. advertising, promotions etc...

Marketing and Sales

Disruptive innovation is an unexpected change that causes a significant shift in demand for a particular product or service. Video stores were impacted by the disruptive innovation that occurred as movies began being available in DVD formats and the DVD industry is currently being impacted by the movement of movies to online formats. Shifts in the environment can cause changes in customer demand that businesses must be aware of and be ready to respond to change. This exemplifies which of the following. Doing business because you just received a MBA with 4.00 GPA Doing business because you because your forefathers did it. Doing business because you are highly motivated business professional. Necessity of doing business driven by industry level changes.

Necessity of doing business driven by industry level changes.

Update corporate database system is the functionality of

Operating Support System

Performing similar activities better than rivals.

Operational effectiveness

Collecting, storing, & distributing the product or service to buyers.

Outbound logistics

This schema pertains to the actual storage of data and its form of storage like files, indices, etc. It defines how the data will be stored in a secondary storage.

Physical Database Schema

What will sales look like next quarter? The question above related to the state of the Business will fall under which type of information.

Predictive Information

________________________ are those involved in the production of goods or service - Inbound logistics - Operations - Outbound logistics - Marketing and sales - Service

Primary Activities

Process control is an engineering discipline that deals with architectures, mechanisms and algorithms for maintaining the output of a specific process within a desired range. For instance, the temperature of a chemical reactor may be controlled to maintain a consistent product output. This is the functionality of which Operations Support System?

Process Control System

If customers perceive a product or service as unique, they generally are loyal to that brand. Thus, new entrants may be required to spend a great deal of money over a long period of time to overcome customer loyalty to existing products. This strategy is known as:

Product Differentiation

The second generation of computers used

transistors

The first generation of computers used

vacuum tubes