CSC 8490-001: Database Systems

Fall, 2019

Links to PowerPoints and Other Presentation Files

  • Intro and History
  • Databases and Database Users
  • Database System Concepts and Architecture

  • The ER Model
  • Classifying Cardinalities of Relationships
  • Ternary Relationships

  • Intro to Relational Model
  • The Relational Data Model
  • Mapping ER to RDM

  • Intro to Relational Algebra
  • Relational Algebra
  • More Relational Algebra
  • WinRDBi software, for playing with relational algebra (and SQL, and other query strategies)

  • Intro to SQL
  • SQL
  • More SQL
  • Still More SQL

  • Enhanced ER Modeling
  • UML
  • More EER
  • More UML
  • Mapping EER and UML to RDM
  • More Mapping

  • Overview of Database Programming
  • sqlplus *
  • Chapter 13 from our text, some general principles of database programming
  • More details about JDBC, from the Dietrich and Urban materials
  • Sample code that works for using JDBC to connect to ORACLE on csdb *
  • Using JDBC on your Windows system to connect to a local MS-Access database
  • PL/SQL as described in an earlier edition of our text
  • PL/SQL presentation by Dr. Dullea
  • PL/SQL sample on csdb *
  • Downloads with good trigger examples, from the excellent Ricardo book (Choose "Chapter 05-Code") *
  • a practice lab on MySQL
  • PHP/MySQL Tutorial, Part I (courtesy Dr. Damian)
  • PHP/MySQL Tutorial, Part II (courtesy Dr. Damian)

  • Intro to Relational Design Theory
  • Functional Dependencies and Normal Forms
  • A Worked-Out Exercise on Finding a Minimal Cover

  • Decompositions
  • LJD and other analysis

  • Transaction Processing
  • TP Definitions and Exercises
  • Concurrency Control Techniques
  • Template for Schedule

  • Introduction to the Object Data Model
  • The Object Data Model
  • More on the Object Data Model
  • Object Diagram and ODL for the UNIVERSITY Example
  • EERD, UML and ODL for the Hollywood Example
  • Mapping to the ODM
  • More on the Mapping

  • OQL
  • Other important stuff
  • More on OQL

    • Back to the home page for the course