EECS 3421 Midterm: EECS-3421A test2-f2016
Document Summary
Use of a calculator is permitted: answers. Should you feel a question needs an assumption to be able to answer it, write the assumptions you need along with your answer. If you need more room to write an answer, indicate where you are continuing the answer. For multiple choice questions, choose one best answer for each of the following. There is no negative penalty for a wrong answer: notation. For schema, the underlined attributes indicate a table"s primary key (and are, hence, not nullable). Assume set semantics for relational-algebra expressions: points. The number of points a given question is worth is marked. There are ve major parts worth 10 points each, for 50 points in total. Consider the three tables r, s, & t above for questions 1d & 1e: [2pt] show the results of r s, [2pt] show the results of r (s t).