aspose file tools*
The moose likes OO, Patterns, UML and Refactoring and the fly likes Physical Data Modelling diagram - (1 - m) relationship Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Engineering » OO, Patterns, UML and Refactoring
Bookmark "Physical Data Modelling diagram - (1 - m) relationship" Watch "Physical Data Modelling diagram - (1 - m) relationship" New topic
Author

Physical Data Modelling diagram - (1 - m) relationship

kri shan
Ranch Hand

Joined: Apr 08, 2004
Posts: 1365
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

Joined: Dec 12, 2003
Posts: 608
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


<a href="http://www-306.ibm.com/software/rational/bios/ambler.html" target="_blank" rel="nofollow">Scott W. Ambler</a><br />Practice Leader Agile Development, IBM Rational<br /> <br />Now available: <a href="http://www.ambysoft.com/books/refactoringDatabases.html" target="_blank" rel="nofollow">Refactoring Databases: Evolutionary Database Design</a>
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Physical Data Modelling diagram - (1 - m) relationship
 
Similar Threads
Refactoring Databases : Evolutionary Database Design
RAF pooling and physical locking
Generic Question about Assignment
Data modelling in RUP or XP
hibernate association delete