final

Question 1

Database management systems (DBMS)

components

Answer 1

collection of tools, features, and interfaces that enable users to add, update, manage access

interfaces, schema(description),

Question 2

entity

field

record

table/ file

Answer 2

• person place or thing
• single characteristics or facts about entity
• set of related fields that describe 1 entity
• set of related records

Question 3

key fields

1. primary
2. candidate
3. foreign
4. secondary

Answer 3

1. unique minimally identifies a member
2. could serve as primary
3. field in one table
   field or combination of field to access or retrieve recors

Question 4

Entity relationship diagram (ERD)

Answer 4

list the entities identified and the relationships

Question 5

data normalization

Answer 5

creating table designs by assigning specific fields or attributes

3NF

every monkey field depends on the key, the whole key, and nothing but the key

Question 6

data mining

Answer 6

looks for meaningful data patterns and relationships

Question 7

quality assurance

Answer 7

• avoid problems or immediately identify them
• ## companies are intensely concern with the qualities of their podructs and services

-software/system engineering

-ISO

Question 8

application development

Answer 8

process of constructing program and code modules that serve as building block of the info system

task involved: data flow, breakdown operations, object oriented model, red

plan - develop -test’

Question 9

agile method

Answer 9

create a system through an iterative process of planning, designing, coding, and testing

Question 10

partitioning

Answer 10

system broken-down into subsystems and modules

Question 11

structure chart

Answer 11

display program modules and relationships

Question 12

types of modules

Answer 12

control: higher level model
subordinate: Lowe leve models
library: reusable code

Question 13

object oriented development

Answer 13

the relationship and interactions among classes using a class diagram

Question 14

agile development
(add)

Answer 14

highly iterative process

Question 15

user support

Answer 15

user training
help or service desk
outsourcing issues (call centers)
-to reduce wait time, increase performance

Question 16

maintainance task expense

Answer 16

operational cost
maintenance expense
maintenance activities

Question 17

corrective maintenance

Answer 17

diagnosis and corrects errors in operational systems

-system failure (require a path)

-when system operates again the maintenance team determines the cause and analyses problem, and designs a permanent solution

Question 18

adaptive maintainance

Answer 18

-adds enhancement to and operational system

Question 19

perfective maintenance

Answer 19

changing an operational system to make it more efficient, reliable, and maintainable
-cost effective

Question 20

preventive maintainance

Answer 20

requires analysis of areas where trouble is likely to occur

-reduces total cost of ownership(TCO)

Question 21

CIA Triangle

Answer 21

shows main elements used to develop a security policy
confidentiality, integrity, availability

Question 22

system security
risk management

Answer 22

risk identification: list and classify assets and analyze possible threats

risk assessment: risk need to be calculated an prioritized

risk control: strategies :avoidance, mitigation, transference, and acceptance

Question 23

Security levels (6)

Answer 23

1. user
2. procedural
3. file
4. application
5. network
   6.physical

Question 24

system changeover

4 types

Answer 24

process of putting new information system online an retiring the old

1. direct: new system becomes operational
2. parallel: both old an new operate fully
3. pilot: implement new system at 1 location
4. phased: implement system in. stages

Question 25

stability

Answer 25

system ability to expand, change, or downsize

Question 26

network evelolution

Answer 26

local area (LAN) wide area (WAN)

Question 27

fat client (thick)

Answer 27

locates all or most of the processing logic at client

Question 28

thin client

Answer 28

locates all or most of the processing logic at server

Question 29

Open system interconnections (OSI)

Answer 29

describes how data moves from one application on a computer to another networked computer

Question 30

network topology

Answer 30

physical: actual network cabling logical : descrive the way component interact hierarchal: department servers control lower levels of processing and network devices Bus: single communication path ring: circle star: central networking device mesh: each node connect to every other node

Question 31

SDLC model 5 steps

Answer 31

- to plan and manage the system development process 1. planning: request to IT (describe problems and desired changes) 2. analysis: build logical model of new system 3. design: build physical model 4. I mplementation: program build, runed, tested. Ready to use 5. support and security: IT staff maintains. enhances, and protects system