©
Mike Moxcey
1999
Example Tables
Lookup Table
field name
data type
required?
lk_type
varchar(6)
not null
lk_code
varchar(6)
not null
lk_desc
varchar(6)
not null
Denormalized recursive table holds ALL lookup values
home
next