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

Database Management Systems
CIS 3400

Course
Coordinator		 Dr. Richard Holowczak
Office Number 460, E. 26th Street
Phone: 802-6279
E-Mail: richard_holowczak@baruch.cuny.edu (Preferred)
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
  • Normalization (1NF - 4NF and DK/NF)
  • Structured Query Language
  • Transaction Processing, Concurrency Control and Recovery
  • Client/Server, Distributed, Internet databases
  • Introduction to Other data models: Object Oriented, Hierarchical, Network
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		 Textbooks for this course:
  • Main Text: Kronke, David M. Database Processing: Fundamentals, Design and Implementation. Sixth Edition. Prentice-Hall, 1998
    or
    Ramez Elmasri and Shamkant B. Navathe Fundamentals of Database Systems. Second Edition. Addison-Wesley Pub Co, 1994. ISBN: 0805317481
  • A Tutorial text for MS Access such as the Adamski book published by Course Technologies
  • Notes and handouts are available on the course WWW page:
    http://cisnet.baruch.cuny.edu/holowczak/classes/3400/
Course Content
  • Required reading in the textbook
  • 3 to 4 homework assignments including some implementations using Microsoft Access database
  • A Mid-term exam and a Final exam
  • 2 or 3 announced quizes
  • A team/group project is also required. 3 to 4 members per group. 8 to 10 entities per project. Implementation in MS Access including tables, forms, reports, queries and menu.
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. OR CIS 2200.
Topics / Schedule (Tentative) The following table gives a tentative lecture schedule for the course.
WeeksTopicsChapter (in Kronke)
1 Course Introduction and Introduction to Databases
Introduction to the Internet 		1 and 2
16
2
Systems Analysis and Database Modeling
Application Components and Design 		8 and 2
3
Entity Relationship Modeling (E-R Modeling)
Lab Session - Using MS Access 		3
11
4
E-R Modeling Continued 3 and 6
5
The Relational Model - Converting E-R to Relations 5
6 and 7
 Relational Algebra and Normalization (1NF - DK/NF) 6 and 9
8 Review for Mid-Term Exam
Mid-Term Exam
9
Structured Query Langauge (SQL) - DDL 10
10
SQL Continued - DML
10
11
Implementation: Data Structures, Security and System Administration Appendix
15
12
Implementation Continued:
Transaction Porcessing, Concurrency Control, Recovery 		12 and 13
13 Client/Server and Distributed Databases
14
14 Internet, Intranet Databases
OODBMS, Hierarchical and Networked Data Models 		16
17, 18
15
Project Presentations and Review for Final Exam