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





Teaching Assistants:


CSE 214 and CSE 220 are the prerequisite courses. The corresponding records have to be shown to the instructors before the first midterm exam. We also assume that students are (or will become) familiar with Java. Java will not be discussed in the lectures, but will be used in the project.


Databases and Transaction Processing (notes for text) - Lewis, Bernstein and Kifer

Additional Reading:

Database Management Systems - Ramakrishnan  (McGraw-Hill)
Fundamentals of Database Management Systems - Elmasri and Navathe (Addison Wesley)

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 will be based on the following four items. The following information must be contained in all project files and homeworksStudent ID, Name, E-mail address,  Due Date.

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.


Course Conduct

You should check the CSE305/ISE305 home page periodically for announcements.

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.