Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ITCC 33 A - ADVANCED DATABASE SYSTEMS > Information Systems and Databases > Flashcards

Information Systems and Databases Flashcards

1
Q

4 concepts of information

A
  1. Data
  2. Information
  3. Process
  4. Knowlede
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Raw facts

A

Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Organized collection of facts

A

Information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Set of logically related tasks

A

Process

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Awareness or understanding of information

A

Knowledge

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

It is data that has been processed and organized

A

Information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

Information Systems

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Two different ways to describe information systems

A
  1. Components of an information system
  2. The role of those components
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

5 components of information systems

A
  1. Hardware
  2. Software
  3. Data
  4. People
  5. Process
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

physical components of technology

A

Hardware

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

set of instructions that order hardware

A

Software

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

people involved with information systems

A

people

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

Process

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is the main role of information systems?

A

to take data and turn it into information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Types of Information Systems (6)

A
  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
17
Q

Processes data transaction in database system

A

Transactional Processing System (TPS)

18
Q

Takes data from TPS. Produces business info reports

A

Management Reporting System

19
Q

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

A

Decision Support System

20
Q

Supports top managers with conveniently displayed summarized info customized for them

A

Executive Information Systems

21
Q

Facilitates the communication between employees and anyone in the organization

A

Office Information Systems

22
Q

Helps in tasks specific to various professions

A

Professional Support System

23
Q

Data organization methods

A
  1. Manual Organizing Method
  2. Computer Based Organizing Method
24
Q

used for organizing and processing info manually

A

Manual Organizing Method

25
Q

collection of application programs to perform services to end users

A

Computer-Based Organizing Method

26
Q

2 types of Organizing Method

A
  1. File-based System
  2. Database system
27
Q

Early attempt at computerizing filing systems. Decentralized approach

A

File-based system

28
Q

Shared collection of logically related data. Self describing integrated records

A

Database System

29
Q

History of Database Systems

A

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

30
Q

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

A

Data abstraction

31
Q

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

A

Data Independence

32
Q

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

A

DBMS Database Management System

33
Q

Collection of app programs that interact with the database

A

Database System

34
Q

Roles of the Database environment

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

ITCC 33 A - ADVANCED DATABASE SYSTEMS (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions