Databases

Databases

1. Definition

   • File
     • Record
       • Data items
         • Text
         • Number
         • Date
         • Time
         • Graphics
         • Calculated

2. DBMS

   • Logical View
     • Schema
     • Subschema
   • Physical View
     • Access methods
     • Data Clustering
   • Data Definition Languages
   • Data Manipulation Languages
   • Utilities
     • Crash Recovery
     • Transaction management
     • Concurrency Control
     • Data Integrity
     • Security

3. Life Cycle

   • 1. Information Requirements
     • Data Required
     • Natural Data Relationships
     • Software Platform
   • 2. Logical Design
     • Global Schema
       • 2.1 Conceptual Model Diagram
         • ER
         • UML
       • 2.2 View Integration
         • Eliminate Redundancy
         • Eliminate inconsistency
         • ER Semantic Tools
           • Identification of synonyms
           • aggregation
           • Generalization
       • 2.3 Conceptual Data Model To SQL
       • 2. 4 Normalization of tables
         • Functional Dependencies (FDs)
         • Unique Identifies (Keys)
   • 3. Physical Design
     • Selection of indexes
     • Partitioning and clustering data
   • 4. Implementation
     • Constructs
       • DML
       • DDL

Imagens e arquivos do mapa