MIS 290 Exam 1 Study Guide

Answer the following questions (p34) 1) A(n) _____________ is/are made of Mylar or metal and used for random-access processing, with the ability to access data in any order A. Magnetic tape B. Magnetic disk C. Optical discs D. Read-only memory (ROM) E. Cache RAMs 2) Answer with the correct term: Device made of plastic material resembling a cassette tape storing data sequentially 3) What is the function of your answer from question 2?

1) B. Magnetic disk 2) Magnetic tape 3) Stores records in a block or record separately with gaps between each block and record

Answer the following questions (p53) 1) Which of the following best describes fields in relational tables matching primary key columns in another table? A. Database engine B. Field key C. Foreign key D. Primary key 2) What is the purpose of your answer from question one?

1) C. Foreign key 2) Used for cross-referencing tables

Part 1: Write out in words what a DDBMS stands for (p56) Part 2: Which of the following is NOT an approach to setting up a DDBMS? p56 A. Fragmentation B. Duplication C. Replication D. Allocation

1) Distributed database management system 2) B. Duplication

Part 1: Which database design model usually consists of multiple parent and child records? (p51-52) A. Data model B. Relational model C. Primary key model D. Hierarchical model E. Network model Part 2: Based on your answer from #1, what does this model link? (p51-52)

1) E. Network model 2) Invoice numbers, customers numbers, methods of payment

List the 5 forces of Porter's Model in number form (p16)

1. Buyer power 2. Supplier power 3. Threat of substitute products or services 4. Threat of new entrants 5. Rivalry among existing competitors

Answer the following questions about computer systems (p26-27) 1. What does CPU stand for? Define it. 2. What two components is the CPU divided in? 3. Which term describes a link between devices linked to the computer? In what ways can it be linked? 4. Define disk drive.

1. Central-processing unit; heart of the computer 2. Arithmetic logic unit (ALU) and control unit 3. Bus; parallel or serial, internal (local), external 4. Peripheral device for recording, storing, and retrieving information

Part 1: Write out in words what CRUD stands for (p55) Part 2: What is the purpose of CRUD?

1. Create, read, update, and delete. 2. Determines who has permission to perform certain functions.

Answer the following questions (p51) 1. According to the text, what term describes a resource for storing definitions? 2. What does your answer from question one store? Hint: There are 4 answers

1. Data dictionary 2. Field names, field data types, default values, validation rules

Answer the following questions (all answers on p50-51) 1. What is the first step in database design? 2. List 3 components of your answer from question one 3. List the other steps in database design in the correct order

1. Data model 2. Data structure, operations, integrity rules 3. Hierarchical model, network model, relational model

1. Which rule states that if data is erroneous, the information provided by the computer is also erroneous? Give the acronym (p26) 2. What does your answer from #1 stand for? (p26)

1. GIGO 2. Garbage-in garbage-out

Answer the following by giving an answer for each definition (p50 & 52) 1. Database aspect involving how information appears to users as well as how it can be organized and retrieved 2. Database aspect involving how data is stored and retrieved from storage media 3. Field that identifies records in relational database like ID numbers, SSN, and invoice numbers 4. Improves database efficiency by eliminating redundant data, ensuring only related data is stored in a table

1. Logical view 2. Physical view 3. Primary key 4. Normalization

Answer the following questions (all answers on p57) 1. Where are data and relationships contained in a single object? 2. What is encapsulation? 3. What term describes the faster and easier creation of new objects by entering data in attributes?

1. Object-oriented databases 2. Grouping objects along with their attributes and methods into a class 3. Inheritance

1. What are optical discs? (p34) 2. List three common types of optical storage (p34)

1. Secondary memory devices using laser beams to access and store data 2. CD-ROMs, WORM discs, DVDs

Answer the following questions in number format (p7) 1. Write out in words what TPS stands for. 2. What does a TPS focus on? 3. What is the major reason for their usage?

1. Transaction-processing system 2. Focuses on data collection and processing 3. Used chiefly for cost reduction

Answer each of the following definitions with the correct term in number format (p64) 1. Speed with which data is gathered and processed 2. Combination of structured data, such as customers' product ratings 3. Sheer quantity of transactions measured

1. Velocity 2. Variety 3. Volume

What is a petabyte equal to? p30

2^50 bytes or 1 quadrillion bytes

How many characters in regular ASCII? How many in an Extended ASCII? p30

2^7 or 128 in a regular ASCII and 2^8 or 256 in an Extended ASCII

What are the 4 major components of an information system in the correct order? (p9) A. Data, database, process, information B. Data, process, information, database C. Database, data, process, information D. Database, process, database, information E. Process, database, information, data

A. Data, database, process, information

Which of the following best describes a set of programs for controlling and managing computer hardware and software? p38-39 A. Operating systems B. Servers C. Magnetic disk D. Cloud storage E. Application softwares

A. Operating systems

Which of the following is NOT a secondary memory device? p33-34 A. Magnetic disk B. Cache RAM C. Magnetic tape D. Optical discs E. All of the above are secondary memory devices

B. Cache RAM

All of the following are components of a DBMS *except* for ______________ (p53) A. Database engines B. Data-driven websites C. Data manipulation D. Application generation E. Data administration

B. Data-driven websites

Which of the following best describes giving customers information and how-to support videos? p4-5 A. Transaction-processing systems (TPS) B. Social networking C. Business intelligence (BI) D. Computer literacy E. Information literacy

B. Social networking

How does a DDBMS function? p56

By storing data on multiple servers throughout organizations

Which of the following provides views of operations and environments giving organizations a competitive marketplace advantage? (p7) A. Information literacy B. Management information systems C. Business intelligence D. Competitive intelligence E. None of the above

C. Business intelligence

Which of the following lists the steps of MIS designing in the correct order? p8 A. Collect and analyze data, provide information for decisions, define system's objectives B. Provide information for decisions, define system's objectives, collect and analyze data C. Define system's objectives, collect and analyze data, provide information for decisions D. Define system's objectives, provide information for decisions, collect and analyze data

C. Define system's objectives, collect and analyze data, provide information for decisions

Which database design model consists of records forming a treelike structure with node-like records? (p51) A. Network model B. Normalization model C. Data model D. Hierarchical model E. Relational model

D. Hierarchical model

Word processors, spreadsheets, database management systems, and presentation software are all examples of ______________. (p7) A. Social software B. Software knowledge C. Social hardware D. Productivity software E. Productivity hardware

D. Productivity software

Part 1: Which term best describes a program responsible for controlling programs, like compilers and assemblers? p40 A. Control programs B. Computer-aided design software C. Input device D. Supervisory program E. Both A & B Part 2: What is your answer from part 1 also called?

D. Supervisory program; kernel

A(n) ______________ is a site acting as an interface to databases, retrieving data for users and allowing users to enter data in the database (p55-56) A. Object-oriented database B. Distributed database management system C. Data warehouse D. Online transaction processing websites E. Data-driven website

E. Data-driven website

What does ETL stand for? Explain what it is (p58)

Extraction, transformation, and loading. Refers to processes used in a data warehouse

In a relational data model, rows are called fields, or attributes and columns are called records, or tuples. True or false? p51

False; Columns = fields/attributes & rows = records/tuples

External data includes sales and personnel records. True or false? p9

False; external includes customers, labor stats, government agencies, economies

What are the components of a management information system (MIS)? p8

Hardware & software technologies, data, processes, and human elements

What is a personnel information system (PIS) also referred to as? p12

Human resource information system, HRIS

How are characters, numbers, and symbols stored in computer memory? Explain your answer (p30)

In a binary system consisting of 0s and 1s. The zeros represent "off" and the ones represent "on"

Define data and briefly explain in detail (p9)

Information component of raw facts with a time orientation that can be collected in different forms.

What type of programming language is Java? p42

Java is a high-level program or third-generation computer language

List the 4 functions of an operating system (p39-40)

Job management, resource allocation, data management, communication

List examples of input devices (p31-32)

Light pen, trackball, data tablet, barcode reader, optical character reader, magnetic ink character recognition, optical mark recognition

What are the 2 types of memory for any computer? p33

Main memory and secondary memory

Explain what a secondary memory device is (p33)

Nonvolatile devices holding data serving as archival storage

What are Michael Porter's 3 strategies? p14

Overall cost leadership, differentiation, and focus

What is the function of the arithmetic logic unit (ALU) of a computer? p26

Performing arithmetic operations and comparisons or relational operations.

According to the text, what unit is volume measured in? p64

Petabytes

Which term describes step-by-step directions for performing a task in a language that the computer can understand? p25-26

Program

What is the purpose of a financial information system? (p14)

Providing information to financial executives in a timely manner.

What are the parts of a database? (location unknown)

Tables, forms, reports, and queries

Why are gallium arsenide chips useful? What are the disadvantages of them? p28

They run at faster speeds consuming less power than silicon chips and optical technologies. Difficulties in mass production and more soft and fragile

What is the purpose of a DBMS? p10

To create, organize, and manage databases

The data component of an information system is considered the input to the system. True or false? (p7)

True

What is information literacy? p7

Understanding the role of information in generating and using business intelligence

What is computer literacy? p7

Using productivity software with a basic knowledge of hardware and software.

What are the 3 V's of big data? p63-64

Volume, variety, and velocity