CIS 9340 – Sample Course Syllabus

Title Database Management Systems
Description Fundamental concepts and techniques in the design, implementation, and use of databases. Architecture and evolution of database management systems and database administration are introduced. Conceptual data modeling and relational, network, and hierarchical data models are examined. Students learn abstract query languages, such as relational algebra, relational calculus, and 4GL languages such as SQL. Database design and normalization are examined in detail. Security and recovery of databases and ethical issues are also discussed. Students implement a small-scale business application utilizing a database in a term project.
Prerequisites None
Learning Goals

The main objective of this course is to provide students with the background to design, implement, and use database management systems.

Upon completion, students should be able to:

  • Discuss the evolution of database management systems
  • Create entity Relationship Modeling and Design (Conceptual Modeling)
  • Design databases following the relational Data Model and Normalization (Logical Modeling)
  • Use Structured Query Language (Physical Modeling)
  • Articulate the role of transaction Processing and Concurrency Control
  • Develop database System Architectures (including web/dbms integration)
  • Create NoSQL Databases, JSON Stores, Web API
Grades
  • Exam 1
20%
  • Exam 2
20%
  • Exam 3
20%
  • Group Project
20%
  • Homework, Quizzes and Class participation
20%
Textbooks and other material

Database Systems: A Practical Approach to Design, Implementation and Management by Thomas Connolly and Carolyn Begg. Fifth or 6th Edition. Addison Wesley Pub. Co., 2010. ISBN-13: 978-0-321-52306-8

New Perspectives on Microsoft Office Access 2013, Comprehensive by Joseph J. Adamski and Kathy Finnegan. 1st Edition ISBN-10: 0538798475; ISBN-13: 9780538798471

Computer Labs: VC 11-125 and BCTC on the 6th floor 25th Street building

Microsoft Access 2013 will be used extensively for this course. MS Access 2013 can be downloaded from the MSDN Library at Baruch (aka “DreamSpark”.)

Topics
  • Course Introduction and Introduction to Databases
  • Systems Analysis and Database Modeling
  • Entity Relationship Modeling (E-R Modeling)
  • and Advanced Data Modeling
  • Converting E-R models to Relational Models
  • The Relational Model and Normalization (up to BCNF)
  • Exam 1
  • Physical Database Design and SQL
  • Structured Query Language (SQL)
  • Structured Query Language (SQL) Continued
  • Database Security and Administration
  • Exam 2
  • Transaction Processing
  • Database System Architectures: Two-tier, three-tier,
  • Web/DBMS integration
  • NoSQL DBMS, JSON Stores, Web APIs
  • Exam 3