I need help understanding how to make a Database Diagram on Product order

Answer 1

@Daniel, if you're using Ms SQL Server there's a tool provided exactly for that purpose, though I don't know where to access it in recent versions, at least when I was using the 2005 edition I get to use it from Enterprise Manager, as long as you designed the relationships well the wizard can easily create a diagram for you.

I can only suggest you to search online for such tools/extension if you were using other DBMS.

Hth, cmiiw

Answer 2

My problem is I don't understand the relationship terms or rules that well in order to define relationship between tables