CS 348: Information Systems

List of Topics:

  1. Data modeling: physical, logical and conceptual data models, the entity-relationship model

  2. The relational model and relational algebra

  3. SQL query language

  4. Other relational query languages (QBE and Datalog)

  5. Relational database integrity and security

  6. Relational database design, functional dependencies, and normalization

  7. Object-oriented database systems (fundamentals of object-orientation and models: object structures, objects and classes, generalization and inheritance, multiple inheritance, identity and persistence)

  8. Object database languages: persistent C++, the ODMG definition and manipulation languages

  9. Object-relational database systems: extensibility features and object orientation in relational systems

  10. XML/web databases: semi-structured data, querying, ODBC, JDBC

  11. Database system architectures: two-tier (client-server), three-tier, parallel and distributed database architectures

  12. Database administration and database tuning

  13. Data mining, data warehousing, online analytical processing, and information retrieval

2005.12

Last Updated: Jun 20, 2025 11:37 AM