Exam 3: The Relational Database Model

A ____ contains at least all of the attribute names and characteristics for each table in the system.

Codd's rule of ____ states: Application programs and ad hoc facilities are logically unaffected when changes are made to the table structures that preserve the original table values (changing order of columns or inserting columns).

What is the system catalog?

Controlled ____ makes a relational database work.

____ logic,used extensively in mathematics,provides a framework in which an assertion (statement of fact)can be verified as either true or false.

Codd's rule of ____________________ states that every value in a table is guaranteed to be accessible through a combination of table name,primary key value,and column name.

A data dictionary contains metadata-data about data.

A data dictionary is sometimes described as "the database designer's database" because it records the design decisions about tables and their structures.

Tables must have the same attribute characteristics (the columns and domains must be compatible)to be used in a UNION.

Tables within a database share common attributes that enable the tables to be linked together.

A ____ is any key that uniquely identifies each row.

In a natural join,the column on which the join was made occurs twice in the new table.

PRODUCT yields all possible pairs of rows from two tables-also known as the ____________________ product.

The ____________________ relationship is the relational database norm.

In the relational model,____________________ are important because they are used to ensure that each row in a table is uniquely identifiable.

A foreign key must exist in both tables that have a relationship.

When you define a table's primary key,the DBMS automatically creates a(n)____ index on the primary key column(s)you declared.

In the context of a database table,the statement "A ____ B" indicates that if you know the value of attribute A,you can look up the value of attribute B.

In the relational model,____ are important because they are used to ensure that each row in a table is uniquely identifiable

The ____ is actually a system-created database whose tables store the user/designer-created database characteristics and contents.