JPA exercice

Derby client jar

Part I

fetch the SQL code for the database. Propose (first, as a UML schema) an object representation for this database.

Think, in particular of the navigation rules, in order to lessen coupling

Part II

Question 1

Implement the entity classes according to the proposed UML solution, given in course. We will implement bidirectional links between Course and CourseDomain, which is probably not needed, for the sake of playing with JPA.

Question 2

Start with a number of small simple programs:

• Insert professor "babbage" in the database
• Fetch all professors from the database and print their name
• Fetch all professors from the database, and ensure their names starts with an uppercase letter, correct if it's not the case. The change should modify the database content

Question 3

Insert a student group "1year" in the database (manually or through a program)

Insert the two domains "java" and "programming".

Write a program which will create "java101", a course taught by Babbage on java programming to the "1year" students. Check that the data is correct in the database. List the courses for the subject "programming".

Question 4

implements the ClassRoomFacade interface.

provide a very simple text-oriented user interface with the following menus:

• Create, list, edit professor
• Create a group of students (along with the corresponding students)
• Create Course domains
• Create courses
• list course domains and the corresponding courses titles