Exam 4: Relational Model Characteristics

If one department chair-a professor-can chair only one department and one department can have only one department chair, then the entities PROFESSOR and DEPARTMENT exhibit a(n) ____________________ relationship.

(Short Answer)

4.9/5

(41)

Question 61

What is the system catalog?

(Essay)

5.0/5

(31)

Question 62

The proper use of ____________________ keys is crucial to controlling data redundancy.

(Short Answer)

4.7/5

(33)

Question 63

Describe the use of the UNION operator.

(Essay)

4.8/5

(36)

Question 64

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.

(Multiple Choice)

4.8/5

(29)

Question 65

Current relational database software generally provides only a system catalog (and not a data dictionary).

(True/False)

4.8/5

(35)

Question 66

Codd's Rule of ____ states: If the system supports low-level access to the data, users must not be allowed to bypass the integrity rules of the database

(Multiple Choice)

4.8/5

(35)

Question 67

The ____ relational type is the "relational model ideal."

(Multiple Choice)

4.7/5

(28)

Question 68

A(n) ____ is perceived as a two-dimensional structure composed of rows and columns.

(Multiple Choice)

5.0/5

(37)

Question 69

A null is created when you press the Enter key or the Tab key to move to the next entry without making a prior entry of any kind.

(True/False)

4.8/5

(36)

Question 70

There is never a good reason to use null values in a database.

(True/False)

4.8/5

(33)

Question 71

Character data can contain any character or symbol intended for mathematical manipulation.

(True/False)

4.8/5

(32)

Question 72

A data dictionary contains metadata-data about data.

(True/False)

4.7/5

(36)

Question 73

In a database context, a(n) ____ indicates the use of different names to describe the same attribute.

(Multiple Choice)

4.8/5

(41)

Question 74

The one-to-many (1:M) relationship is easily implemented in the relational model by putting the foreign key of the "1" side in the table of the "many" side as a primary key.

(True/False)

4.8/5

(45)

Question 75

To be considered minimally relational, the DBMS must support the key relational operators ____, PROJECT, and JOIN.

(Multiple Choice)

4.7/5

(38)

Question 76

Referential and entity integrity are two names for the same thing.

(True/False)

4.8/5

(36)

Question 77

A ____ is any key that uniquely identifies each row.

(Multiple Choice)

4.8/5

(37)

Question 78

A(n) ____________________ links tables on the basis of an equality condition that compares specified columns of each table.

(Short Answer)

4.8/5

(42)

Question 79

The ____ constraint can be placed on a column to ensure that every row in the table has a value for that column.

(Multiple Choice)

4.8/5

(36)

Question 80

Showing 61 - 80 of 100

If one department chair-a professor-can chair only one department and one department can have only one department chair, then the entities PROFESSOR and DEPARTMENT exhibit a(n) ____________________ relationship.

What is the system catalog?

The proper use of ____________________ keys is crucial to controlling data redundancy.

Describe the use of the UNION operator.

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.

Current relational database software generally provides only a system catalog (and not a data dictionary).

Codd's Rule of ____ states: If the system supports low-level access to the data, users must not be allowed to bypass the integrity rules of the database

The ____ relational type is the "relational model ideal."

A(n) ____ is perceived as a two-dimensional structure composed of rows and columns.

A null is created when you press the Enter key or the Tab key to move to the next entry without making a prior entry of any kind.

There is never a good reason to use null values in a database.

Character data can contain any character or symbol intended for mathematical manipulation.

A data dictionary contains metadata-data about data.

In a database context, a(n) ____ indicates the use of different names to describe the same attribute.

The one-to-many (1:M) relationship is easily implemented in the relational model by putting the foreign key of the "1" side in the table of the "many" side as a primary key.

To be considered minimally relational, the DBMS must support the key relational operators ____, PROJECT, and JOIN.

Referential and entity integrity are two names for the same thing.

A ____ is any key that uniquely identifies each row.

A(n) ____________________ links tables on the basis of an equality condition that compares specified columns of each table.

The ____ constraint can be placed on a column to ensure that every row in the table has a value for that column.

The Database Approach

Database Development Process

Data Models

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters