A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
OO, Patterns, UML and Refactoring
Physical Data Modelling diagram - (1 - m) relationship
Joined: Apr 08, 2004
Apr 05, 2006 23:31:00
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.
Joined: Dec 12, 2003
Apr 06, 2006 07:12:00
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.
<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>
Have you checked out
subject: Physical Data Modelling diagram - (1 - m) relationship
Data modelling in RUP or XP
hibernate association delete
Refactoring Databases : Evolutionary Database Design
RAF pooling and physical locking
Generic Question about Assignment
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015