Search code examples
sqlumlclass-diagram

Mapping Class Diagram into database table design


I've taken the following class diagram and mapped it into a table design with appropriate keys etc... Am i thinking along the right lines here?

Class Diagram

Table Design


Solution

  • OK, but I wonder how should I have found that without you sharing it :) The correctness of your plan mainly depends on your needs. Technically speaking, I believe your diagram is more-or-less correct (not taking into account your needs, as they were not shared in the question). However, I think you should include the identifiers and foreign keys into the diagram as well.

    EDIT: For some reason the picture was not showing up and I did not check the console, I believed op forgot to share it, but it turns out that I was wrong.