CIS 3400 Database Management Systems

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

Database Management Systems
CIS 3400 - Fall 2009

Tuesday / Thursday 2:30 - 3:45pm
Section TV24A

Professor	Dr. Richard Holowczak Office: Wasserman Trading Floor / Subotnick Center Phone: 646 - 312 - 1544 Fax: 646 - 312 - 1541 Office Hours: 12:30 - 2:00pm on Tuesday and Thursday 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 (Conceptual Modeling) Relational Data Model and Relational Algebra (Logical Modeling) Structured Query Language (Physical Modeling) Transaction Processing and Concurrency Control Database System Architectures Legal and Ethical Aspects of Database Management
Learning Goals	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. In addition students will gain skills to manage data in a professional and ethical fashion.
Textbooks / Materials / Resources	Business Database Systems (BDS) Connolly, Begg & Holowczak Addison-Wesley / Peasron Education, 2008. ISBN: 1405874376 Joseph J. Adamski and Kathy Finnegan New Perspectives on Microsoft Office Access 2003, Comprehensive (NPMSA) 2nd Edition ISBN-10: 0619268115 ISBN-13: 9780619268114 Click this link to download the data files for this tutorial. Additional course materials will be provided on the CISNet course WWW Home page. Computer Labs: VC 11-125 and BCTC on the 6th floor 25th Street building Microsoft Access 2003 will be used extensively for this course. Other versions may be substituted. MS Access can be downloaded from the MSDN Library at Baruch.
Course Content	In addition to required reading in the textbook, there will be 3 to 4 homework assignments including some implementation using Microsoft Access. Examinations will consist of three tests (non-cumulative). A group project is also required and presentations will be made towards the end of the semester. I also reserve the right to issue unannounced quizes if I believe the class is not appropriately keeping up with their preparations.

Grading

Exam 1	20%
Exam 2	20%
Exam 3	20%
Group Project	20%
Homework, Quizzes and Class participation	20%

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

Prerequisites

CIS 2200

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

Week	Topics	Chapter in BDS	Chapters in NPMSA
1	Course Introduction and Introduction to Databases	1 and 2	File Management 1, Office 1
2	Systems Analysis and Database Modeling	4 and 9	Access Level I Tutorials
3	Entity Relationship Modeling (E-R Modeling) and Advanced Data Modeling	6, 7 and 9	Access Level I Tutorials
4	Converting E-R models to Relational Models	10	Access Level II Tutorials
5	The Relational Model and Normalization	8	Access Level II Tutorials
6	Exam 1
7	Physical Database Design and SQL	11 and 3	Access Level III tutorials
8	Structured Query Language (SQL)	3	Access Level III tutorials
9	Structured Query Language (SQL) Continued	3 and Appendix E	Access Level III tutorials
10	Database Administration	12	Access Level III tutorials
11	Exam 2
12	Professional, Legal and Ethical Aspects	13	Additional Case 1
13	Transaction Processing	14
14	Database System Architectures	15
16	Exam 3

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

I fully support Baruch College's policy on Academic Honesty, which states, in part:
"Academic dishonesty is unacceptable and will not be tolerated. Cheating, forgery, plagiarism and collusion in dishonest acts undermine the college's educational mission and the students' personal and intellectual growth. Baruch students are expected to bear individual responsibility for their work, to learn the rules and definitions that underlie the practice of academic integrity, and to uphold its ideals. Ignorance of the rules is not an acceptable excuse for disobeying them. Any student who attempts to compromise or devalue the academic process will be sanctioned."
Academic sanctions in this class will range from an F on the assignment to an F in this course. A report of suspected academic dishonesty will be sent to the Office of the Dean of Students. Additional information and definitions can be found at http://www.baruch.cuny.edu/academic/academic_honesty.html
No makeups will be given for missed quizzes or exams.
The instructor retains all 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
Students are expected to spend significant time outside of the classroom learning to use MS Windows and MS Access. 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, FireFox, Netscape, etc.), Windows Explorer (file management), MS Paint, Notepad and WordPad.
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 view it properly.
The Adamski MS Access 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 thumb drives or e-mail accounts 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 2009

Additional Notes

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

Database Management Systems
CIS 3400 - Fall 2009