Introduction to Database Management Systems

This video demonstrates the need of DBMS ,the problems in the file based systems and the advantages of Database Management System in today’s era.

WHAT IS DATABASE SYSTEM?

A database management system (DBMS) is a computer software application that interacts with the user, other applications, and manage the organization and storage of data in database .

Some of the important Database Management Systems in use:-

Applications of DBMS

• Railway reservation and ticketing.
• Airlines booking.
• Hotel reservation.
• Movie ticket booking.
• Retail store billing.
• Salary processing.
• Mobile address book.
• Students mark sheet processing and printing.
• News paper printing and publications.
• Library Information System.

LIMITATIONS OF DATA PROCESSING ENVIRONMENT

• Data redundancy:
• Data Inconsistency:
• Data Integrity problems:
• Data Access difficulty:
• Data Isolation:
• Concurrent Access anomalies:

Advantages of using DBMS

1. It represents complex relationships among different data items:
2. Enforces data integrity in a System:
3. Keeps a tight control on data redundancy:
4. Efficient data access:
5. Maintains data dictionary:
6. Provides different interfaces through which users can manipulate data: