CIS Unit 3
Match the reasons why business analysis is difficult using operational databases on the left with their correct explanations on the right. (EMTUM) 1. Inconsistent Data Definitions matches 2. Lack of Data Standards 3. Poor Data Quality 4. Inadequate Data Usefulness 5. Ineffective Direct Data Access
1. Inconsistent Data Definitions matches 1 A: EVERY DEPARTMENT had its own method for recording data so when trying to share information, data did not match and users did not get the data they really needed. 2. Lack of Data Standards 2 A: MANAGERS need to perform cross-functional analysis using data from all departments, which differed in granularities, formats, and levels. 3. Poor Data Quality 3 A: THE DATA, if available, were often incorrect or incomplete. Therefore, users could not rely on the data to make decisions. 4. Inadequate Data Usefulness 4 A: USERS could not get the data they needed; what was collected was not always useful for intended purposes. 5. Ineffective Direct Data Access 5 A: MOST DATA stored in operational databases did not allow users direct access; users had to wait to have their queries or questions answered by MIS professionals who could code SQL.
Which of the following database systems use SQL (select all that are true).
1. Oracle Database 2. Microsoft SQL server 3. PostgresSQL 4. MySQL
If a process changes, which of these may also need changing depending on the desired benefit? 1. Barrier 2. Tool 3. Input
All of them.
Which of the following are true about Algorithms.
- An Algorithm is a method for doing something. - An Algorithm is a list of steps to follow (a well defined procedure or formula) in order to solve a problem.
Match the benefits on the right with its correct type on the left. - Tangible benefits - Tangible benefits - Tangible benefits - Intangible benefits - Intangible benefits - Intangible benefits
- Decreased expenses - Decreased response time - Increased quality - Improved decision making - Improved morale - Improved goodwill
Which of these properly charcterize the AI landscape?
- Machine Learning is a subset of Artificial Intelligence. - Deep Learning is a subset of Machine Learning.
Which of the following are common SQL commands?
- SELECT - FROM - WHERE
Which of the following are true statements about Functions in R?
- The expressions (commands of logic) for a function are typically contained within braces {} - Functions have to be defined before they can be used.
Match the sustainable MIS infrastructure component on the left with the correct definition on the right. 1. Grid computing 2. Virtualized 3. Cloud Computing
1. A collection of computers, often geographically dispersed, that are coordinated to solve a common problem. 2. Creates multiple virtual machines on a single computing device. 3. Stores, manages, and processes data and applications over the Internet rather than on a personal computer or server.
Match the testing type on the left with its correct definition on the right. 1. Alpha Testing 2. Development Testing 3. Integration Testing 4. System Testing 5. User Acceptance Testing (UAT) 6. Unit Testing
1. ASSESS if the entire system meets the design requirements of the users 2. TEST the SYSTEM to ensure it is bug-free 3. VERIFY that SEPARATE SYSTEM can work together, passing data back and forth correctly 4. VERIFY that the UNITs or PIECEs of code function correctly when integrated 5. DETERMINE if the system satisfies the user and business requirements 6. Test INDIVIDUAL units or pieces of code for a system
Match the Cloud Computing environment on the left with its correct example on the right. 1. Public Cloud 2. Private Cloud 3. Community Cloud 4. Hybrid Cloud
1. Amazon Web Services 2. Bank of sensitive information 3. All Colorado state government organizations 4. Cloud bursting
Which of the following are advantages of Bitcoin
1. Any well-connected node in the Bitcoin blockchain can determine, with certainty, whether a transaction does or does not exist in the data set. 2. A prohibitively high cost to attempt to rewrite or alter transaction history
Systems Thinking recognizes the role of Barriers and Tools. 1. Something that holds a process back is a ____. 2. Something that helps a process move forward is a _____.
1. Barrier 2. Tool
Select the correct definition on the right with the virtualization type on the left. 1. Storage virtualization 2. Network virtualization 3. Server virtualization
1. Combines multiple network STORAGE devices so they appear to be a single storage device. 2. Combines networks by SPLITTING the available bandwidth into independent channels that can be assigned in real time to a specific device. 3. Combines the PHYSICAL resources, such as servers, processors, and operating systems, from the applications.
Select the three components of a sustainable MIS infrastructure. Grid computing Cloud computing Carbon computing Virtualized computing Ewaste computing
1. Grid Computing 2. Cloud Computing 3. Virtualized Computing
------- is a distributed ledger that provides a way for information to be recorded and shared by a community.
Blockchain
A doctor notices that a patient is due for a certain medical procedure or test. The doctor initiates a transaction marked with the patient's unique digital identity within the individual's ______ wallet.
Blockchain
What are the specific business requests the system must meet to be successful, so the analysis phase is critical because business requirements drive the entire systems development effort?
Business Requirements
____________ EXPRESSES the SPECIFIC NUMBER of instances in an entity.
Cardinality
Module --------- 9a
Chp. 6 Business Intelligence
MODULE ------- 8A
Chp. 6 Structuring and Storing Data
What is a model for enabling ubiquitous, convenient, on-demand network access to a shared pool of configurable computing resources (e.g., networks, servers storage, applications, and services) that can be rapidly provisioned and released with minimal management effort or service provider interaction?
Cloud Computing
Integrity __________ are rules that help ensure the quality of information.
Constraints (Integrity Constraints)
What is the PROCESS of TRANSFERRING information from a legacy system to a new system?
Conversion
___________ is the PROCESS of TRANSFERRING information from a legacy system to a new system.
Conversion
____________ Maintenance makes system changes to repair design flaws, coding errors, or implementation issues.
Corrective (Maintenance)
What makes system changes to repair design flaws, coding errors, or implementation issues?
Corrective Maintenance
Select the four functions that a Database Management System(DBMS) can perform on data in a Database? - Duplicate data - Read data - Forecast data - Delete data - Update data - Govern data - Cluster data - Create data
Create data Read data Update data Delete data
Bitcoin uses encryption to maintain the integrity of transactions, which is why it is called a ________________.
Cryptocurrency
What is the common term for the representation of multidimensional information?
Cube
Software ____________ MODIFIES SOFTWARE to meet specific user or business requirements.
Customization (Software Customization)
A(n) (virtual) ------ center is a facility used to house management information systems and associated components, such as telecommunications and storage systems.
Data (Center)
What is the collection of data from various sources for the purpose of data processing?
Data Aggregation
Who is a business analytics specialist who uses visual tools to help people understand complex data?
Data Artist
What is a facility used to house management information systems and associated components, such as telecommunications and storage systems?
Data Center
Select the two terms representing the smallest or basic unit of information. Data dictionary Data-driven website Data element Data field
Data Element Data Field
What contains a subset of data warehouse information?
Data Mart
Who extracts knowledge from data by performing statistical analysis, data mining, and advanced analytics on big data to identify trends, market changes, and other relevant information?
Data Scientist
What is a Logical Collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks?
Data Warehouse
What compiles all of the metadata about the data elements in the data model?
Data dictionary
What maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses)?
Database
MODULE ---------- 11a - - -
Database Basics - - -
What creates, reads, updates, and deletes data in a database while controlling access and security?
Database management system
The ____________ Phase establishes descriptions of the desired features and operations of the system, including screen layouts, business rules, process diagrams, pseudo code, and other documentation.
Design (Design Phase)
Which phase establishes descriptions of the desired features and operations of the system, including screen layouts, business rules, process diagrams, pseudo code, and other documentation?
Design Phase
The ____________ Phase takes all the detailed design documents from the design phase and transforms them into the actual system.
Development (Development Phase)
Which phase takes all the detailed design documents from the design phase and transforms them into the actual system?
Development Phase
A(n) entity-relationship __________ is a TECHNIQUE for documenting the entities and relationships in a database environment.
Diagram (Entity-Relationship Diagram)
What means the MIS infrastructure can be automatically scaled up or down based on needed requirement?
Dynamic scaling
What stores information about a person, place, thing, transaction, or event?
Entity
AI's modern usage traces back to the 1980s when AI was applied to ________ that allowed computers to reason by following a series of "if-then" rules - i.e., instructions to the computer that if this happens, then do that.
Expert System
What is a system that users computerized advisory programs to imitate the reasoning processes of experts in solving difficult problems?
Expert System
What is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse?
Extraction, Transformation, and Loading (ETL)
What is the application of big data analytics to smaller data sets in near-real or real-time in order to solve a problem or create business value?
Fast Data
___________ is the measure of the tangible and intangible benefits of an information system.
Feasibility
A(n) ------ is a characteristic of a table.
Field
What 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?
Foreign key
_________ Algorithm is an artificial intelligence system that mimics the evolutionary, survival-of-the-fittest process to generate increasingly better solutions to a problem.
Genetic (Algorithm)
What is an artificial intelligence system that mimics the evolutionary, survival-of-the-fittest process to generate increasingly better solutions to a problem?
Genetic Algorithm
What is a collection of computers, often geographically dispersed, that are coordinated to solve a common problem?
Grid Computing
Select the three benefits of Cloud Services. Greater reliability Less reliability Lower availability Higher availability Less efficient accessibility Improved accessibility
Higher availability Greater reliability Improved accessibility
------ management is a broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise) and controlling their access to resources within that system by associating user rights and restrictions with the established identity.
Identity (management)
In the ____________ Phase, the organization places the system into production so users can begin to perform actual business operations with it.
Implementation (Phase)
In which phase does the organization place the system into production so users can begin to perform actual business operations with it?
Implementation Phase
MODULE ------------- 12A - - -
Implementing Digital Innovations - - -
Select two terms that describe the process for weeding out, fixing, or discarding inconsistent, incorrect, or incomplete information. Information cleansing Information key Information scrubbing Information integrity Information cube
Information Cleansing Information Scrubbing
What is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information?
Information cleansing
What is a measure of the quality of information?
Information integrity
An open system has ___________.
Inputs Outputs
_________ benefits are difficult to quantify or measure.
Intangible
What are difficult to quantify or measure?
Intangible Benefits
A(n) ______ agent is a special-purpose knowledge-based information system that accomplishes specific tasks on behalf of its users.
Intelligent (Agent)
------ Systems are various commercial applications of artificial intelligence.
Intelligent (System)
What is a special-purpose knowledge-based information system that accomplishes specific tasks on behalf of its users?
Intelligent agent
What are various commercial applications of artificial intelligence?
Intelligent systems
Data ------ is the time it takes for data to be stored or retrieved.
Latency (Data Latency)
A(n) _________ system is an OLD SYSTEM that is fast approaching or beyond the end of its useful life within an organization.
Legacy (System)
What is an OLD SYSTEM that is fast approaching or beyond the end of its useful life within an organization?
Legacy System
The __________ view of information focuses on how individual users logically access information to meet their own particular business needs.
Logical View of information
In the _________ Phase, the organization performs changes, corrections, additions, and upgrades to ensure the system continues to meet business goals.
Maintenance (Phase)
Which phase does the organization perform changes, corrections, additions, and upgrades to ensure the system continues to meet business goals?
Maintenance Phase
What is a business function, which moves information about people, products, and processes across the company to facilitate decision making and problem solving?
Management Information Systems
A Project ____________ is an INDIVIDUAL who is an expert in project planning and management, defines and develops the project plan, and tracks the plan to ensure the project is completed on time and on budget.
Manager (Project Manager)
What occurs between two entities in which an instance of one entity is related to many instances of another and one instance of the other can be related to many instances of the first entity?
Many-to-Many Relationship
What provides details about data?
Metadata
----- -Valued Attribute means having the potential to contain more than one value for an attribute
Multi(-Valued Attribute)
What means having the potential to contain more than one value for an attribute?
Multi-Valued Attribute
What allows more than one piece of software to be used at a time?
Multitasking
___________ allows more than one piece of software to be used at a time.
Multitasking
What is a category of AI that attempts to emulate the way the human brain works?
Neural Network
_________ Network is a category of AI that attempts to emulate the way the human brain works.
Neutral (Network)
What is assigned to an attribute when no other value applies or when a value is unknown?
Null-valued attribute
------ -the-Shelf Application Software SUPPORTS GENERAL BUSINESS processes and does not require any specific software customization to meet the organization's needs.
Off (Off-the-Shelf Application Software)
What SUPPORTS GENERAL BUSINESS processes and does not require any specific software customization to meet the organization's needs?
Off-the-Shelf Application Software
A(n) ----- to ----- relationship is between two entities in which an instance of one entity can be related to MANY instances of a related entity.
One-to-Many (Relationship)
What occurs when an instance of one entity can be related to only one instance of a related entity?
One-to-One Relationship
_________ system software CONTROLS the application software and manages how the hardware devices work together.
Operating (Operating System Software)
What CONTROLS the application software and manages how the hardware devices work together?
Operating System Software
Bitcoin is ___________; every user is allowed to connect to the network, send new transactions to it, verify transactions, and create new blocks.
Peer-to-peer
What deals with the physical storage of information on a storage device?
Physical View of information
The Project __________ is a formal, approved document that manages and controls the entire project.
Plan (Project Plan)
The __________ Phase establishes a high-level plan of the intended project and determines project goals.
Planning (Phase)
Which phase establishes a high-level plan of the intended project and determines project goals?
Planning Phase
__________ Maintenance makes system changes to reduce the chance of future system failure.
Preventive (Maintenance)
What makes system changes to reduce the chance of future system failure?
Preventive Maintenance
A(n) ________ key is a field (or group of fields) that uniquely identifies a given record in a table.
Primary (key)
What is a field that UNIQUELY identifies a given RECORD in a table?
Primary Key
A(n) ___________ is a temporary activity a company undertakes to create a unique product, service, or result.
Project
What is a temporary activity a company undertakes to create a unique product, service, or result.
Project
Who is an INDIVIDUAL who is an expert in project planning and management, defines and develops the project plan, and tracks the plan to ensure the project is completed on time and on budget?
Project Manager
What is a formal, approved document that manages and controls the entire project?
Project Plan
What describes the business need (the problem the project will solve) and the justification, requirements, and current boundaries for the project?
Project Scope
Which tool helps users graphically design the answer to a question against a database?
Query-by-example (QBE)
A(n) _________ is a collection of related data elements.
Record
Information __________ is the duplication of data, or the storage of the same data in multiple places.
Redundancy (Information Redundancy)
A(n) ___________ database model stores information in the form of logically related two-dimensional tables.
Relational (Relational Database Model)
A(n) __________ database management system allows users to create, read, update, and delete data in a relational database.
Relational (Database Management System DBMS)
A(n) ----- is a central location in which data is stored.
Repository
____________ Management is the process of managing changes to the business requirements throughout the project.
Requirements
Business __________ are the specific business requests the system must meet to be successful, so the analysis phase is critical because business requirements drive the entire systems development effort.
Requirements (Business Requirements)
What is the process of managing changes to the business requirements throughout the project?
Requirements Management
The Project _________ describes the business need (the problem the project will solve) and the justification, requirements, and current boundaries for the project.
Scope (Project Scope)
____________-tenancy implies that each customer or tenant must purchase and maintain an individual system.
Single(-tenancy)
What means having only a single value of each attribute of an entity?
Single-Valued Attribute
------- is the set of instructions the hardware executes to carry out specific tasks.
Software
What is the set of instructions the hardware executes to carry out specific tasks?
Software
What MODIFIES SOFTWARE to meet specific user or business requirements?
Software Customization
What delivers applications over the cloud using a pay-per-use revenue model?
Software as a Service
------- Data has a defined length, type, and format and includes numbers, dates, or strings such as Consumer Addresses
Structured Data
What is a tool that asks users to write lines of code to answer questions against a database?
Structured query language
The ----- Development Life Cycle is the OVERALL PROCESS for DEVELOPING information systems, from planning and analysis through implementation and maintenance.
System (System Development Life Cycle)
------- software CONTROLS how the VARIOUS TECHNOLOGY tools work together along with the application software.
System (System Software)
What is the OVERALL PROCESS for DEVELOPING information systems, from planning and analysis through implementation and maintenance?
System Development Life Cycle
What CONTROLS how the VARIOUS TECHNOLOGY tools work together along with the application software?
System Software
What provides an end-to-end view of how operations work together to create a product or service?
System Thinking
What is a way of monitoring the entire system by viewing multiple inputs being processed or transformed to produce outputs while continuously gathering feedback on each part?
Systems Thinking
A(n) _______ is composed of rows and columns that represent an entity.
Table
________ Benefits are easy to quantify and typically measured to determine the success or failure of a project.
Tangible
What are easy to quantify and typically measured to determine the success or failure of a project?
Tangible Benefits
The __________ Phase brings all the project pieces together into a special testing environment to eliminate errors and bugs and verify that the system meets all the business requirements defined in the analysis phase.
Testing (Phase)
Which phase brings all the project pieces together into a special testing environment to eliminate errors and bugs and verify that the system meets all the business requirements defined in the analysis phase?
Testing Phase
SQL databases are often optimized to minimize redundancy. This means ________________.
The same piece of information is not repeated in in multiple places in a database.
True or False: Databases today scale to exceptional levels, allowing all types of users and programs to perform information processing and information-searching tasks.
True
True or false: Business-critical integrity constraints tend to mirror the very rules by which an organization achieves success.
True
MODULE ---------- 10a - - -
Types of Software - - -
------ data is not defined and does not allow a specific format and is typically free-form text such as emails, twitter tweets and text messages.
Unstructured Data
__________ software provides additional functionality to the operating system.
Utility (Utility Software)
What provides additional functionality to the operating system?
Utility Software
Why does a database offer increased information security?
Various security features of databases ensure that individuals have only certain types of access to certain types of information.
MODULE -------- 13A - - -
Virtual, Grid, and Cloud - - -
A data ________ is a Logical Collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.
Warehouse (Data Warehouse)
Select the statement below that accurately reflects a database.
While a database has only one physical view, it can easily support multiple logical views that provides for flexibility.
One primary goal of a database is to eliminate information redundancy by recording each piece of information in _______ place(s) in the database.
only one (Information Redundancy)
Place the Phases in the Systems Development Life Cycle in the correct order.
1. Planning 2. Analysis 3. Design 4. Development 5. Testing 6. Implementation 7. Maintenance
Select the THREE accurate statements reflecting the Business Advantages of a Relational Database. 1. Reduced information redundancy 2. Reduced information integrity 3. Increased information redundancy 4. Increased information security 5. Increased information integrity 6. Reduced flexibility
1. Reduced information redundancy 4. Increased information security 5. Increased information integrity
Match the form of application distributed method on the left with its definition on the right. 1. Single user license 2. Network user license 3. Site license 4. Application service provider license
1. Restricts the use of the software to one user at a time. 2. Enables anyone on the network to install and use the software. 3. Enables any qualified users within the organization to install the software, regardless of whether the computer is on a network. Some employees might install the software on a home computer for working remotely. 4. Specialty software paid for on a license basis or per-use basis or usage-based licensing.
Which of the following statements are correct about SQL (select all that are true).
1. SQL is considered "the" language for getting data out of a database and working with it. 2. SQL is a language 3. SQL is the language of relational database management systems (RDBMS). IT IS NOT - an application - not a language for a hierarchal DBMS
Select the two types of Application Software. - Spreadsheet Software - Utility Software - Operating System Software - Word Processing Software
1. Spreadsheet Software 4. Word Processing Software
Match the system implementation method on the left with its correct definition on the right. 1. Parallel Implementation 2. Plunge Implementation 3. Pilot Implementation 4. Phased Implementation
1. USES both the legacy system and new system until all users verify that the new system functions correctly 2. DISCARDS the legacy system and immediately migrates all users to the new system 3. ASSIGNS a small group of people to use the new system until it is verified that it works correctly; then the remaining users migrate to the new system 4. INSTALLS the new system in phases (for example, by department) until it is verified that it works correctly
Match the Cloud Computing benefit on the left with the correct reason for the benefit on the right. 1. On-demand self-service 2. Broad network access 3. Multi-tenancy 4. Rapid elasticity 5. Measured service
1. Users can increase storage and processing power as needed 2. All devices can access data and applications 3. Customers share pooled computing resources 4. Storage, network bandwidth, and computing capacity can be increased or decreased immediately, allowing for optimal scalability 5. Clients can monitor and measure transactions and use of resources
Match the key term on the left with its correct definition on the right. 1. Variety 2. Veracity 3. Volume 4. Velocity
1. Variety 1 A: Different forms of structured and unstructured data 2. Veracity 2 A: The uncertainty of data, including biases, noise, and abnormalities 3. Volume 3 A: The scale of data 4. Velocity 4 A: The analysis of streaming data as it travels around the Internet
Select the five primary reasons project fail. 1. Too much user participation 2. Changing technology 3. The cost of finding errors 4. Misunderstanding of tangible benefits 5. Balance of the triple constraints 6. Unclear or missing business requirements 7. Skipped SDLC phases
2. Changing technology 3. The cost of finding errors 5. Balance of the triple constraints 6. Unclear or missing business requirements 7. Skipped SDLC phases
Select the statement that accurately defines the relationship between Entities and Attributes in a Relational Database. 1. Each record in an entity occupies multiple rows in its respective table. 2. Each attribute of an entity occupies a separate column of a table. 3. Each record in an attribute occupies one row in its respective table. 4. Each key in an entity occupies one row in its respective table.
2. Each attribute of an entity occupies a separate column of a table.
Select the two types of System Software. - Spreadsheet Software - Utility Software - Operating System Software - Word Processing Software
2. Utility Software 3. Operating System Software
In the __________ Phase the firm analyzes its END-USER business requirements and refines project goals into defined functions and operations of the intended system.
Analysis (Analysis Phase)
In which Phase does the firm analyzes its END-USER business requirements and refines project goals into defined functions and operations of the intended system?
Analysis Phase
_________ software is used for specific information processing needs, including payroll, customer relationship management, project management, training, and many others.
Application (Application Software)
What is used for specific information processing needs, including payroll, customer relationship management, project management, training, and many others?
Application Software
MODULE ----------- 14a - - -
Approaches to Artificial Intelligence - - -
_________ intelligence simulates human thinking and behavior, such as the ability to reason and learn.
Artificial (intelligence)
What simulates human thinking and behavior, such as the ability to reason and learn?
Artificial Intelligence (AI)
A(n) ___________ is the DATA ELEMENT ASSOCIATED with an entity.
Attribute
The DISTINCT command in SQL is used to ___________.
Avoid returning Duplicate Data.
