Re: Design for Category Feature

I don't understand what "CATEGORY_ID" is in your model. I would have expected to see this (SQL):

CREATE TABLE person_category (category_id INTEGER NOT NULL REFERENCES categories (category_id), person_id INTEGER NOT NULL REFERENCES persons (person_id), PRIMARY KEY (category_id,person_id));

Why would you need a third column?

-- 
David Portas 
SQL Server MVP 
--