HW1 on Relational Algebra and Basic SQL

HW is due 10/29 at 1:30 pm. All sections assume 6th edition of book.

Relational Algebra

Read: - 6.1.3.3 (Assignment Operator) - 6.1.4.2 (Aggregation Operator)

Exercises from book:

  • 6.10
  • 6.11
  • 6.13
  • 6.14

Basic SQL Exercises:

  • 3.11
  • 3.12
  • 3.13
  • 3.14
  • 3.15
  • 3.16
  • 3.17

On SQL please: - use bold or UPPERCASE for keywords (i.e. SELECT FROM WHERE AVG) - use a newline after major keyword line (ie select from where groupby)

Example:

SELECT name
FROM people
WHERE age=22 AND state = 'IL'