DATABASES Flashcards

1
Q

it requires good information derived from raw facts

A

Good Decisions

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

This is managed most efficiently when stored in a database

A

Data

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

Databases evolved from ?

A

Computer File Systems

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

Difference of data vs Information

A

data (raw data) = non specific
information = specific

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

this solves many of the problems encountered in data management.

A

databases

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

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

A

Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q
  1. these are raw facts
  2. are the foundation of information, which is the bedrock of knowledge
  3. building blocks of information
A

Data

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

must be formatted for storage, processing, and presentation

A

Raw Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q
  1. it is the result of processing raw data to reveal meaning
  2. requires context to reveal meaning
A

Information

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

focuses on proper generation, storage, and retrieval of data

A

Data Management

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

it is the key to organizational survival

A

Good Decision Making

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

Accurate, relevant, timely information is key to?

A

Good Decision Making

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

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

A

Database

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

raw facts of interest to end user

A

End-user data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q
  1. data about data
  2. Provides description of data characteristics and relationships in data
  3. Complements and expands value of data
A

Metadata

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

collection of programs and manages structure and controls access to data

A

Database Management System
(DBMS)

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

helps decision makers achieve their organization’s goals.

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

A

Valuable information

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

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.

A

Accessible

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

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

A

Accurate

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

This characteristics of Valuable Information contains all the important facts

A

Complete

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

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

A

Economical

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

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

A

Flexible

23
Q

This characteristic of Valuable information is important to the decision maker

A

Relevant

24
Q

This characteristic of Valuable information can be trusted by users

A

Reliable

25
Q

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

A

Secure

26
Q

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.

A

Simple

27
Q

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

A

Timely

28
Q

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

A

Verifiable

29
Q

It is the intermediary between the user and the database

enables data to be shared and integrates many users’ views of the data

A

Database Management System

30
Q

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

A

Database Stucture

31
Q

These are the End-user data

A

Customers
Invoices
Products

32
Q

stores data used for tactical or strategic decision

A

Data warehouse

33
Q

it is a type of data exist in their original state

A

Unstructured Data

34
Q

represents data elements in textual format

A

XML

35
Q

MS Access
MS SQL Server
IBM DB2
My Sql
Oracle RDBMS

what are these?

A

Types of Databases

36
Q

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

A

File Systems

37
Q

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

A

Record

38
Q

A collection of related Records

A

File

39
Q

same data stored unnecessarily in different places

A

Data Redundancy

40
Q

it promotes storage of same data in different locations

A

Organizational Structure

41
Q

if Data stored in different locations is unlikely to be

A

updated consistently

42
Q

different and conflicting versions of same data occur at different places

A

Data inconsistency

43
Q

abnormalities when all changes in redundant data are not made correctly

A

Data Anomalies

44
Q

Five Major parts of A database system are;

A

Hardware
Software
People
Procedures
Data

45
Q

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

A

Database system

46
Q

three types of software required for database systems are;

A

Operating system software
DBMS software
Application programs and utility software

47
Q

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

A

Procedures

48
Q

these are created and managed at different levels of complexity

A

Database systems

49
Q

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

A

Database Solutions

50
Q

these are already in use affects selection of a database system

A

Database Technology

51
Q

Independent files tend to contain

A

redundant data

52
Q

they were developed to address file system’s inherent weaknesses

A

Database management systems

53
Q

POS

A

Point of Sales

54
Q

LIS

A

Learners Information System