Assignment 2 has four questions. Both UG and PG students need to finish all four questions. The first two
questions are the same for UG and PG students, while the last two questions have different requirements for UG
and PG students.
Please answer the questions in the format of descriptions, equations, query graphs and the operator trees in
question 1-4. Only the query graph and the operator tree can be handwritten; others such as descriptions and
equations must be in electronic version. For the handwritten parts, you could save them as jpg. or png., and
insert them into office word. Please submit the electronic version and do not submit the handwritten version of
descriptions and equations. Handwritten descriptions and equations will not be marked.
You are expected to provide your answers for the all four questions in one pdf and submit the pdf in MyUni,
Assignment 2.
If you have any questions about assignment 2, please feel free to post the questions on the discussion board or
contact Congbo Ma ([email protected]).
Given three relations STUDENT, COURSE and MARK, a user query is: “Find the student name and Course name of
students whose scores are more than 85 points.”
(1) Please give the claculus query (SQL) (1 mark);
(2) Please give the corresponging query graph (2 mark);
(3) Please map the SQL query into an original operator tree (Not optimized) (1 mark).