Prelim

Question 1

Data and Information

Answer 1

Database Management

Question 2

Collection of data organized so you can
access, retrieve, and use it

Answer 2

Database

Question 3

Database software allows you to:

Answer 3

• Create database
• Add, change, and delete data
• Sort and retrieve data
• Create forms and reports

Question 4

DBMS

Answer 4

Database Management System

Question 5

Data is not raw facts , t or f

Answer 5

False

Question 6

degree to which data is correct

Answer 6

Data integrity

Question 7

GIGO

Answer 7

Garbage in Garbage Out

Question 8

computer phrase that means you
cannot create correct information from
incorrect data

Answer 8

GIGO

Question 9

What are common data types?

Answer 9

Text,numeric,currency,data

Question 10

only the
values Yes or No (or True or False)

Answer 10

Boolean

Question 11

address that links to
document or Web page

Answer 11

Hyperlink Web

Question 12

photograph, audio, video, or
document created in other application such
as word processing or spreadsheet

Answer 12

Object also called BLOB

Question 13

Types of Validity Check

Answer 13

CHeck DIgit, Alphabetic/numeric check, range check,completeness check,consistency check

Question 14

same fields stored in multiple files

Answer 14

Data redundancy

Question 15

Data Stored in seperate files so it is difficult to access

Answer 15

isolated data

Question 16

many programs and users can share data in database

Answer 16

database approach

Question 17

Contains data about each file in
database and each field within those files

Answer 17

Data Dictionary

Question 18

Request for specific data from a
database

Answer 18

Query

Question 19

Window on screen that provides areas
for entering or changing data in database

Answer 19

Form

Question 20

Allows user to design a report on screen,
retrieve data into report design, then display
or print reports

Answer 20

Report Generator

Question 21

define activities that
specific user or group of users can perform

Answer 21

Access privileges

Question 22

User can view data, but cannot change it

Answer 22

Read only privileges

Question 23

User can view and change data

Answer 23

Full update Privileges

Question 24

a listing of activities that change
database contents

Answer 24

log

Question 25

Allows you to manage, update, and
retrieve data

Answer 25

SQL

Question 26

SQL

Answer 26

Structured Query Language

Question 27

• are the properties that define
  the entity type.

Answer 27

Attributes

Question 28

• uniquely identifies each
  entity in the entity set.

Answer 28

Key Attribute

Question 29

A Relationship Type represents the
association between entity types.

Answer 29

Relationship type and relationship set

Question 30

The number of different entity sets
participating in a relationship set.

Answer 30

Degree of a relationship set

Question 31

When there is only
ONE entity set participating in a relation.

Answer 31

Unary Relationship

Question 32

When there are
TWO entities set participating in a
relationship.

Answer 32

Binary Relationship

Question 33

When there are n
entities set participating in a relation.

Answer 33

nary relationship

Question 34

In this type of cardinality
mapping, an entity in A is connected to at
most one entity in B.

Answer 34

Many to one