database management system

Database Management System (DBMS) | Overview | Syllabus | Book

What is a database?

A database system is basically just a computerized record-keeping system.

What is enterprise

An enterprise might be a single individual with a small personal database, or a complete corporation or similar large body with a large shared database, or anything in between. Here are some examples:

  • A manufacturing company
  • A bank
  • A hospital
  • A university
  • A government department

A variety of operations involving such files

√ adding new files to the database
√ inserting data into existing files
√ retrieving data from existing files
√ deleting data from existing files
√ changing data in existing files
√ removing existing files from the database

Benefits of the Database Approach

◊ The data can be shared
◊ Redundancy can be reduced
◊ Inconsistency can be avoided
◊ Transaction support can be provided
◊ Integrity can be maintained
◊ Security can be enforced
◊ Conflicting requirements can be balanced
◊ Standareds can be enforced


  • Database System Concepts and Architecture
    • Data Models, Schemas, and Instances
  • Three-Schema Architecture and Data Independence
  • Data Modelling
    • Entity-Relationship Diagram
  • Relational Model
    • Constraints
    • Languages
    • Design and Programming
  • Relational Database Schemas
  • Functional Dependencies and Normalization
  • SQL
    • Data Definition and Data Types
    • Constraints
    • Queries
    • Insert, Delete, and Update Statements
  • Transaction Process
  • Concurrency Control Techniques
  • Database Recovery Techniques

Leave a Comment

Your email address will not be published. Required fields are marked *

PYQ of History UGC NET UGC NET Mathematical Reasoning and Aptitude ICT (Digital Initiatives) | UGC NET | paper – 1 The Scope of Information and Communication Technology(ICT) PYQ of People, Development, and Environment Top 30 PYQ of HINDI | UGC NET – 2023 Top 30 PYQ of Teaching Aptitude PYQ of Research Aptitude | NTA UGC NET | Paper 1 | Part 1 UGC NET Paper 1 Syllabus | Updated | 2023 Types of Research | Research Aptitude | nta ugc net | UGC NET 2023