You asked what is does Program mean. It is actually the classroom identification for that staff person. there are several staff who would not have that due to staff who do not work in a classroom or staff who are "floaters" or AN(as needed) who are not assigned to 1 particular classroom.
ok...I'm ready to tackle the issues with my current database. As you know there's a lot of work to be done. Where should I begin? You suggested combining some tables and changes their PK and creating FK. I'm ready whenever you are able to help me to get this done right and most effective.