DM CS Core

DM-A: The Role of Data

  1. The Data Life Cycle: Creation-Processing-Review/Reporting-Retention/Retrieval-Destruction.
  2. The social/legal aspects of data collections:
    1. scale
    2. data privacy
    3. database privacy (compliance) by design
    4. anonymity
    5. ownership
    6. reliability
    7. intended and unintended applications

DM-B: Core Database System Concepts

  1. Purpose and advantages of database systems
  2. Components of database systems
  3. Design of core DBMS functions (e.g., query mechanisms, transaction management, buffer management, access methods)
  4. Database architecture, data independence, and data abstraction
  5. Use of a declarative query language
  6. Transaction mgmt
  7. Normalization
  8. Approaches for managing large volumes of data (e.g., noSQL database systems, use of MapReduce).
  9. How to support CRUD-only applications
  10. Distributed databases/cloud-based systems
  11. Structured, semi-structured, and unstructured databases

DM-C: Data Modeling

  1. Data modeling
  2. Relational data model

DM-D: Relational Databases

  1. Entity and referential integrity
    1. Candidate key, superkeys
  2. Relational database design

DM-E: Query Construction

  1. SQL Query Formation