Lesson 1: Relational Database Model

Question 1

A simple but highly useful way to
organize data into collections of
two-dimensional tables called
relations.

Answer 1

relational database model:

Question 2

The range of allowable
values for a data attribute.

Answer 2

domain

Question 3

Manipulating data to
eliminate rows according to certain criteria.

Answer 3

selectings

Question 4

Manipulating data to
eliminate columns in a table

Answer 4

Projecting

Question 5

Manipulating data to combine
two or more tables.

Answer 5

joining

Question 6

The ability to combine two or
more tables through common data
attributes to form a new table with only
the unique data attributes.

Answer 6

linking

Question 7

The process of
detecting and then correcting or deleting incomplete, incorrect, inaccurate, or
irrelevant records that reside in a
database.

Answer 7

Data Cleansing