Database Design Question

[Chris Kelleher]

When presented with 5 to 6 seperate tables but all having the same
characteristics as below:

type x (s)oft, (m)etal, (f)iller or (g)eneric
code xxxx any one to 4 digit id
desc x(30) description

Is there any reason I cannot place into one table with type + desc as
primary index? Do multiple tables make more sense or more work. Any
suggestions appreciated.

TIA

James E. Dupree
PEG # 1999041502

 

[Chris Kelleher]

My only suggestion would be to add a key to designate to which list the
record belongs so your key would be
key + type + desc. Would keep things simpler and easier to locate.

Patrick T. Gordon
Senior Software Engineer
Software Services
Symix Computer Systems, Inc.
Columbus, OH 43231
Phone: 614/523-7000
Fax: 614/895-1195