Database Management Systems

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

Database Management Systems

Notes Pages

The following links point to the class notes. I will try to post them at least a day prior to the class. You are welcome to print these notes out (Released version only) and bring them to class as well as use them for studying.

Please note that these are not intended to be a substitute for attending class. You are still required to attend all scheduled classes.

Introduction to the course and Introduction to Databases (Released)
Systems Analysis and Design - DB Application Components (Released)
Entity Relationship Modeling (Released)
How to draw ER Diagrams in MS PowerPoint (Released)
How to draw ER Diagrams in MS Visio using Crow's Foot Notation (Released)
How to draw Diagrams in MS Visio using UML Notation (Released)
Converting E-R models to Relational Models (Released)
Normalization (Released)

Structured Query Language (SQL) Notes (Released) Older Version
File Organization and Indexing (Released) Older Version
DB Security and the role of the DBA and DA (Released) Older Version
Also Chapter 12 PowerPoint Slides

DBMS Functions: Transaction Processing, Concurrency Control and Recovery (Released)
Chapter 14 Transaction Management PowerPoint
DB System Architectures (Released) Powerpoint
World Wide Web and HTML basics (For your review)
Internet access to databases (Released) PowerPoint for eCommerce and Internet access to databases
Legal and Ethical Issues (PowerPoint) (Released)
Test 3 Review Notes

Released means the notes are ready for you to print and use.
Beta indicates the notes still need some touching up. Alpha means I'm just getting started...

File: notes.html Date: 10:33 AM 4/18/2013
All materials Copyright, 1997-2013 Richard Holowczak

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