Hi Ali,

I am not sure I got you right.
Could you please explain in more detail.
Where for instance is the attribute value?
How would you search for an "instance" of a category
with specific attribute values?

--Heiko

> CREATE TABLE CATEGORY (
> ID INTEGER PRIMARY KEY ,
> NAME VARCHAR(32) NOT NULL UNIQUE
> );
>
> CREATE TABLE ATTRIBUTE (
> ID INTEGER PRIMARY KEY,
> NAME VARCHAR(32) NOT NULL UNIQUE
> );
>
> CREATE TABLE ITEM (
> CAT_ID INTEGER NOT NULL REFERENCES CATEGORY(ID),
> ATT_ID INTEGER NOT NULL REFERENCES ATTRIBUTE(ID),
> NAME VARCHAR(32) NOT NULL UNIQUE
> );