Course Syllabus

1. Background (*)
   1. File processing vs DBMS
   2. Model overview
   3. Storage techniques
2. Relational DBMS (*)
   1. Dependency and Normal forms
   2. SQL - Oracle
   3. Embedded SQL - Oracle
   4. Performance tradeoffs
3. Database design (*)
   1. Design goals
   2. User views
   3. Entity relationship model
   4. Design examples
4. Conventional models
   1. Network model & CODASYL DBTG submodel
   2. Hierarchical model
5. Microcomputer dbms
6. Object oriented database (*)
   1. Multimedia
   2. Managing objects
   3. Postgres - free object database
7. Advanced topics
   1. Multidatabase systems
      1. Context of corporate systems
      2. Cooperative computing
      3. Local & global schema
      4. Schema integration
   2. Security and recovery (*)
   3. Enhanced ER models
      1. EER to relational mapping
      2. Knowledge representation
   4. Client server architectures (*)
      1. Query processing
      2. Data replication
      3. Update control

(*) This topic is core material to be covered every time the course is taught.