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 - don't jut retrieve lists and do the work in Java as I have seen done in the past - SQL has queries for these.
