15.00 - Case Study, Part 2 - Teradata Database

Teradata Database Design

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

Case Study, Part 2

Now assume that you have identified and named all the domains in your database. The next step is to apply those domains to the identified entities in your logical model.

Consider the same two entities we examined before, only now their columns have been assigned names that represent the domains from which those column values are drawn.

 

employee

emp_num

last_name

birth_date

hire_date

termination_date

PK, SA

 

 

 

 

 

 

03 Apr 1960

17 Apr 1981

29 Nov 1987

 

 

31 Jan 1937

03 Apr 1960

30 Jun 1981

 

 

05 Mar 1930

21 Aug 1950

03 Apr 1960

 

order

order_number

order_date

shipping_date

billing_date

PK, UA

 

 

 

 

03 Apr 1960

10 Apr 1960

13 Apr 1960

 

29 Mar 1960

03 Apr 1960

06 Apr 1960

 

24 Mar 1960

31 Mar 1960

03 Apr 1960