Informatics Forum

How to create Database model with Power Designer

Posted on: December 22, 2007

Actually, there are some software to create database model, for example Power Designer, ERWin, Toad data modeler, Microsoft Visio and etc . But I think after compared, power designer is the best. Why it is the best,it have good visualization and easy to modify about entity and relationship between entity. This tools have the good about easy to generate figure and sql script. You just choose kind of database, and it generated.

Sybase as developer this software have shared trial edition as long 15 days. you can download in http://download.sybase.com/eval/PowerDesigner/powerdesigner125_eval.exe. after that install into your PC, very easy to install because you just click next and next, very standard of windows software installation.

11.jpg

On this software you will know about :

a. Entity, entity is an object on system have some attribute or specification and it have relationship and activity doing in the system. Example : on schools system, teacher, student is an entity. symbol of attribute on Power designer is 2.jpg

b. Attribute, attribute is some specification and detailed spec of entity. for example Teacher have attributes : Name, teacher id, sex and etc.

3.jpg

c. Relationship, connectivity of between 2 entities

5.jpg

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Pages

Blog Stats

  • 131,473 hits

Category

Online

visitor stats
December 2007
M T W T F S S
« Nov   Jan »
 12
3456789
10111213141516
17181920212223
24252627282930
31  
%d bloggers like this: