Completion
Complete each sentence or
statement.
|
|
|
1.
|
A(n)
________________________ database is a collection of tables.
|
|
|
2.
|
Each
__________________________ is stored in its own table.
|
|
|
3.
|
The
relationships between tables are handled through __________________________ columns.
|
|
|
4.
|
A
relation is a(n) _________________________-dimensional table.
|
|
|
5.
|
Each
row in a relation is _________________________.
|
|
|
6.
|
If
some of the entries contain repeating groups (not single-valued), this is known as a(n)
___________________________ relation.
|
|
|
7.
|
The
________________________ key of a relation is the column or collection of columns that uniquely
identifies a given row in a table.
|
|
|
8.
|
When
you combine a table name with a column name, you _________________________ the column
name.
|
|
|
9.
|
Conditions that data must satisfy are called _________________________.
|
|
|
10.
|
Another name for a comparison operator is a(n) _______________________
operator.
|
|
|
11.
|
If
only one criterion needs to be true for the whole criterion condition to be true, use the
_________________________ criterion.
|
|
|
12.
|
A(n)
______________________ field is a field that is the result of a calculation using one or more
existing fields.
|
|
|
13.
|
Built-in statistics are known as ____________________ functions in
Access.
|
|
|
14.
|
______________________ will create a collection of records that share some common
characteristic.
|
|
|
15.
|
The
major sort key is also known as the ____________________ sort key.
|
|
|
16.
|
It is
necessary to ____________________ tables based on matching fields in corresponding columns to
retrieve data from more than one table.
|
|
|
17.
|
A
query that changes data is a(n) _________________________ query.
|
|
|
18.
|
A(n)
_________________________ query will remove one or more records at a time from the
table.
|
|
|
19.
|
A(n)
_______________________ query creates a new table using the query result.
|
Short Answer
|
|
|
20.
|
What
is a theoretical method of manipulating a relational database?
|
|
|
21.
|
Which
command within relational algebra takes a horizontal subset of a table?
|
|
|
22.
|
Which
operation is used to extract data from more than one table?
|
|
|
23.
|
List
the three set operations.
|
|
|
24.
|
How
is the difference operation performed?
|
|
|
25.
|
What
is another name for the product of two tables?
|
|
|
26.
|
If
two tables have the same number of columns and their corresponding columns represent the same type of
data, how are these tables referred to in set operations?
|
|
|
27.
|
Define a union of table A and B.
|
|
|
28.
|
Define an intersection of tables A and B.
|
|
|
29.
|
Define the difference between two tables.
|
Essay
|
|
|
|
|
|
30.
|
Using
figure 2.1 on pages 30-31 with relational algebra, write the algebraic statement to list all
information from the Customer table concerning customer 282. What will display?
|
|
|
31.
|
Using
figure 2.1 on pages 30-31 with relational algebra, list all information from the Customer table
concerning those customers with credit limits of $7,500. What will display?
|
|
|
32.
|
Using
figure 2.1 on pages 30-31 with relational algebra, list the number and name of all the
customers. What will display?
|