• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Physical Data Modelling diagram - (1 - m) relationship

 
kri shan
Ranch Hand
Posts: 1460
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have 3 tables( Company, Dept, Employee). Each Company has many Depts and each Dept has many Employee's. How can i mention these table relationships thru Physical Data Modelling diagrams.
 
Scott Ambler
author
Ranch Hand
Posts: 608
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Each table would appear as a box. Then draw a one to many association between them. Introduce Calculated Column provides an example where a Customer has many Accounts. This example uses UML data modeling notation although there are other common notations.

- Scott
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic