exam 2 review questions

Question 1

why do you need to know about databases?

Answer 1

they are everywhere,
we access dozens, if not hundreds, everyday

Question 2

what is a database?

Answer 2

a set of logically related data stored in a shared repository

Question 3

what is a database management system (DBMS)?

Answer 3

a program that creates, processes, and administers databases

Question 4

how do database applications make databases more useful?

Answer 4

forms, reporting, queries, and application programs

Question 5

what are the basic types of processes?

Answer 5

workgroup, enterprise, and inter-enterprise

Question 6

how can information systems improve process quality?

Answer 6

1. performing an activity (partially or completely automated)
2. augmenting human performing activity
3. controlling data quality (ensure data is complete and correct)

Question 7

how do information systems eliminate the problems of information silos?

Answer 7

1. integrate data into a single database
2. revise application and data processes to eliminate duplicate data

Question 8

what are the challenges of implementing and upgrading enterprise information systems?

Answer 8

1. collaborative management
2. identify requirement gaps
3. transition problems
4. employee resistance
5. new technology

Question 9

how do CRM, ERP, and EAI support enterprise processes?

Answer 9

they help organizations fundamentally rethink how they work to dramatically improve customer service, cut operational costs, and become world-class competitors

Question 10

what is systems development?

Answer 10

the process of creating and maintaining information systems

Question 11

why is systems development difficult and risky?

Answer 11

many projects never finish, often over budget, some don’t accomplish goals, and there is a high risk of failure even w/ competent people following the appropriate methodology

Question 12

what are the five phases of the S D L C?

Answer 12

1. system definition
2. requirement analysis
3. component design
4. implementation
5. system maintenance

Question 13

how is systems definition accomplished?

Answer 13

by defining the system goals and scope, assessing feasibility, forming a project team, and planning the project

Question 14

what is the users’ role in the requirements phase?

Answer 14

interviews

Question 15

how are the five components designed?

Question 16

how is an information system implemented?

Answer 16

pilot, phased, parallel, or plunge

Question 17

what are the tasks for system maintenance?

Answer 17

record requests for change (failures, enhancements), prioritize requests, & fix failures (patches, service packs, new releases)

Question 18

what are some of the problems with S D L C?

Answer 18

SDLC Waterfall Method
requirements documentation difficult
scheduling and budgeting difficulties

Question 19

what is the goal of info. systems security?

Answer 19

find appropriate trade-off between risk of loss and cost of implementing safeguards

Question 20

how big is the computer security problem?

Answer 20

the average computer crime costs increases every year

Question 21

how should you respond to security threats?

Answer 21

create strong/multiple passwords, send no valuable data via email or IM, demonstrate security concern, etc.

Question 22

how can technical safeguards protect against security threats?

Answer 22

identification & authentication
encryption
firewalls
malware protection
design for secure applications

Question 23

how can data safeguards protect against security threats?

Answer 23

define data policies
data rights & responsibilities
rights enforced by user accounts authenticated by passwords
data encryption
backup & recovery procedures
physical security

Question 24

how can human safeguards protect against security threats?

Answer 24

account administration,
safeguard for employees and nonemployees

Question 25

how should orgs. respond to security incidents?

Answer 25

speed, preparation pays, don’t make problem worse