Course Description

Semantic models for conceptual and logical design of databases. Detailed study of relational systems: design, dependency, and normal forms. Use of interactive and embedded query languages. Overview of topics such as database connectivity, security, and object-oriented systems. Prerequisites: Admission to MS in CS program, or consent of department, plus CS 2020 or equivalent.

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.