Homework Assignments
Organization
There will be three homework assignments that have to be solved individually and uploaded to blackboard. Some of the assignments will give you the opportunity to earn bonus credits!
Important Notes
- Homework solutions have to submitted to blackboard.
- Homeworks have to be solved individually.
Homework Assignments
Assignment 1 Relational algebra
- Handout Date: 09/12
- Submission Deadline: 09/26 (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: 10/05
- Submission Deadline: 10/20 (one minute before midnight)
- Assignment PDF: Download the questions here: homework_2.pdf
- Solutions: Download the solutions here: homework2_solutions.pdf.
Assignment 3 Database Modelling
- Handout Date: 11/09
- Submission Deadline: 11/23 (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