Dr. Ira Rudowsky CISC3810

Spring 2013 M,W11:00-12:15 Database Systems

Text:Database Systems: Design, Implementation & Management–10e/ Coronel, Morris, Rob/ Course Technology

Prerequisite:CISC 3130; and CISC 1050 or permission of the chairperson.

Test, Grading Policy:

(a) 3 exams – 80% (b) Homework -20%

For full credit, homework is expected on the due date. Late homework will receive partial credit. The latest it can be handed in is the day it is covered on a test. Attendance and class participation will affect your grade as well.

Our class runs from January 28ththrough May 15th, meeting Monday and Wednesday. Wed, Feb 20th follows a Monday schedule. We will not meet on Feb 18th (President’s Day), and on March 25th, March 27th and April 1st(Spring recess).The final exam is Wed, May 22nd from 10:30-12:30.

Calendar of Special Dates Spring 2013

Check the on-line calendar for administrative dates during Spring 2013

Academic Integrity

The faculty and administration of Brooklyn College support an environment free from cheating and plagiarism. Each student is responsible for being aware of what constitutes cheating and plagiarism and for avoiding both. The complete text of the CUNY Academic Integrity Policy and the Brooklyn College procedure for implementing that policy can be found at this site: If a faculty member suspects a violation of academic integrity and, upon investigation, confirms that violation, or if the student admits the violation, the faculty member MUST report the violation.

Center for Student Disability Services:

In order to receive disability-related academic accommodations students must first be registered with the Center for Student Disability Services. Students who have a documented disability or suspect they may have a disability are invited to set up an appointment with the Director of the Center for Student Disability Services, Ms. Valerie Stewart-Lovell at 718-951-5538. If you have already registered with the Center for Student Disability Services please provide your professor with the course accommodation form and discuss your specific accommodation with him/her.

College Regulations

All students should read carefully and thoroughly the most current Brooklyn College Graduate Bulletin for a complete listing of academic regulations and procedures of the college as well as student rights and college rules. This includes the state law regarding non-attendance because of religious beliefs.

Classroom Etiquette

Eating and cell phone/PDA usage (talking, texting or checking messages/e-mails) are not allowed during lecture. Use of laptops is allowed only to follow the class lectures or to take notes. Show respect for yourself and your classmates – you are all here to learn.

Course Outline

Database Systems
Data Models
Relational Database Model
E-R Modeling
Advanced Data Modeling
Normalization
Introduction to SQL / Advanced SQL
Database Design
Transaction ManagementConcurrency Control
Distributed Databases
Business Intelligence & Data Warehouses
Database Administration & Security

I can be reached via e-mail at

My web page is and it will be used to communicate lecture notes, assignments, announcements etc.

Office: Ingersoll 1417N Phone: 951-5000 x2062

Office hours: Wednesday 12:30-1:30 and Thursday 4:00-5:00 PM and by appointment