Can mysql do this?

[Pedro Rodriguez]

Hi,
just a general question. I am just learning mysql. I am a teacher. I like to keep my students on their toes by giving them homework every week.

I use Python to create webpages from a template and a text file. The students choose the right answer, or write the right answer, click send.

PHP posts each student's submission and writes the answers in a text file to the webhost.

I use rsync to collect the text files and mark them using Python, by comparing the answers to a text file with the correct answers.

I'm thinking, this may all be possible using mysql on the server of my webhost, godaddy.

A table with the columns: student number, student name, week number, student answers, score.
Another table with the columns: week number, right answers

Them somehow collect each student's score for that week, download it and get it in my timetable.

Does this sound feasible? Thanks in advance for any tips!