Reading Homework 1 (Due Wed 9/7, noon)

Reading homeworks are intended to ensure that you have read the assigned material. It is perfectly fine if you are not able to answer all the questions correctly. However I expect you should typically get at least 1/2 of the questions right. You will get full credit as long as you have put in the effort to complete it, and a large fraction of the answers are correct (ignore the score that ELMS gives).

Also note that: reading homeworks are mandatory; you can miss at most 2, but missing more than that will lead to lower overall grade points for the reading homeworks.

The reading assignment here is: Chapters 2.6 (Relational Operators), 3.1, 3.2, 3.3.1

You don't need to read 3.2 carefully -- I suggest skimming through it so you are familiar with the basics of how tables are created, and how data is added/removed.

We have posted two Jupyter Notebooks that cover this material interactively.

• Basics of SQL Notebook: Covers basic SQL commands (going beyond what is part of the reading assignment).
• Basic Relational Algebra Notebook: Covers the 5 basic relational algebra operators.

As before: if you open these in Jupyter (on your VM), then you can try out different queries and/or see how the relational algebra operations behave on different inputs.