Topic 1

Question 1

Collection of
data organized
in a manner
that allows
access,
retrieval, and
use of that
data

Answer 1

Database

Question 2

Collection of
unprocessed
items
* Text
*Numbers
* Images
* Audio
* Video

Answer 2

Data

Question 3

• Processed data
• Documents
• Audio
• Images
• Video

Answer 3

Information

Question 4

is a tool used to organize, store,
retrieve, and communicate (report on) group of
related information.

Answer 4

database

Question 5

A database is a tool used by businesses to
manage the huge amount of ___ required to run
the business.

Answer 5

data

Question 6

Databases consist of 4 main Objects

Answer 6

1. Tables
2. Queries
3. Forms
4. Reports

Question 7

store data in rows and columns

Answer 7

Tables

Question 8

retrieve and process data

Answer 8

Queries

Question 9

control data entry and data views; is a customized manner of inputting data into a
database or representing data on a screen.

Answer 9

Forms

Question 10

summarize and print data.

Answer 10

Reports

Question 11

___ _____often called a database management system (DBMS), allows users to:
- Create a computerized database
- Add, modify, and delete data
- Sort and retrieve data
- Create forms and reports from the data

Answer 11

Database software

Question 11

identifies the quality of the data

Answer 11

Data integrity

Question 12

points out the
accuracy of a computer’s output depends on the
accuracy of the input

Answer 12

Garbage in, garbage out (GIGO)

Question 13

Valuable information should have the following
characteristics:

Answer 13

Accurate
Verifiable
Timely
Organized
Accessible
Useful
Cost effective

Question 14

Data is organized in layers

Answer 14

– Files, records, fields, characters

Question 14

is one byte
– Numbers, letters, space,
punctuation marks, or
other symbols

Answer 14

character

Question 15

is a combination
of one or more related
characters
– Field name
– Field size
– Data type

Answer 15

field

Question 16

is a group of related fields

Answer 16

record

Question 17

uniquely identifies each record

Answer 17

primary key

Question 18

is a collection of related records

Answer 18

data file

Question 19

refers to the procedures that
keep data current

Answer 19

File maintenance

Question 20

Users add new records to a file when they obtain
new data ( T or F)

Answer 20

True or T

Question 21

Users modify a record to correct inaccurate data
or update old data ( T or F )

Answer 21

T or true

Question 22

When a record no longer is needed, a user deletes
it from a file (t or f)

Answer 22

t

Question 23

compares data with a set of rules or values to find out if the data is correct

Answer 23

Validation

Question 24

* Each department has its own set of files * Used for many years * Have data redundancy * Isolate data

Answer 24

File processing system

Question 25

are used by a manager of any small organization to track necessary data

Answer 25

Filesystems

Question 25

* Programs and users share data * Reduce data redundancy * Improve data integrity * Share data * Allows easier access * Reduces development time * Can be more vulnerable

Answer 25

Database approach

Question 26

contains data about each file in the database and each field in those files

Answer 26

data dictionary

Question 27

provides a GUI to assist users with retrieving data

Answer 27

Query by example (QBE)

Question 28

provides several tools that allow users and programs to retrieve and maintain data in the database

Answer 28

DBMS

Question 29

consists of simple, English-like statements that allow users to specify the data to display, print, or store

Answer 29

query language

Question 30

is a window on the screen that provides areas for entering or modifying data in a database

Answer 30

form

Question 31

allows users to design a report on the screen, retrieve data into the report design, and then display or print the report

Answer 31

report generator

Question 32

provides means to ensure that only authorized users access data at permitted times *Access privileges *Principle of least privilege

Answer 32

DBMS (Database Management Systems)

Question 33

consists of rules and standards that define how the database organizes data

Answer 33

data model

Question 34

stores data in tables that consist of rows and columns

Answer 34

relational database

Question 35

is a link within the data

Answer 35

relationship

Question 35

is a query language that allows users to manage, update, and retrieve data

Answer 35

Structured Query Language (SQL)

Question 36

stores data in objects

Answer 36

object-oriented database (OODB)

Question 37

is a huge database that stores and manages the data required to analyze historical and current transactions

Answer 37

data warehouse

Question 37

can store data in more than two dimensions of data – Sometimes known as a hypercube – Can consolidate data much faster than a relational database

Answer 37

multidimensional database

Question 37

Decides on proper field placement, defines data relationship, and identifies users’ access privileges

Answer 37

Database Analyst (DA)

Question 37

Creates and maintains the data dictionary, manages security, monitors performance, and checks backup and recovery procedures

Answer 37

Database Administrator (DBA)

Question 37

is the process of sorting through large data sets to identify patterns and relationships that can help solve business problems through data analysis

Answer 37

Datamining