15.00 - Questions and Answers for Primary 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 Primary Key Domains

The following questions and answers about primary 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 add Employee 12345?

      Yes

12345 is a positive integer.

Is it valid to delete the row for Employee 5?

      Yes

Employee 5 is not referenced by any other row.

Is it valid to add Employee ‑23.67?

      No

-23.67 is a negative decimal number.

Is it valid to delete the row for Employee 2?

      Yes

Cascade rule.