     department_name VARCHAR(50) NOT NULL,
     semester_system_type CHAR(1) NOT NULL,
     PRIMARY KEY (curriculum_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 NO ACTION  
+        # Should create new curricula instead
 ) DEFAULT CHARACTER SET = utf8;
 
 CREATE TABLE IF NOT EXISTS Courses(

    member_id INT(10),
    capacity INT(3) NOT NULL,
    PRIMARY KEY (course_id, semester, year, section_no),
    FOREIGN KEY (course_id) REFERENCES Courses(course_id) ON DELETE CASCADE,
    FOREIGN KEY (member_id) REFERENCES Instructors(member_id) ON DELETE SET NULL
) DEFAULT CHARACTER SET = utf8;

CREATE TABLE IF NOT EXISTS Zipcode(

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

CREATE TABLE IF NOT EXISTS Competition_Teams(
