Please enable JavaScript.

Coggle requires JavaScript to display documents.

RELATIONAL DATABASES - Coggle Diagram

- - - - It stores lots of redundant data
      - Problems occur when invoice data are stored in these types of tables
        
        Insert Anomaly
        Occurs in our example because there is no way to store information about prospective customers
        
        Delete Anomaly
        Occurs when deleting a row has unintended consequences
        
        Update Anomaly
        Because data values are not correctly updated
- - - - Online analytical processing
        Using queries to investigate hypothesized relationships among data
      - Data Mining
        using sophisticated statistical analysis, including artificial intelligence techniques
  - - - Database Systems
        Application programs that access the database through the DBMS
      - Database Administrator
        Responsible for coordinating, controlling, and managing the database
      - Database Management System
        Program that manages, controls, and interface between the data