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)