[Kos-Master]

1) teachers:
1. (KEY) teacher_id
2. teacher_name
3. teacher_other_inf

2) groups:
1. (KEY) group_id
2. group_name
3. group_other_inf

3) subjects:
1. (KEY) subject_id
2. subject_name
3. teacher_id ( связь с teachers->teacher_id )

4) lessons:
1. (KEY) lesson_id
2. group_id ( связь с groups->group_id )
3. subject_id ( связь с subjects->subject_id )
4. date

5) tests:
1. (KEY) test_id
2. group_id ( связь с groups->group_id )
3. subject_id ( связь с subjects->subject_id )
4. date

Советую делать в MS Office Access