Data Bases and Data Warehouses.

1. Under the hood.
   1. Physical
   2. Logical
   3. Algorithm
   4. Index
   5. Physical v Logical structure.
   
   
2. Relational DB
   1. Table
   2. Row = record
   3. Column = field = attribute
   4. Go over page 99.
   5. one to one
   6. one to many
   7. Many to one
   8. Many to Many (intermediate table)
   9. Keys (page 101).
      1. primary
      2. Foregin
      3. Constraints
   
   
3. DBMS Tools
   1. DBMS Engine
      Handles the physical storage
      logical to physical
      provides logical views.
   2. Data Definiton Subsystem
      data layout
      Data constraints
      Keys
   3. Data Manipulation Subsystem
      Views
      report generators
      QBE
      SQL
   4. ApplicationGeneration Subsystem
      A program that writes programs
   5. Data Administration Tools (DBA)
      1. Back up
         incremental
         full
         off-site?
      2. Recovery
      3. Consistency
      4. Security and authenication
      5. Reorganization
      6. audit trail of tranactions Logs.
   
   
4. Data Warehouses and Data Marts
   1. What is a data warehouse? p112
   2. Decision making not opertional
   3. Data-mining tools OLAP
   4. Query and reporting tools
   5. Intelligent agents (spiders)
   6. MDA
   7. Statistical Tools
   8. Data Marts (TEA example)
   
   
5. Managing Information
   1. CIO
   2. DA
   3. DBA
   4. Information (The stale internet)