This project is designed for you to apply all that you have learned so far to a project.

You are not allowed to use Spring Boot. You are not allowed to use JPA.

Specification

A database holds household information

• the Eircode of the house
• the address of the house
• details about the occupants of the house

The data about the occupants:

• Name
• Age
• Occupation o scholar for school-going children o pre-school for pre-school children

The application should allow a user to (using a menu based system):

• Search for a household by Eircode, listing the details of the people in the household
• Add a household, along with its occupant(s)
• Add a new person and assign that person to a household
• Move a person from one household to another
• Delete a household, along with its occupants
• Delete a person
• Display some statistics* o the average age of householders o the number of students in the households o the number of OAPs (aged 65+) in the household

No security is needed.

You must write 4 unit tests,

Refer to the rubric for expected standards.

* Use SQL queries here dont jut retrieve lists and do the work in Java as I have seen done in the past SQL has queries for these.