Questions and Answers for Foreign Key Domains - Teradata Database

Teradata Database Design

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

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 103.

 

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.