Wednesday, April 25, 2018

Database Management System

Google Play Store App

Earth_Rings_space_rings
✴ A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.✴

► A DBMS makes it possible for end users to create, read, update and delete data in a database. The DBMS essentially serves as an interface between the database and end users or application programs, ensuring that data is consistently organized and remains easily accessible.✦

  【Topics Covered in this App are Listed Below】

⇢  Overview

⇢  Architecture

⇢  Data Models

⇢  Data Schemas

⇢  Data Independence

⇢  ER Model - Basic Concepts

⇢  ER Diagram Representation

⇢  Generalization Aggregation

⇢  Codd's 12 Rules

⇢  Relation Data Model

⇢  Relational Algebra

⇢  ER Model to Relational Model   
             
⇢  SQL Overview

⇢  Normalization

⇢  Joins

⇢  Storage System

⇢  File Structure 
       
⇢  Indexing

⇢  Hashing

⇢  Transaction 
           
⇢  Concurrency Control     
           
⇢  Deadlock         
         
⇢  Data Backup

⇢  Data Recovery
Previous Post
Next Post

0 comments: