Hi All, How can a database design be modelled using UML ? My thoughts on this : 1) Using Class Diagrams for representing Tables, views etc, and 2) Using Deployment Diagrams for representing Physical Structure Please let me know your comments Thanks, Rupesh
Lasse Koskela
author
Sheriff
Joined: Jan 23, 2002
Posts: 11962
5
posted
0
Sounds good. If you're serious about database modeling, there's a book called Agile Database Techniques from Scott Ambler, which contains a lot of useful information on how to model a database schema with UML.
The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
Thomas Paul
mister krabs
Ranch Hand
Joined: May 05, 2000
Posts: 13974
posted
0
Logical database design is done using class diagrams. The UML calls for using the {persistent} tag to identify the objects as logical database entries. Then design the associations for the objects. This is extremely useful because potential design flaws such as one-to-one, cyclic, and n-ary associations will become quite obvious. Mapping your logical design to a physical design is done with standard UML component diagrams. You will want to take into account the physical distribution of your database at this point. (It may be that your logical tables will live in different databases on different servers.)
0
