Database management system

1. Database Management SystemDatabase Management System
By Prakash
Date: 13 Nov 2010

2. What is database?What is database?
A set of related data is called database.A set of related data is called database.

For example:For example:

Student database that consists of the following fields, Enrollment Student database that consists of the following fields, Enrollment
number, Student name, Department, Year, Address.number, Student name, Department, Year, Address.

Employee database that consists of the following fields, Employee Employee database that consists of the following fields, Employee
number, Employee name, Department, Address, Date of joint, number, Employee name, Department, Address, Date of joint,
Salary.Salary.

3. What is Database Management What is Database Management
System?System?
DBMS is a software system that allows user to access the data contained DBMS is a software system that allows user to access the data contained
in the database.in the database.
DBMS acts as an interface between the user and the database. The user DBMS acts as an interface between the user and the database. The user
requests the DBMS to perform various operations (insert, delete, update requests the DBMS to perform various operations (insert, delete, update
and retrieval) on the database.and retrieval) on the database.
For example:For example:
Train ticket reservation system andTrain ticket reservation system and
Bus ticket reservation systemBus ticket reservation system

4. Function of DBMSFunction of DBMS

5. What is purpose of the DBMS?What is purpose of the DBMS?
Easy to use – Adding, updating and deleting data in database
Centralized control of database – Share database to multiple user
Data Security – User based security to the database

6. Before the introduction of DBMS:Before the introduction of DBMS:
Information typically stored using file-processing systemInformation typically stored using file-processing system
File processing is the process of creating, storing and accessing content of File processing is the process of creating, storing and accessing content of
filesfiles
Disadvantages in file-processing system:Disadvantages in file-processing system:
1.Data redundancy – Same data may appear in several files
2.Data inconsistency – Changes in data may not reflect in
all files
3.Difficult in data access – To take reports very difficult
4.Data isolation – Data are stored in various files
5.Data integrity – Database accurate and consistent
6.Data security – User level security

7. Real time example
In the Telephone System Manufacturing company with more than 2,500
employees working in that company.
Management asking the report like:
Who are all getting salary more than 10,000?

8. SELECT * FROM Employee WHERE salary > 10,000
The above oracle command lists all records which the salary more
than 10,000
If it is small company with 12 employees

9. DBMS used in Altacit Global
1.IP docketing system
Front end: Asp.Net (User Interface Screen)
Back end: Sql server (DBMS)
2. Law Firm Management System
Front end: Java script (User Interface Screen)
Back end: Sql server (DBMS)

10. Admin login screenshot of IPdocket
Assign Permissions
User details

11. Dhanya login screenshot in IPdocket

12. Thank you