Review Intro to Database

Question 1

facts that have
yet been processed

Answer 1

Data

Question 2

result of processing raw
data

Answer 2

Information

Question 3

A shared, integrated computer
structure

Answer 3

DATABASE

Question 4

a collection of programs that
manages the database
structure

Answer 4

DATABASE MANAGEMENT
SYSTEM

Question 5

components of the DBMS Environment

hint: there are five (5)

Answer 5

1. Data
2. Hardware
3. Software
4. End Users
5. Procedure

Question 6

define the database through a ____

Answer 6

Data Definition Language (DDL)

Question 7

manipulate data through a

Answer 7

Data Manipulation Language (DML)

Question 8

provide ________ system

Answer 8

security

Question 9

provide an ________ system

Answer 9

integrity

Question 10

provide a ________ control system.

Answer 10

concurrency

Question 11

provide a ________ control system

Answer 11

recovery

Question 12

Collection of application programs that perform services for the end users

Answer 12

FILE SYSTEMS

Question 13

an automated system that enables users to define,
create, maintain and control access to the database

Answer 13

DATABASE SYSTEM

Question 14

advantages of normalization

Better overall database _______

Answer 14

organization

Question 15

advantages of normalization

Reduction of ________ data

Answer 15

redundant

Question 16

advantages of normalization

Data ________ within the database

Answer 16

consistency

Question 17

advantages of normalization

________ database design

Answer 17

Flexible

Question 18

advantages of normalization

Efficient database ________ handling

Answer 18

security

Question 19

advantages of normalization

Enforces concept of ________ integrity

Answer 19

referential