Chapter 9

Question 1

Database

Answer 1

-Highly structured data storage

Question 2

RDBMS

Answer 2

Relational Database Management System

Question 3

Primary Key and Foreign Key

Answer 3

-It is more efficient and reliable to store data in multiple tables
-The primary key is a designated table column with unique value for each record
-The foreign key is a column that references the primary key value of another table
-The definition of tables, columns, and relations is called the database schema

Question 4

Constraints

Answer 4

-Garbage in, Garbage out (GIGO)
-Columns (fields) are defined with a data type, which acts as a basic constraint on what can be entered
-Constraints can be applied in other ways

Question 5

Structured relational database

Answer 5

Defined tables and columns with data types

Question 6

Unstructured data

Answer 6

-documents, presentations, some types of spreadsheets
-User is not really constrained about what they enter
-data can be extracted by searching and indexing the file content

Question 7

Semi-Structured

Answer 7

Documents that contain meta data or markup that identifies the values contained

Question 8

One-tier

Answer 8

User interface (front end) and database (back end) hosted on same computer

Question 9

Two-tier

Answer 9

-Client server
-Client machine runs application and presentation
-Server machine runs database

Question 10

Three-tier

Answer 10

-Client front end
-Application/business logic
-Database

Question 11

N-tier

Answer 11

-Any multi-tier architecture
-More complex than 3-tier