# 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.