Information Systems and Databases

Question 1

4 concepts of information

Answer 1

1. Data
2. Information
3. Process
4. Knowlede

Question 2

Raw facts

Answer 2

Data

Question 3

Organized collection of facts

Answer 3

Information

Question 4

Set of logically related tasks

Answer 4

Process

Question 5

Awareness or understanding of information

Answer 5

Knowledge

Question 6

It is data that has been processed and organized

Answer 6

Information

Question 7

Interrelated components working together to collect, store, process, and disseminate information to help an organization

Answer 7

Information Systems

Question 8

Two different ways to describe information systems

Answer 8

1. Components of an information system
2. The role of those components

Question 9

5 components of information systems

Answer 9

1. Hardware
2. Software
3. Data
4. People
5. Process

Question 10

physical components of technology

Answer 10

Hardware

Question 11

set of instructions that order hardware

Answer 11

Software

Question 12

A collection of facts. such as name, address, etc.

Answer 12

Data

Question 13

people involved with information systems

Answer 13

people

Question 14

a series of steps undertaken to achieve a desired outcome or goal

Answer 14

Process

Question 15

What is the main role of information systems?

Answer 15

to take data and turn it into information

Question 16

Types of Information Systems (6)

Answer 16

1. TPS - Transactional Processing System
2. MRS - Management Reporting System
3. DSS - Decision Support System
4. EIS - Executive Information Systems
5. OIS - Office Information Systems
6. PSS - Professional Support System

Question 17

Processes data transaction in database system

Answer 17

Transactional Processing System (TPS)

Question 18

Takes data from TPS. Produces business info reports

Answer 18

Management Reporting System

Question 19

Supports a decision making session. Facilitates the communication between the user who is considering alternative problem solutions

Answer 19

Decision Support System

Question 20

Supports top managers with conveniently displayed summarized info customized for them

Answer 20

Executive Information Systems

Question 21

Facilitates the communication between employees and anyone in the organization

Answer 21

Office Information Systems

Question 22

Helps in tasks specific to various professions

Answer 22

Professional Support System

Question 23

Data organization methods

Answer 23

1. Manual Organizing Method
2. Computer Based Organizing Method

Question 24

used for organizing and processing info manually

Answer 24

Manual Organizing Method

Question 25

collection of application programs to perform services to end users

Answer 25

Computer-Based Organizing Method

Question 26

2 types of Organizing Method

Answer 26

1. File-based System 2. Database system

Question 27

Early attempt at computerizing filing systems. Decentralized approach

Answer 27

File-based system

Question 28

Shared collection of logically related data. Self describing integrated records

Answer 28

Database System

Question 29

History of Database Systems

Answer 29

1st Gen - 1960 - Hierarchical Structure - 1965 - Network DBMS 2nd Gen - 1970-1980 - Relational Database 3rd Gen - Extended relational - SQL Language - DB2, Oracle - Object-oriented DBMS

Question 30

Separates the structure of the data from the application program and stores it in the database

Answer 30

Data abstraction

Question 31

Immunity of the user applicants to changes made in the definition and organization of data

Answer 31

Data Independence

Question 32

It is a software that allows users to have control access to the database

Answer 32

DBMS Database Management System

Question 33

Collection of app programs that interact with the database

Answer 33

Database System

Question 34

Roles of the Database environment

Answer 34

1. Data Administrator 2. Database Administrator 3. Database Designers 4. Applications programmers 5. End Users