Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Data Dictionary

Re: Data Dictionary

From: topmind <topmindNOtoSPAM_at_technologist.com.invalid>
Date: 2000/03/13
Message-ID: <31785d65.dc007eff@usw-ex0101-006.remarq.com>#1/1

You would probably have a Clothing table, a Color table, and a middle table that relates the two if the number of colors is variable.

The middle table may have the following fields:

ClothingRef (links to ClothingID)
ColorRef (links to ColorID)

If there is a practical maximum of colors, then it may make things easier to have Color1, Color2, Color3......in your clothing table. Some complain about this approach from a theoretical point of view, but it often simplifies things if you are under pressure to get it done (RAD).

-tmind-

Received on Mon Mar 13 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US