departmentsetup.sql

-- Insert Department data: DNO-Dname
INSERT INTO Department (dno,dname)
  VALUES (362,'Africana Studies');
  
INSERT INTO Department (dno,dname)
  VALUES (070,'Anthropology');

INSERT INTO Department (dno,dname)
  VALUES (550,'Applied Mathematics and Statistics');

INSERT INTO Department (dno,dname)
  VALUES (371,'Art');

INSERT INTO Department (dno,dname)
  VALUES (290,'Behavioral Biology');

INSERT INTO Department (dno,dname)
  VALUES (020,'Biology');

INSERT INTO Department (dno,dname)
  VALUES (580,'Biomedical Engineering');

INSERT INTO Department (dno,dname)
  VALUES (250,'Biophysics');

INSERT INTO Department (dno,dname)
  VALUES (375,'Arabic');

INSERT INTO Department (dno,dname)
  VALUES (373,'Chinese');

INSERT INTO Department (dno,dname)
  VALUES (384,'Hebrew');

INSERT INTO Department (dno,dname)
  VALUES (381,'Hindi');

INSERT INTO Department (dno,dname)
  VALUES (378,'Japanese');

INSERT INTO Department (dno,dname)
  VALUES (380,'Korean');

INSERT INTO Department (dno,dname)
  VALUES (377,'Russian');

INSERT INTO Department (dno,dname)
  VALUES (663,'Center for Leadership Education');

INSERT INTO Department (dno,dname)
  VALUES (540,'Chemical and Biomolecular Engineering');

INSERT INTO Department (dno,dname)
  VALUES (030,'Chemistry');

INSERT INTO Department (dno,dname)
  VALUES (560,'Civil Engineering');

INSERT INTO Department (dno,dname)
  VALUES (040,'Classics');

INSERT INTO Department (dno,dname)
  VALUES (050,'Cognitive Science');

INSERT INTO Department (dno,dname)
  VALUES (600,'Computer Science');

INSERT INTO Department (dno,dname)
  VALUES (270,'Earth and Planetary Sciences');

INSERT INTO Department (dno,dname)
  VALUES (310,'East Asian');

INSERT INTO Department (dno,dname)
  VALUES (180,'Economics');

INSERT INTO Department (dno,dname)
  VALUES (520,'Electrical and Computer Engineering');

INSERT INTO Department (dno,dname)
  VALUES (662,'Engineering Management');

INSERT INTO Department (dno,dname)
  VALUES (060,'English');

INSERT INTO Department (dno,dname)
  VALUES (660,'Entrepreneurship and Management');

INSERT INTO Department (dno,dname)
  VALUES (061,'Film and Media Studies');

INSERT INTO Department (dno,dname)
  VALUES (500,'General Engineering');

INSERT INTO Department (dno,dname)
  VALUES (570,'Geography and Environmental Engineering');

INSERT INTO Department (dno,dname)
  VALUES (210,'German and Romance Languages and Literatures');

INSERT INTO Department (dno,dname)
  VALUES (100,'History');

INSERT INTO Department (dno,dname)
  VALUES (010,'History of Art');

INSERT INTO Department (dno,dname)
  VALUES (140,'History of Science and Technology');

INSERT INTO Department (dno,dname)
  VALUES (300,'Humanities');

INSERT INTO Department (dno,dname)
  VALUES (650,'Information Security Institute');

INSERT INTO Department (dno,dname)
  VALUES (360,'Interdepartmental');

INSERT INTO Department (dno,dname)
  VALUES (193,'Jewish Studies');

INSERT INTO Department (dno,dname)
  VALUES (361,'Latin American Studies');

INSERT INTO Department (dno,dname)
  VALUES (510,'Materials Science and Engineering');

INSERT INTO Department (dno,dname)
  VALUES (110,'Mathematics');

INSERT INTO Department (dno,dname)
  VALUES (530,'Mechanical Engineering');

INSERT INTO Department (dno,dname)
  VALUES (374,'Military Science');

INSERT INTO Department (dno,dname)
  VALUES (389,'Museum and Society Programs');

INSERT INTO Department (dno,dname)
  VALUES (376,'Music');

INSERT INTO Department (dno,dname)
  VALUES (670,'Nanobiotechnology');

INSERT INTO Department (dno,dname)
  VALUES (130,'Near Eastern Studies');

INSERT INTO Department (dno,dname)
  VALUES (080,'Neuroscience');

INSERT INTO Department (dno,dname)
  VALUES (150,'Philosophy');

INSERT INTO Department (dno,dname)
  VALUES (171,'Physics and Astronomy');

INSERT INTO Department (dno,dname)
  VALUES (190,'Political Science');

INSERT INTO Department (dno,dname)
  VALUES (661,'Professional Communication');

INSERT INTO Department (dno,dname)
  VALUES (200,'Psychological and Brain Sciences');

INSERT INTO Department (dno,dname)
  VALUES (280,'Public Health Studies');

INSERT INTO Department (dno,dname)
  VALUES (230,'Sociology');

INSERT INTO Department (dno,dname)
  VALUES (225,'Theatre Arts and Studies');

INSERT INTO Department (dno,dname)
  VALUES (363,'Woman Gender and Sexuality Program');

INSERT INTO Department (dno,dname)
  VALUES (220,'Writing Seminars');