Problem 1 Ms English Mr Conder Arie Ferd Problem 2 { "teacher" : "Ms English" , "group" : { "chaperone" : "Mr Conder" , "students" : [ "Arie" , "Ferd" ] } } Problem 3 Problem 4 { "type":"object", "required" : ["teacher", "group"] , "properties" : { "teacher" : { "type" : "string" } , "group" : { "type" : "object", "required" : [ "students" ] , "properties" : { "chaperone" : { "type" : "string" } , "students" : { "type" : "array", "items" : { "type" : "string" } } } } } } Problem 5 PI (sigma (Friend CROSS Highschooler)) name, ID ID = ID1 and name <> 'Kyle' Problem 6 SELECT H.name FROM Highschooler H WHERE H.grade = 10 ORDER BY H.name ; Problem 7 SELECT H.grade, count(*) FROM Highschooler H GROUP by H.grade ORDER BY H.grade ; Problem 8 SELECT H1.name, H2.name FROM Highschooler H1, Highschooler H2, Friend F WHERE H1.grade = H2.grade and H1.name < H2.name and H1.ID = F.ID1 and H2.ID = F.ID2 ; Problem 9 SELECT H.name FROM Highschooler H WHERE H.name NOT LIKE '%e%' ; Problem 10 SELECT DISTINCT H.name, H.ID FROM Highschooler H, Highschooler H1, Highschooler H2, Friend F1, Friend F2 WHERE H.ID = F1.ID1 and H1.ID = F1.ID2 and H.ID = F2.ID1 and H2.ID = F2.ID2 and H1.ID <> H2.ID and H1.name = H2.name ;