4.Standards can be enforced.
5.Security restrictions can be applied.
6.Integrity can be maintained.
7.Data gathering can be possible.
8.Requirements can be balanced.
Database Management System (DBMS):
It is a collection of programs that enables user to create and maintain a database. In other words it is general-purpose
software that provides the users with the processes of defining, constructing and manipulating the database for
Disadvantages in File Processing
Data redundancy and inconsistency.
Difficult in accessing data.
Concurrent access is not possible.
Advantages of DBMS:
2.Efficient Data Access.
3.Data Integrity and security.
5.Concurrent access and Crash recovery.
6.Reduced Application Development Time.
Banking: all transactions
Airlines: reservations, schedules
Universities: registration, grades
Sales: customers, products, purchases
Online retailers: order tracking, customized recommendations
Manufacturing: production, inventory, orders, supply chain
Human resources: employee records, salaries, tax deductions
People who deal with databases
Many persons are involved in the design, use and maintenance of any database. These persons can be
classified into 2 types as below.
Actors on the scene:
The people, whose jobs involve the day-to-day use of a database are called as 'Actors on the scene',
listed as below.
1.Database Administrators (DBA):
The DBA is responsible for authorizing access to the database, for
Coordinating and monitoring its use and for acquiring software and hardware resources as needed.
These are the people, who maintain and design the database daily.
DBA is responsible for the following issues.
A.I.J.H.M COLLEGE ROHTAK