Tracking VT Student Production Experience

Our client, The Virginia Tech Theatre Department is required by their accrediting body (National Association of Schools of Theatre), to maintain records of their students’ experience in various productions. They asked us to modernize their previously existing system, which was impractical and had fallen into disuse. We decided that the optimal solution would be a web-based interface to collect and store records entered by the students. Our main priority was that the system require minimal upkeep, while still having the flexibility and scalability to meet the growing needs of the School of Performing Arts. To this end, we designed and built a a front-end web page and a back-end database.

The website is built using PHP and JavaScript/jQuery. The database is a MySQL database. It consists of a login-in screen, for students and admins. Students can submit records, view/delete their own records, and download a copy. Admins can view/delete all students records, as well as download a copy. All data is submitted by the students. The project source code files contain the files for the website and the SQL commands to build the database tables.