ALEX TAYLOR SEAN ROBBINS SONOMA STATE UNIVERSITY CS 355: DATABASE MANAGEMENT AND DESIGN

WARBOARD DATABASE

INSTILLATION

This database is being compiled and tested under these following conditions

• RedHat 2.6.32-279.11.1.el6.x86_64
• Python 2.6.6
• MySQL 14.14

TODO

• finish MySQL scripts to create tables in the database
• finish populating tables not populated by scripts
• improve query in "populate_course.py" currently searches using only last name.
• replace names in "course_schedule.txt"

BUGS

• "course_schedule.txt" must be in both the home directory and the script directory depending on whether you run the bash script or the python script

VERSION/CHANGELOG

0.0.2 [3-10-2013]

• added course times to course table
• created "populate_courses.py"
• created "populate_faculty_member.py"
• archived "faculty_member.sql"

0.0.1 [2-24-2013]

• updated database relations to correct database
• updated mysql schema to create course table
• created script to populate the coarse table