Homework Assignments
Organization
There will be three homework assignments that have to be solved individually and uploaded to grade scope. Some of the assignments will give you the opportunity to earn bonus credits! Homework assignment 2 will be outgraded (you have to submit SQL code).
Important Notes
- Homework solutions have to submitted to grade scope.
- Homeworks have to be solved individually.
Homework Assignments
Assignment 1 Relational algebra
- Handout Date: 01/25
- Submission Deadline: 02/08 (one minute before midnight)
- Assignment PDF: Download the questions here: homework_1.pdf
- Solutions: Download the solutions here: homework1_solutions.pdf.
Assignment 2 SQL
- Handout Date: 02/20
- Submission Deadline: 03/05 (one minute before midnight)
- Assignment PDF: Download the questions here: homework_2.pdf
- Assignment SQL Database Schema and Exampl Data: Download here: homework_2.sql
- Autograder Submission Handout: Download a sample autograder submission that you can edit from here: homework_2_handout.zip.
Assignment 3 Database Modelling
- Handout Date: 03/28
- Submission Deadline: 04/16 (one minute before midnight)
- Assignment PDF: Download the questions here: homework_3.pdf
- Solutions: Download the solutions here: homework3_solutions.pdf.
Postgres
You are encouraged to test SQL queries and DDL statements for the homework assignments and from class using Postgres.
Plagiarism and Late Policy
We will check for plagiarism . Plagiarism will result in zero points for the assignment and possibly academic sanctions.
Late policies:
- -20% per day late
Homeworks and Solutions for Previous Years
- 2013 - Spring
- 2014 - Spring
- 2016 - Spring
- 2017 - Fall