• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Class diagram for database

 
author
Posts: 469
20
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 469
20
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I mean the data model class diagram.
 
Ranch Hand
Posts: 1936
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 469
20
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Bartender
Posts: 6663
5
MyEclipse IDE Firefox Browser Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 469
20
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks John
 
reply
    Bookmark Topic Watch Topic
  • New Topic