Assignment 4 - Choice D - Object-Relational Mapper

This is one of the choices for Assignment 4 The goal of this assignment choice is to understand O-R mapping.

Deadlines: This assignment puts together 2 lab sessions (corresponding weeks 11 and 12). Results should be presented no later than week 13. Delays bring a penalty of 1 point for each weeek of delay after the deadline. Optional parts have an extended deadline - week 14.

General grading policy: Grades reflect your individual knowledge and contribution. Each student must complete and present their own solutions. The solutions developed "in group" or copied will be assigned 0(zero) points. Not presenting the assignment is assigned 4 points.

Problem description

References

lecture notes of week 11 dacss11-OORM.ppt
real life technologies examples: https://jakarta.ee/learn/starter-guides/how-to-store-and-retrieve-data-using-jakarta-persistence/, https://hibernate.org/orm/ https://docs.oracle.com/javaee/7/tutorial/persistence-intro.htm, https://hibernate.org/orm/

Design and implement a (part of) a simplified Object Relational Mapper.

Standard requirements

Implement a generator which takes as input a set of classes (related by inheritance and association relationships) and determines and generates the structure of the corresponding database tables and their relationships. The generator applies the known patterns for mapping different types of class relationships to tables relationships. This part already contains one bonus point.

Optional features

In order to create a complete ORM, add following features:

1 bonus point: implement also an EntityManager that can save different objects (instances of the entity classes) into the generated database tables.

Write at least 2 different applications using 2 different models to test your ORM.