Database Programming

Comp 353-001

Monday, 4:15-6:45, LT-412 (linux lab)

Text: Nilesh Shah, Database Systems Using Oracle, 2nd ed, Prentice-Hall 2004

There will be several assignments during the semester, plus a midterm and final. The assignments will be worth about 30% of your grade, the midterm 30%, and the final 40%. The final will be Monday, April 30, at our usual time.

My general course groundrules are here.

Spring 2022:
I am generally in my office on Mondays from noon to a little before 4:00.
Sometimes I have meetings or come in late, so check first.
I am also available other times via Zoom, by appointment. Contact me via email for the Zoom meeting ID.

Here's where to get Oracle Database 10g Express Edition. You will have to create a free account before you can download, and to do that you must sign up for at least one mailing list (you can cancel later). Here's where to get MySQL, an open-source database.

The final exam study guide is done; answers are here. Answers have not been proofread very carefully.

The midterm study guide (more-or-less done) is here, last updated Thursday, 3/15. Partial exercise solutions are here.

The midterm will contain several SQL questions based on the database in the SQL Review: Supplementary Exercises, following chapter 9. I recommend familiarizing yourself with this database; I also recommend going over the SQL examples there (further details below). I will provide you on the exam with a summary of the tables.

Here are solutions to Assignment 2.

Class notes and readings:

Week 1, Jan 22: chapter 1, chapter 2 "Data Modeling", Parts demo
Week 2, Jan 29: Read chapter 3
Week 3, Feb 5: Read chapters 4-5
Week 4, Feb 12: Read chapter 6
Week 5, Feb 19: Read chapters 7, 8
Week 6, Feb 26: Read chapters 10, 11
Week 7, Mar 12: Read chapters 12, 13 Start reading chapters 10-12
Week 8, Mar 19: Oracle objects, midterm
Week 9, Apr 2: JDBC
Week 10, Apr 9: JDBC, params, web applications
Week 11, Apr 16:
Week 12, Apr 23:

Here is Standalone.java, the standalone JDBC/Java program I began demonstrating on April 2. To run it you will also need ojdbc14.jar.

Here is a collection of mod_pl/sql procedures for dynamic web pages, mod_plsql.text. They have to be split up into separate files to run.

Here is some Oracle documentation on the htp package for web applications.
Here's another htp reference page.

Assignments

Program 1: tutoring tables, due Feb 12

Program 2: some Indo-US queries, due Friday, Mar 2

Program 3: some NamanNavan queries, due Monday, Apr 16

Program 4: JDBC or web_PL/SQL, due by the final.

Here is supplement.sql, used in the supplementary exercises following chapter 9.
In Spring 2007 we will consider some of the following topics: