AgentLee/CS336_Project — pull request #5 by awelsh7 (2014-08-10 18:44:31+00:00)
Title: Update updatedTables.sql

- fixed small syntax errors
- changed primary key for Transcript to (ruid, cid, semesterid, year, majorid). This way the Transcript reflects every class a student took, every semester, every year. So if they took a class twice, it will appear twice with different semesterids and/or years.
- changed the name of prerequisites table to prereq because I kept misspelling prerequisite (easy to change back though if this causes issues)
- deleted Register table because it was never used or referenced by anything else
- All tables tested and work in mySQL BUT:
- Courses and prereq reference each other, so you have to add Courses first without the prereq foreign key
- then add prereq table
- then ALTER TABLE Courses FOREIGN KEY (prereqMajorID, prereqCID) REFERENCES prereq(majorID, cid)