Please enable JavaScript.

Coggle requires JavaScript to display documents.

INTRODUCTION ON DATABASE - Coggle Diagram

- - - - report
      - interface form
- - - - enter
      - query
      - read
      - create query
    - - a productivity software program that need/work with database
      - D.A must
        
        not allow talk/use database DIRECTLY
        
        MUST GO THROUGH DBMS
    - - DATABASE MANAGEMENT SYSTEM
        
        DBMS = APP PROGRAM != DATABASE
        
        IT ONLY INTERACT WITH DATABASE
      - serve as GATE KEEPER or INTERMEDIARY between database application and database
      - control & manage database operation
      - a special software program
        
        process database
        
        administer database
        
        create database
      - usage
        
        create database, table, support structure
        
        provide security, backup, recovery
        
        can establish & enforce many CONSTRAINT
        
        Referential Integrity Constraint
        
        purpose
        
        ensure value in table that have matching value in other table
    - - self-describing collection of related records
        
        contain its own definition
        
        METADATA
        
        data that describe structure of data in database
        
        exp; (empId, 1, 2) = empId is an integer.
      - content
        
        metadata
        
        user data (input)
        
        overhead data & indexes
        
        improve performance
        
        track data through database
        
        how user interacting with database
        
        application metadata
        
        stored user preferences
  - - - capable to build database application/ interface to database within DBMS
      - DBMS + DATABASE = 1 ENTITY
      - not very powerful
      - exp: Microsoft Access
    - - used by large- sized company
      - very powerful