IT 222 - Database Principles

Characteristics of the database approach.  Database concepts and architecture; Data models, schemas and instances; Program data independence, Database languages and interfaces.   Data models for database systems; The E-R DM, Relational DM and Relational Algebra.  Relational model constraints; Domain, key, and integrity constraints.   SQL-relational DB language; Data definition, queries, update statements, and views in SQL.  Database design; functional dependencies, Normal forms.   Introduction to Object Oriented databases.