All geek questions in one place

Creating an object relational schema from a class diagram

I need help converting the following UML diagram:

UML diagram

The chart shows 4 classes and is associated with a loyalty card card for an imaginary supermarket.

I would like to create an object relational database schema from it for use with Oracle 10g / 11g. Not sure where to start, if someone can give me a start, it will be great.

You are looking for the actual beginning of the schema, abstraction methods, constraints, types (subtypes, supertypes) and functions.

Note: I am not looking for anyone to make any comments regarding the actual classes and whether changes should be made to the Diagram, only the diagram.

thank

+3
source share
2 answers

You are talking about how to create a mapping between a database and an object-oriented design. This is a big topic and you will come across the so-called impedance mismatch. A google search for “impedance mismatch” will give many pointers to documentation.

A good starting point is this a-journey-with-domain-driven-design-and-nhibernate blog post that discusses creating a table for each class, a table for each class hierarchy, or creating a table for each subclass. Looking at your design, you must also make this design decision.

+1
source

, ORM, NHibernate DBRM?

, , , .

0

Source: https://habr.com/ru/post/1745134/

More articles:


All Articles