Database Programming

Comp 353-001/453-001

Tuesdays, 4:15-6:45, LT-410

Text: Elmasri & Navathe, Fundamentals of Database Systems 6e, Pearson 2010, ISBN-10: 0136086209, ISBN-13:  9780136086208

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 Tuesday, May 3, 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.


The course survey is here.

Here's where to get MySQL Community Server, v 5.5.8, an open-source database. I also recommend downloading the reference manual. (Note that Oracle, through its purchase of Sun, now owns the commercial part of MySQL.)

Here's where to get Oracle Database 11g Release 2 (standard edition). You may 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). (Maybe this has changed?) We will use oracle to a limited extent in 2011.

Further installation information is here (for both MySQL and Oracle).

Notes on installing WAMP (windows LAMP)

Notes on installing PEAR under windows


The midterm exam study guide is here. It includes a "SQL examples" guide sheet that you will be given on the exam.

The final exam study guide is here.

Class notes and readings:

Week 1, Jan 18
Week 2, Jan 25
Snow day: Feb 1
Week 3, Feb 8
Week 4, Feb 15
Week 5, Feb 22
Week 6, Mar 1
Break: Mar 8
Week 7, Mar 15
Week 8, Mar 22
Week 9, Mar 29
Week 10, Apr 5
Week 11, Apr 12
Week 12, Apr 19
Week 13, Apr 26

Assignments

Assignment 1: E&N exercises 4.5, 4.10, 4.12

Assignment 2: E&N exercises 5.5, 5.6, 5.7, 5.8, due March 1

MySQL/PHP assignment, due April 26

Examples


The office database (spreadsheet, files). To load this into mysql, the two main files are the table definitions and the data-insertion commands. You can paste these in, or use the source command in MySQL.

The STUDENT database (E&N p 8, Fig 1.2) used in Exercise 4.12, is here: student.text. I added three additional students, and their grades. You should be able to paste this in to MySQL.
In Spring 2011 we will consider some of the following topics: