Skip to content

Home 2015

12/03/2015:  Assignment 7 Solutions

12/02/2015: TA’s extended office hour – Friday 4-5PM.

12/02/2015:  Mini-Project 1 Solutions

11/30/2015:  Final Exam (Thu, Dec 10, 4:00-6:00PM). Room Assignment – Last name starting with A to P: PCB1100; Last name starting with Q-Z: SSL 228

11/29/2015: Mini-Project 2 – Python: If you find that your data isn’t actually inserted,  you will need to add conn.commit() after you execute the insert statement to commit the change to the database.

11/25/2015: More on Python for Mini-Project 2.

11/24/2015: Reading Assignment – Sections 10.6, 11.1-11.3

11/24/2015: New reference of Python for Mini-Project 2

11/24/2015: Assignment 7 (continued) – Problems 11.3(a), 11.4(based on 11,3(a)), 11.17(based on 11,3(a))

11/20/2015:Mini-Project 2 (Re-posted – with all the URLs unlinked)

11/19/2015: Assignment 6 solutions

11/19/2015: Assignment 7 – Problems 8.19, 8.20, 8.28, 8.29(e) from the textbook. More problems may be added after the lecture on 11/24. Due on Thursday 12/03 in class.

11/19/2015: Mini-Project 2

11/17/2015: Mini-Project 1 Q&A

11/12/2015: Assignment 6 – Problems 8.25, 8.27, 8.29(a)(b) from the textbook. Due on Thursday 11/19 in class.

11/12/2015: Assignment 5 solutions

11/12/2015: Reading Assignment – Chapter 8

11/05/2015: Assignment 5 – Problems 3.12, 3.14, 3.17, 3.24 from the textbook. Due on Thursday 11/12 in class.

11/05/2015: Mini-Project 1  (MySQL Installation Guide, MySQL Installation Guide for Mac, csv data)

11/04/2015: Midterm solutions (Note that there may be multiple ways to express a query.)

10/29/2015: Assignment 4 solutions

10/29/2015: Sample midterm solutions

10/28/2015: Solution for problem 6.14(e)

10/28/2015:  I will have extended OH today from 4 to 630.

10/27/2015:  Due to an immediate emergency at home, Arun could not hold his office hours today. He will hold additional office hours on Friday 10-11 to make up for this.

10/26/2015:  Midterm Coverage: Relational Algebra, SQL

10/26/2015:  Midterm Exam (Tu, 11/03 in class). Room Assignment – Last name starting with A to P: PCB1100; Last name starting with Q-Z: SSL 228

10/26/2015:  Sample midterm (solutions will be posted on Thursday)

10/22/2015:  Assignment 4 – Problems 3.11, 3.15, 3.16, 3.21 from the textbook. Due on Thursday 10/29 in class.

10/22/2015:  Assignment 3 Solutions

10/21/2015:  Reading Assignment – Chapter 3

10/15/2015:  Assignment 3 – Problems 6.11(e), 6.10, 6.12, 6.13, 6.14 from the textbook. Due on Thursday 10/22 in class.

10/15/2015:  Assignment 2 Solutions

10/09/2015:  For Assignment 2, you don’t need to do 6.11(e) as I have not talked about the divide operator yet.

10/09/2015:  Midterm will be held on Tuesday 11/03 in class.

10/07/2015:  Assignment 1 should be submitted in paper form in class.

10/06/2015:  Assignment 2 – Problems 2.12, 2.13, 6.11 from the textbook. Due on Thursday 10/15 in class.

10/06/2015:  Reading Assignment – Chapter 2, Section 6.1

09/29/2015:  Assignment 1

09/25/2015:  For the week of 09/28 (only), my office hour will be held from 5 to 6:30 on Monday (instead of Wednesday 5-6:30).

09/24/2015: This is no discussion session this week.

09/24/2015: Welcome to EECS116/CS122A.