Insert into Student Values
(00128, "Zhang", "Comp. Sci.", 102),
(12345, "Shankar", "Comp. Sci.", 32),
(19991, "Brandt", "History", 80),
(23121, "Chavez", "Finance", 110),
(44553, "Peltier", "Physics", 56),
(45678, "Levy", "Physics", 46),
(54321, "Williams", "Comp. Sci.", 54),
(55739, "Sanchez", "Music", 38),
(70557, "Snow", "Physcis",0),
(76543, "Brown", "Comp. Sci.", 58),
(76653, "Aoi", "Elec. Eng.", 60),
(98765, "Bourikas", "Elec. Eng.", 98),
(98988, "Tanaka", "Biology", 120);

Insert into Takes Values
(00128, "CS-101", 1, "Fall", 2017, "A"),
(00128, "CS-347", 1, "Fall", 2017, "A-"),
(12345, "CS-101", 1, "Fall", 2017, "C"),
(12345, "CS-190", 2, "Spring", 2017, "A"),
(12345, "CS-315", 1, "Spring", 2018, "A"),
(12345, "CS-347", 1, "Fall", 2017, "A"),
(19991, "HIS-351", 1, "Spring", 2018, "B"),
(23121, "FIN-201", 1, "Spring", 2018, "C+"),
(44553, "PHY-101", 1, "Fall", 2017, "B-"),
(45678, "CS-101", 1, "Fall", 2017, "F"),
(45678, "CS-101", 1, "Spring", 2018, "B+"),
(45678, "CS-319", 1, "Spring", 2018, "B"),
(54321, "CS-101", 1, "Fall", 2017, "A-"),
(54321, "CS-190", 2, "Spring", 2017, "B+"),
(55739, "MU-199", 1, "Spring", 2018, "A-"),
(76543, "CS-101", 1, "Fall", 2017, "A"),
(76543, "CS-319", 2, "Spring", 2018, "A"),
(76653, "EE-181", 1, "Spring", 2017, "C"),
(98765, "CS-101", 1, "Fall", 2017, "C-"),
(98765, "CS-315", 1, "Spring", 2018, "B"),
(98988, "BIO-101", 1, "Summer", 2017, "A"),
(98988, "BIO-301", 1, "Summer", 2018, NULL);