Flight search engine

Software requirements: Java, Maven, MySQL-database, JAXRS. We are creating an Online Reservation System, similar to Web sites like [login to view URL], [login to view URL] and others. We need you to create the backend. We want you to setup and create a mySQL database using Java Persistence API (JPA). The tables within the database should look somewhat similar a domain model we’ve made. Then we need you to create a RESTful service with two get methods and a single post method. You can see what the URL’s and the JSON objects should look like in the tables we’ve made. Also error codes 400, 404 and 500 should be handled with a simple message for the end users. Milestones: 1: The database is created and set up with tables with JPA 2: The RESTful service should have the three methods set up 3: HTTP error handling 4: Rest Assured-tests on the API’s Payment type: You are being paid through milestones, which we’ve created. When a milestone is done 25% of the amount will be released.