Thanks in advance for your answer. I am trying to tune my db skills.
I have 3 tables:
Brand, Model and Item.
All models belongs to a brand, but an item can have a brand but not a model.
I have 2 questions:
From a programming point of view I just add brandId as foreign key and ModelId just as a field to Item table.But from database design perspective, I guess this is the wrong approach. How I should manage it?
In the case that an Item always have a model and brand. I usually only add modelId and from it I can get brandId, but I have been seeing a growing wave where both fields would be added to item table, again, what is the correct approach?