Downloadable Weekly Powerpoint Slides for CIS431
 
Spring, 2004
Dr. J. M. Scher

 

 

 

Week # Modules 
1

 Welcome, FileProc, DB_Intro
2

E-R Modeling (Chen E-R Modeling and Extended E-R)
3

IDEFIX E-R Modeling
4

  Relational Database Design with Microsoft Access
 & Semantic Object Data Modeling
5

  Semantic Object Data Modeling & Cool Strategy's Table Designer 1.0a
6

  The Process for Designing Data Models (& also Relational Algebra)
7

Querying a Database With GQBE, & Translating an Extended ER model to a Relational Design
8

  Functional Dependencies & Normalization (Chapter 4)
9

  Normalization (1NF,2NF,3NF,BCNF.4NF)
10

  Domain Key Normal Form and Relational Design

Note: This module replaces the DKNF module from prior week.
11

  Structured Query Language (SQL) - Chapters 5 and 6
12

  Advanced SQL Query Design, and Oracle

13

  Using SQL in Applications (Chapter 7), Triggers, Concurrency Control
 
 Note: CIS431 Students are welcome  to view a recent web page developed by Dr. Scher devoted to some "gems" of freeware/"public domain" software (this is NOT at all a course requirement). Click on the  fountain to view this site, and feel free to download any of the 'freeware' titles which might interest you (all have excellent documentation).