CSE 305/ISE 305: Principles of Database Systems, Fall 2000

Instructors:

• David S. Warren ( warren@cs.sunysb.edu),

• Section: 1
• Class: TueThu  8:20 - 9:40,  Harriman Hall, room 137
• Office hours: TueThu  9:50 - 11:10, CS Building room 1431, and by appointment

 
• Radu Grosu ( grosu@cs.sunysb.edu),

• Section: 2
• Class: TueThu  9:50 - 11:10, Old Chemistry, room 144
• Office hours: Tue 12:30 - 1:50, Thu 11:20 - 12:40, CS Building room 1425, and by appointment

Teaching Assistants:

• Jing Luo (jingluo@cs.sunysb.edu)

• Bin Tang (bintang@cs.sunysb.edu)

• Office hours: Fri 8:30-12:30, CS Building room 2110

• Wei Xu (weixu@cs.sunysb.edu)

Prerequisites

Text

Additional Reading:

The course will closely follow the notes for text of Lewis, Bernstein and Kifer. Although we will not cover Chapter 3 and 4 we expect you to be reading these chapters.

Tentative Schedule

 

9/5	Overview of Databases and Transaction Processing (ps, ppt)
9/7	A Closer Look (ps,ppt)
9/12,14,19	The Entity Relationship Model (ps,ppt)
9/26 (due date)	E-R Model  (project)
9/21, 26, 28; 10/3	The Relational Data Model (ps,ppt)
10/5	1st Midterm Exam  (look here for previous midterm!)
10/17 (new date)	Relational Model Demo (project)
10/10, 12, 17, 19	Relational Algebra and SQL (ps, ppt)
10/24, 26, 31; 11/2, 7	Relational Normalization Theory (ps, ppt)
11/9	2nd Midterm Exam  (look here for previous midterm!)
11/14	Query Model Demo (project)
11/14	Triggers and Active Databases (ps, ppt)
11/16, 21, 23	SQL in the Real World (ps, ppt)
11/28, 30; 12/5, 7	Physical Data Organization and Indexing (ps, ppt)
12/13, 15	GUI Demo (project)  (sign for date/hour at room 1431)
12/12, 14	Query Processing: The Basics (ps, ppt)
12/19 (sect 1), 21 (sect 2)	Final Exam

Grading

• Homework and project assignments (worth 35%):

There will be a project and several homeworks worth together 35 points.. The project requires to build a transaction processing system and has to be done done in groups of two students. The project will have four deliverables: the ER model, the relational model, the query model and the gui. More information about the project will be posted later on the net. Unless explicitly permitted, all work on the homeworks must be done individually without consulting fellow students. We will accept late homeworks or subproject delivery only once!. You cannot pass the course without completing the project and the homeworks.
 
• Midterm exams (worth 30%):

There will two midterm exams each worth 15 points.
 
• Final exam (worth 35%):

There will a final exam worth 35 points.

We have to grade this material. Hence it is important that you explain your work carefully. All work must be submitted in a neat and organized fashion, and it must be typed and stapled. You might lose points if these conditions are not met. All homeworks are to be done individually. If you feel that you deserve a higher grade see one of the TA's promptly.

For the project you will be given an account in the Transaction Processing Lab. Do not let anyone use your account. Please be conscious of security in the lab since theft of Departmental equipment is a problem that affects us all. Although your project will have to be demonstrated in the lab, if you have your own computer it may be possible for you to do much of the development there. If you have any problems with the hardware or software in the lab (other than with the requirements of the project itself) send E-mail to root@cs.sunysb.edu with a copy to me. Neither the TAs nor I can fix such problems.

Software

• Databases
• www.sybase.com
• Sybase Online documents

• SQL
• SQL tutorial
• SQL 92 specification

• JAVA
• Python Reference Manual
• Java Class Hierarchy
• THE JAVA Language Specification
• www.javasoft.com
• Java Books on Line
• The Java Tutorial

• JDBC
• Sunsoft JDBC Homepage
• JDBC Enhancements
• The JDBC Specification
• JavaSoft's JDBC API specification

Course Conduct

Unfortunately, cheating has increasingly become a problem among students in the Department. You should be aware that cheating on homeworks or the project will be treated as severely as cheating on exams. While we don't mind if you discuss the homeworks or project with other students, if we find that you have turned in work that was essentially done by someone else, or you have given your work to someone else, you will fail the course. Each semester several such cases are discovered. If we decide to turn the case over to the CASA committee, the punishment can be worse. If for any reason you can't do the work yourself, come to see us right away and we will try to get some help for you. The last day to drop the course without incurring a tuition liability is Sept. 11 The last day to drop the course without a "W" (withdrawal) being recorded.is Sept. 18.

If you have a physical, psychological, medical or learning disability that may have an impact on your ability to carry out assigned course work, I urge you to contact the staff in the Disabled Student Services office (DSS), Room 133 Humanities, 632-6748/TDD. DSS will review your concerns and determine, with you, what accommodations are necessary and appropriate. All information and documentation of disability is confidential.

Last updated on October 24, 2000. Send Comments to Radu Grosu and David S. Warren.