Re: Data Dictionary

You need 5 tables:

1. Clothing:  1 row per clothing item
2. Size:  "lookup table" of available sizes, 1 row per size
3. Color:  "lookup" table of available colors, 1 row per color
4. ClothingSize:  combinations of clothing and size
5. ClothingColor:  combinations of clothing and color

Tables 4 and 5 are sometimes called "associative" tables. They are used to implement "many-to-many relationships." For example, one clothing item comes in many sizes, and one size many be used for many clothing items.

From the nature of your question, I suggest employing some professional. Otherwise, you'll probably be disappointed in the results.

Lab wrote:

> Hi all!
>
> I'm recently working on a project about on-line shopping. I'm now
> designing the Data Dictionary of my tables, and have encountered the
> following simple problem:
>
> My database is about the details of the clothes I sell. So, some of
> the required attributes of the table "ClothingDescription" should
> include NameOfClothing, SizesAvailable, and..... COLORS, etc.
>
> The problem is here now -- a piece of clothing has different colors
> available, but how can I design the data dictionary for colors? The
> number of colors offered for each piece of clothing varies, so how
> should I design the data dictionary for Colors?
>
> I think the problem is similar of designing a database for students and
> the courses they enrol.... different students enrol different number of
> courses, but you need to store the different courses they have enrolled.
>
> I know this is a simple and basic database problem, but I really don't
> know the answer.
>
> Can anyone please help? Thanks very very much!!!!!!!
Received on Tue Mar 14 2000 - 00:00:00 CET