Hello!.......I'm studying in 5th sem...I'm working on a DBMS project "Color analysis".....can anyone please tel me how to do creations of composit and multivalued attributes?

could you please elaborate the requirements?

Ya....In my project we have composite & multivalued attributes in tables.....how can we represent these in creation of tables???can we do this in MySql 5.0????

if i understand the requirement correctly, my suggestion is to go for an INT column where each bit represents a specific value.

consider the following example of colors

R G B Numeric Value
1 1 1 7
1 1 0 6
1 0 1 5
1 0 0 4
0 1 1 3
0 1 0 2
0 0 1 1
0 0 0 0

If we have to represent these color combination in a single column,

7 represents the combination where R,B and G are 1 whereas
4 represents the combination where R=1 and G and B are 0s.

If we define the bit positions for each of the composite attributes, a BIT wise OR of values can be stored in the column which represents the combination..

let me know if this solves your problem