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.
