Problem solving

[arnelgp]

you "document" everything.
by everything is whatever you can cover and record.

prisoners table:
prisoner id (auto)
prisoner name
nationality
gender
date of birth
(other info)

camp table:
camp id (auto)
camp name
location
country
(other info)

transfer table:
prisoner id (long)
camp id (long)
transfer date and time
notes (reasons of transfer, who is making the transfer, etc)