I have three tables:
1) Items - (PK) item_id, style_id, other fields
2) Styles - (PK) style_id, gender_id, other fields
3) Gender - (PK) gender_id, field called gender
I want to query: ALL from ITEMS where STYLEs GENDER = Male
The Questions:
Should I set up style_id in the Items table as unique?
Should I set up gender_id in the Styles table as an index?
Any words of warning?
