Chapter 1

Question 1

Modification Issues

Answer 1

Deletion problems
Update problems
Insertion problems

Question 2

Two Data Management Problems

Answer 2

Redundancy and Multiple Themes

Question 3

Where the same piece of info occurs in multiple places on a list.

Answer 3

Redundancy

Question 4

Where the data for two or more distinct elements are stuck together on the same line of a list.

Answer 4

Multiple Themes

Question 5

An international standard for creating, processing and querying databases and their tables.

Answer 5

SQL (Structured Query Language)

Question 6

Data describing the structure of the database date

Answer 6

Metadata

Question 7

Serves as a intermediary between database applications and the database

Answer 7

DBMS (Database Management System)

Question 8

Functions of a DBMS

Answer 8

Create Tables
Enforce Rules
Provide Security
Modify Database Data

Question 9

Ensures that the values of a column in one table are valid based on the values in another table

Answer 9

Referential Integrity Constraints

Question 10

A set of one or more computer programs that serves as an intermediary b/w the user and the DBMS

Answer 10

Database Applications