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!!!!!!!