     member_id INT(10) NOT NULL AUTO_INCREMENT,
     member_name VARCHAR(50) NOT NULL,
     PRIMARY KEY (member_id),
-    FOREIGN KEY (faculty_id, department_name) REFERENCES Departments(faculty_id, department_name) ON DELETE NO ACTION
+    FOREIGN KEY (faculty_id, department_name) REFERENCES Departments(faculty_id, department_name) 
+        ON DELETE NO ACTION
+        ON UPDATE CASCADE
 ) DEFAULT CHARACTER SET = utf8;
 
 CREATE TABLE IF NOT EXISTS Instructors(
     member_id INT(10) NOT NULL,
     PRIMARY KEY (member_id),
-    FOREIGN KEY (member_id) REFERENCES Faculty_Members(member_id) ON DELETE CASCADE
+    FOREIGN KEY (member_id) REFERENCES Faculty_Members(member_id) 
+        ON DELETE CASCADE
+        ON UPDATE CASCADE
 ) DEFAULT CHARACTER SET = utf8;
 
 CREATE TABLE IF NOT EXISTS Advisors(
     member_id INT(10) NOT NULL,
     PRIMARY KEY (member_id),
-    FOREIGN KEY (member_id) REFERENCES Faculty_Members(member_id) ON DELETE CASCADE
+    FOREIGN KEY (member_id) REFERENCES Faculty_Members(member_id) 
+        ON DELETE CASCADE
+        ON UPDATE CASCADE
 ) DEFAULT CHARACTER SET = utf8;
 
 CREATE TABLE IF NOT EXISTS Curricula(

    project_id INT(10) NOT NULL,
    sid INT(10) NOT NULL,
    PRIMARY KEY (project_id, sid),
    FOREIGN KEY (project_id) REFERENCES Projects(project_id) ON DELETE CASCADE,
    FOREIGN KEY (sid) REFERENCES Students(sid) ON DELETE NO ACTION
) DEFAULT CHARACTER SET = utf8;

CREATE TABLE IF NOT EXISTS Advises_Senior(

    leave_type CHAR(1) NOT NULL,
    leave_description VARCHAR(255),
    PRIMARY KEY (sid, semester, year),
    FOREIGN KEY (sid) REFERENCES Students(sid) 
        ON DELETE NO ACTION
        ON UPDATE CASCADE
) DEFAULT CHARACTER SET = utf8;

CREATE TABLE IF NOT EXISTS Projects(
