PRAPRO2ENG.rst

Programming Laboratory

PROJECT

Project in the field of JSON + XML + HIBERNATE

Create a program that will save and read a specific data model.

Each person has to think about what type of data he wants to store in the final application (information about people, movies, cars, footballers, computers, etc.). You should model this data by defining the tables, fields and the relationships between them.

The data must contain at least 5 tables, two OneToOne relationships and two OneToMany (or ManyToMany) relationships.

Exemplary data requests should be created for the data (preferably useful in the target project). Requests must be at least 5, each query should be a separate method in the code. One of the queries should be paginated.

Please use the date type field in the project - preferably ZonedDateTime or JodaTime (as this may cause a problem), if you do not use it the maximal number of points you would get from project is 85%.

The target design should read and write modeled data from and into XML and JSON type files (both types!) And write / read them from the database. It must also use a database not stored in memory, eg. PostgreQSL, MyQSL, ORACLE etc.

You do not need to create any menu for the project, execution can be done by defining the appropriate tests method (in test classes!) For scenarios: reading data from XML / JSON file and writing to the database, reading data from the database and writing to XML / JSON files. You must create the appropriate XML / JSON files for the above mentioned tests.

Attention! read and write should execute / fail in case of providing partial / incorrect data (some empty fields).

I suggest you add the code to your repository in branch master.

Deadline for completion: 13.XII.2018 after this date, the maximum number of points to be obtained for the project is 50%.