CIS 3400 Database Management Systems

Zicklin School of Business - Baruch College
City University of New York

Database Management Systems
CIS 3400 - Fall 1998

-
Section - - Room -, E. 26th Street

Professor	Dr. Richard Holowczak Office Number 460, E. 26th Street Phone: 212-802-6279 Office Hours: 4:00 - 5:00pm on Monday and Wednesday, or by appointment E-Mail: richard_holowczak@baruch.cuny.edu (Preferred) Always include the following in the Subject line: `CIS 3400` followed by the specific subject of your e-mail. Course WWW : http://cisnet.baruch.cuny.edu/holowczak/classes/3400/
Objectives	The main objective of this course is to provide students with the background to design, implement, and use database management systems. Topics Include: Evolution of database management systems Entity Relationship Modeling and Design Relational Data Model and Relational Algebra Structured Query Language Transaction Processing, Concurrency Control and Recovery Client/Server, Distributed, Internet databases Upon successful completion of this course, students will have the skills to analyze business requirements and produce a viable model and implementation of a database to meet such requirements.
Textbooks / Materials / Resources	Kroenke, David M. Database Processing: Fundamentals, Design and Implementation. Seventh Edition. Prentice-Hall, 2000. ISBN: 0-13-084816-6 Adamski, Joseph J. and Hommel, Charles New Perspectives on Microsoft Access '97 - Comprehensive Course Technologies, 1998. ISBN: 0-7600-7309-0 (This text is optional) Cost: about $45. You may obtain the tutorial data files from the CT web site: http://www.course.com Additional course materials will be provided on the CISNet course WWW Home page. Computer Labs: Room 430, E. 26th and BCTC on the 6th floor 25th Street building
Course Content	In addition to required reading in the textbook, there will be 3 to 4 homework assignments including some implementation using Microsoft Access '97 database. Examinations will consist of a Mid-term exam and a Final exam, plus 2 or 3 announced quizzes. A group project is also required and presentations will be made towards the end of the semester.

Grading

Mid term Exam	25%
Final Exam	30%
Group Project	25%
Homework, Quizzes and Class participation	20%

This is a tentative grading schedule and is subject to change. Exams will Not be multiple choice. Homework assignments are due at the beginning of the class period. Late assignments will be graded down 10% per day late.

Prerequisites

CIS 3100 Object Oriented Prog. lang. or CIS 3200 Business Applic. Prog. I
For non-majors, CIS 3367 Microcomputer Applications in Business I and junior status.

Topics / Schedule (Tentative) The following table gives a tentative lecture schedule for the course.

Class Dates	Topics	Chapter (in Kroenke)
M August 30 W September 1	Course Introduction and Introduction to Databases Introduction to the Internet	1 and 2
M September 6 W September 8	Systems Analysis and Database Modeling	10 and 3
M September 13 W September 15	Entity Relationship Modeling (E-R Modeling) and Advanced Data Modeling	3
M September 20 W September 22	Converting E-R models to Relational Models	6
M September 27 W September 29	The Relational Model and Normalization	5 and 6
M October 4 W October 6	The Relational Model and Normalization - Continued	5 and 6
M October 11 W October 13	Relational Algebra	8
M October 18 W October 20	Relational Algebra - Continued	8
M October 25 W October 27	Review for Mid-Term Exam Mid-Term Exam
M November 1 W November 3	Structured Query Language (SQL)	9
M November 8 W November 10	SQL Continued	9
M November 15 W November 17	Implementation: Data Structures, Security and System Administration	Appendix A, 12
M November 22 W November 24	Implementation Continued Transaction Processing, Concurrency Control, Recovery	12
M November 29 W December 1	Database Architectures - Client/Server and Distributed Databases	11, 13, 14
M December 6 W December 8	Internet, Intranet Databases OODBMS and Hierarchical and Networked Data Models	11, 16, 17
M December 13 W December 15	Project Presentations and Review for Final Exam

Please note that the above schedule is subject to change. Students are expected to come to class prepared and ready to participate. The associated chapters should be read ahead of time.

Additional Notes

No makeups will be given for missed quizzes or exams.
The instructor retains all midterm and final exams.
Grades will not be given out via e-mail.
If you miss class, it is your responsibility to find out about any announcements or assignments you may have missed.
In general, the time to let me know about any problems or issues concerning missing class, long term illnesses, job related problems, etc. is before you have missed a week or two of classes.
All homework assignments are to be done individually. Students handing in similar work will both receive a a 0 and face possible disciplinary actions.
If you plan to use MS Access at home or at your work, and you do not own a legitimate copy of Access or MS Office, then you will have difficulty completing some of the assignments required for this course (in addition to the fact that you are breaking the law).
If you plan to use the MS Access software provided in one of the Baruch computer labs, then you will have no trouble completing the assignments. All of the labs have MS Access '97
Students are expected to spend significant time outside of the classroom learning to use MS Windows and MS Access '97. It is assumed students know how to run multiple programs at the same time, make backups of their work on several floppy disks, cut/copy and paste text and images between applications, and how to work with the accessories that come with MS Windows such as a Web Browser (Internet Explorer or Netscape), Windows Explorer (file management), MS Paint, Notepad and WordPad.
If you feel you are lacking these skills, please acquire them either on your own or via one of the remedial courses.
Other helpful software tools to have include a decent word processor (e.g., MS Word) and a drawing tool. MS Powerpoint can be used for the latter. Again, the Baruch computer labs have all of these tools.
Assignments may be turned in via e-mail. However, you are strongly advised to send me a sample attachment to ensure I can decode and view it properly. Not all e-mail programs work the same and many students have had problems sending attachments such as MS Word files.
The Kroenke textbook is mandatory for the course.
The Adamski MS Access '97 workbook is optional. If you have experience working with MS Access, you may not need the Adamski book. If you feel you require a step-by-step tutorial to learn MS Access, then please acquire the Adamski book.
Finally: Make backups of all of your work!
This includes any assignment and project materials you and your group produce. Copy files onto 2 or 3 floppy disks and photocopy diagrams and other materials to share with your group.

Zicklin School of Business - Baruch College City University of New York

Database Management Systems CIS 3400 - Fall 1998

Additional Notes

Zicklin School of Business - Baruch College
City University of New York

Database Management Systems
CIS 3400 - Fall 1998