• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Class diagram for database

 
Ashish Sarin
author
Ranch Hand
Posts: 444
10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi everyone,

I have created a database class diagram to show important attributes, primary keys, relationships and multiplicity. I know this is possibly an overkill but this helps me in hightlighting of some of the design decisions. I haven't seen many database class diagrams, but would like to know that does it makes sense to show the primary key of a table by using the notation: Customer_ID(PK) ? or its better to write it in the notes ?

thanks
Ashish
 
J Gupta
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ashish
What is a class database digram. Did you meam ER diagram ? ER digram and
Class diagram are two different things.
 
Ashish Sarin
author
Ranch Hand
Posts: 444
10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I mean the data model class diagram.
 
Hong Anderson
Ranch Hand
Posts: 1936
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Class diagram is for class, not database table.

About showing PK by (PK), I think it's OK, if you explain in documentation.
 
Ashish Sarin
author
Ranch Hand
Posts: 444
10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How is data model class diagram different from a normal class diagram depicting various classes in the system? I thought that that data model class diagram is made from database perspective, where you specify the tables and their columns and their associations. Can you please mention some links to have a look at a few sample data models ?

thanks
Ashish
 
Deepak Bala
Bartender
Posts: 6663
5
Firefox Browser Linux MyEclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Ashish Sarin:
How is data model class diagram different from a normal class diagram depicting various classes in the system? I thought that that data model class diagram is made from database perspective, where you specify the tables and their columns and their associations. Can you please mention some links to have a look at a few sample data models ?

thanks
Ashish


It is usually called an ER diagram or a data model. There is no such thing as a data model class diagram.

Anything that you feel will help explain your system better is a good thing. You sure can include the diagram in the solution documentation. Good luck with your exam
 
Ashish Sarin
author
Ranch Hand
Posts: 444
10
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic