One table or duplicate table with same properties but different dependencies Disclaimer: I'm new to database modeling so I apologize in advance if the question is unclear or causes any confusion.

I am using .NET Entity Framework and have the following tables:



An Order can have multiple Items, but Item itself is not existence dependent on Order. That said, should I have two separate tables for Item, e.g. InventoryItem and OrderItem? If not, how should I manage the relationship?

Any help is appreciated!
When you have a many to many relationship it's better to introduce a table which holds the relationship between the two tables which is much more normalized.