DATABASES

Question 1

it requires good information derived from raw facts

Answer 1

Good Decisions

Question 2

This is managed most efficiently when stored in a database

Answer 2

Data

Question 3

Databases evolved from ?

Answer 3

Computer File Systems

Question 4

Difference of data vs Information

Answer 4

data (raw data) = non specific
information = specific

Question 5

this solves many of the problems encountered in data management.

Answer 5

databases

Question 6

Used in almost all modern settings involving data management:
Business
Research
Administration

Answer 6

Databases

Question 7

1. these are raw facts
2. are the foundation of information, which is the bedrock of knowledge
3. building blocks of information

Answer 7

Data

Question 8

must be formatted for storage, processing, and presentation

Answer 8

Raw Data

Question 9

1. it is the result of processing raw data to reveal meaning
2. requires context to reveal meaning

Answer 9

Information

Question 10

focuses on proper generation, storage, and retrieval of data

Answer 10

Data Management

Question 11

it is the key to organizational survival

Answer 11

Good Decision Making

Question 12

Accurate, relevant, timely information is key to?

Answer 12

Good Decision Making

Question 13

shared, integrated computer structure that stores a collection of:
End-user Data & Metadata

Answer 13

Database

Question 14

raw facts of interest to end user

Answer 14

End-user data

Question 15

1. data about data
2. Provides description of data characteristics and relationships in data
3. Complements and expands value of data

Answer 15

Metadata

Question 16

collection of programs and manages structure and controls access to data

Answer 16

Database Management System
(DBMS)

Question 17

helps decision makers achieve their organization’s goals.

help people in their organizations perform tasks more efficiently and effectively.

Answer 17

Valuable information

Question 18

Information should be easily accessible by authorized users so they can obtain it in the right format and at the right time to meet their needs.

Answer 18

Accessible

Question 19

It is error free. In some cases, inaccurate information is generated because inaccurate data is fed into the transformation process.

Answer 19

Accurate

Question 20

This characteristics of Valuable Information contains all the important facts

Answer 20

Complete

Question 21

With this characteristic of Valuable Information, decision makers must always balance the value of information with the cost of producing it.

Answer 21

Economical

Question 22

This characteristic of Valuable information can be used for a variety of purposes.

Answer 22

Flexible

Question 23

This characteristic of Valuable information is important to the decision maker

Answer 23

Relevant

Question 24

This characteristic of Valuable information can be trusted by users

Answer 24

Reliable

Question 25

This characteristic of Valuable information should be secure from access by unauthorized users.

Answer 25

Secure

Question 26

This characteristic of Valuable information has too much information can cause information overload, whereby a decision maker has too much information and is unable to determine what is really important. in This case its too complex to analyze.

Answer 26

Simple

Question 27

This characteristic of Valuable information is delivered when it is needed.

Answer 27

Timely

Question 28

This means that you can check it to make sure it is correct, perhaps by checking many sources for the same information

Answer 28

Verifiable

Question 29

It is the intermediary between the user and the database enables data to be shared and integrates many users’ views of the data

Answer 29

Database Management System

Question 30

it is stored as file collection and can only access files through the DBMS

Answer 30

Database Stucture

Question 31

These are the End-user data

Answer 31

Customers Invoices Products

Question 32

stores data used for tactical or strategic decision

Answer 32

Data warehouse

Question 33

it is a type of data exist in their original state

Answer 33

Unstructured Data

Question 34

represents data elements in textual format

Answer 34

XML

Question 35

MS Access MS SQL Server IBM DB2 My Sql Oracle RDBMS what are these?

Answer 35

Types of Databases

Question 36

typically composed of collection of file folders, each tagged and kept in cabinet

Answer 36

File Systems

Question 37

A logically connected set of one or more fields that describes a person, place, or thing.

Answer 37

Record

Question 38

A collection of related Records

Answer 38

File

Question 39

same data stored unnecessarily in different places

Answer 39

Data Redundancy

Question 40

it promotes storage of same data in different locations

Answer 40

Organizational Structure

Question 41

if Data stored in different locations is unlikely to be

Answer 41

updated consistently

Question 42

different and conflicting versions of same data occur at different places

Answer 42

Data inconsistency

Question 43

abnormalities when all changes in redundant data are not made correctly

Answer 43

Data Anomalies

Question 44

Five Major parts of A database system are;

Answer 44

Hardware Software People Procedures Data

Question 45

defines and regulates the collection, storage, management, use of data

Answer 45

Database system

Question 46

three types of software required for database systems are;

Answer 46

Operating system software DBMS software Application programs and utility software

Question 47

these are instructions and rules that govern the design and use of the database system

Answer 47

Procedures

Question 48

these are created and managed at different levels of complexity

Answer 48

Database systems

Question 49

a must be cost-effective as well as tactically and strategically effective

Answer 49

Database Solutions

Question 50

these are already in use affects selection of a database system

Answer 50

Database Technology

Question 51

Independent files tend to contain

Answer 51

redundant data

Question 52

they were developed to address file system’s inherent weaknesses

Answer 52

Database management systems

Question 53

POS

Answer 53

Point of Sales

Question 54

LIS

Answer 54

Learners Information System