Database System Concepts
Monday/Wednesday/Friday 14:30 - 15:20 Room 127 Nichols Hall
Problem Sets and Programming Assignments
(Last updated 26 Nov 2006)
- Homework 1, Problem Set
Assigned Wed 23 Aug 2006, due Wed 06 Sep 2006
Warm-up: basics, relations and relational algebra
PDF format
Microsoft Word format
Model solutions, PDF format (11 Sep 2006)
Model solutions, Microsoft Word format (11 Sep 2006)
- Homework 2, Machine Problem
Assigned Thu 07 Sep 2006, due Fri 15 Sep 2006
Cartesian product, equality join, and relational division
PDF format
Microsoft Word format
- Homework 3, Problem Set
Assigned Wed 20 Sep 2006, due Fri 29 Sep 2006
Cartesian product, equality join, and relational division
PDF format
Microsoft Word format
- Homework 4, Machine Problem
Assigned Wed 04 Oct 2006, due Fri 13 Oct 2006
RDBMS programming using MySQL, SQLWrapped, and JDBC
PDF format
Microsoft Word format
- Homework 5, Problem Set
Assigned Fri 20 Oct 2006, due Fri 27 Oct 2006
Entity-Relational Design and Normalization
PDF format
Microsoft Word format
- Homework 6, Machine Problem
Assigned Wed 01 Nov 2006, due Mon 13 Nov 2006
Database I/O and XML with Java Server Pages (JSP)
PDF format
Microsoft Word format
- Homework 7, Problem Set
Assigned Sun 12 Nov 2006, due Fri 17 Nov 2006
Entity-Relational Data Modeling
PDF format
Microsoft Word format
- Homework 8, Machine Problem
Assigned Sat 25 Nov 2006, due Thursday 30 Nov 2006
Queries and Performance Measurement
PDF format
Microsoft Word format
Homework submission procedure:
Upload problem sets to your KSOL drop box (typed PDF or scans of handwritten solutions are both acceptable), except for PS1, which you may submit by attachment to CIS560TA-L, using the KSOL drop box, or in hard copy.
Turn in machine problems as a single .zip or .tgz file uploaded to your KSOL drop box.
Back to the CIS560 main page
Page created: 14 Aug 2006
Last updated: 26 Nov 2006
William H. Hsu, CIS 560 instructor