CREATE TABLE student (
sid int primary key,
sfirst text,
slast text,
semail text
);

CREATE TABLE major (
sid int,
major text
);

CREATE TABLE course (
cid int primary key,
cname text
);

CREATE TABLE professor (
pid int primary key,
pfirst text,
plast text,
pemail text
);

CREATE TABLE enrolled (
sid int,
cid int
);

CREATE TABLE teaches (
pid int,
cid int
);

INSERT INTO student (sid, sfirst, slast, semail) VALUES
(0, "Ryan", "Marcus", "ryan@cs.brandeis.edu"),
(1, "Tiffany", "Chen", "tchen@brandeis.edu"),
(2, "Solomon", "Garber", "solomon@cs.brandeis.edu"),
(3, "Sofiya", "Semenova", "sofiya@brandeis.edu"),
(4, "Nick", "Moran", "nick@cs.brandeis.edu"),
(5, "Grace", "Hopper", "ghops@cs.brandeis.edu"),
(6, "Alan", "Turing", "aman@cs.brandeis.edu"),
(7, "Ada", "Lovelace", "dalove@cs.brandeis.edu");

INSERT INTO major (sid, major) VALUES
(0, "Computer science"),
(1, "Mathematics"),
(3, "Art"),
(4, "Computer science"),
(5, "Naval sciences"),
(7, "Mathematics");


INSERT INTO course (cid, cname) VALUES
(0, "CS132"),
(1, "CS127"),
(2, "CS12b"),
(3, "CS131");

INSERT INTO professor (pid, pfirst, plast, pemail) VALUES
(0, "Mitch", "Cherniack", "mfc@brandeis.edu"),
(1, "Olga", "Papaemmanouil", "olga@cs.brandeis.edu"),
(2, "Liuba", "Shrira", "liuba@brandeis.edu");

INSERT INTO enrolled (sid, cid) VALUES
(0, 2), 
(1, 0), 
(1, 1), 
(2, 0), 
(3, 1), 
(4, 2), 
(4, 1), 
(5, 1), 
(6, 0),
(6, 3),
(7, 2), 
(7, 1),
(7, 0);

INSERT INTO teaches (pid, cid) VALUES
(0, 1),
(1, 0),
(1, 2),
(2, 3);