Class diagram for database

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

Ashish
What is a class database digram. Did you meam ER diagram ? ER digram and
Class diagram are two different things.

I mean the data model class diagram.

Class diagram is for class, not database table.

About showing PK by (PK), I think it's OK, if you explain in documentation.

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

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

Thanks John