Please enable JavaScript.

Coggle requires JavaScript to display documents.

Database Management (module 1 (lecture 2: relational model (Constraints…

- - - - self-describing
      - program data separation
      - data abstraction
      - network multi-user access
      - client-server architecture
    - - old ideas
        
        1962
        
        term "DB"
        
        1964
        
        Charles Bachman
        
        1924-2017
        
        Turing award 1973
        
        IDS
        
        network model
        
        record
        
        set
        
        the gist
        
        successful
        
        general purpose with mentioned modern proerties
        
        tied closely to COBAL
        
        1966-68
        
        navigational DB systems
        
        1970
        
        1977
        
        1977-79
        
        1973-85
        
        1985
        
        big deal
        
        pre 1960
        
        tapes
      - newer ideas
        
        1990's
        
        OODBMS
        
        XML
        
        2010's
        
        noSQL
        
        newSQL
  - - - example
    - - degree
      - attributes
        
        domain
    - - implicit
      - explicit
        
        key
        
        superkey
        
        primary
        
        foreign
      - application-based
  - - - Queries
        
        SELECT
        
        WHERE
        
        Conditions
        
        operators
        
        relational
        
        Other
        
        Arithmetic
        
        AS
        
        JOINS
        
        result: cross product
        
        can join on multiple
        
        tables
        
        attributes
        
        conditions
        
        NULLs