FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: The Relational Database Model

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Multiple Choice

Review LaterAdd Note

Review Later

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

A) key
B) incomplete
C) unique
D) primary

E) All of the above
F) C) and D)

Correct Answer

verified

Show Answer

Question 52

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 53

Short Answer

Review LaterAdd Note

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.

The ____________________ relationship is the relational database norm.

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

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

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.

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.

A ____ is any key that uniquely identifies each row.

A data dictionary contains metadata-data about data.

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

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

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

Controlled ____ makes a relational database work.

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

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

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?

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