15.00 - Questions and Answers for Foreign Key Domains - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Questions and Answers for Foreign Key Domains

The following questions and answers about foreign keys indicate some examples of how domain integrity is enforced. The questions refer to the table defined in “Table Definition for Examples” on page 101.

 

Question

Answer

Explanation

Is it valid to have Employee 6 report to Employee 4?

      Yes

Employee 4 is drawn from the set of existing employee numbers.

Is it valid to delete the row for Employee 7?

      No

Employee 7 has an assigned foreign key value.

Is it valid to have Employee 6 report to Employee 8?

      No

Employee 8 is not drawn from the set of existing employee numbers.