GTManager

Description

A data management system for multiple households, together with their members. Allows for observing record changes in time.

Goals

• storage of personal data
• storage of household data (surface, material goods, etc.)
• saving previous records of changed data
• multiple users

To do / fix:

• degrees can't be awarded in the future

• one should be able to remove degrees

• perfect authentication system

• IDs in temporal tables may point to inexistent households or people

• the state of a person's degrees can't be viewed as it was in the past

• possible optimization: service classes could handle exceptions in one place, not in each method individually

• CNPs must be unique

• editing CNPs doesn't work

• data backup capabilities

• abstract controllers to one operational model

• custom exception classes

• make the app display an error message if database is down

Technical details

Trait	Value
architecture	MVCS
database	JDBC

Database schema