Skip to main content

Define DBMS ? And it's applications .

 Define DBMS ? And it's applications || 2inshort

Hey everyone , today we will talk about Database  management system ,this subject is very important in engineering.



Define DBMS : 

Data base is a collection of related data in a systematic manner. It is a system of storing and taking care of data , data can be easily accessed managed and updated. Data base can have multiple tables.Database is controlled through a software called DBMS.


SO what is DBMS?

-DBMS is a computer software application.

-DBMS interact with user , other application and Database itself to retire and analysis the data.
-accept request for data from an application and instructs OS and provide specific data.
-DBMS allows users  to create their own data.

example -
Oracle , Microsoft , SQL ,  MySQL ,  DB2 , ORION , IMS  , Foxpro , MongoDB

Applications of DBMS



1. Banking ( All transactions) : We make thousands of transactions through banks daily and we can do this without going to the bank. So how banking has become so easy that by sitting at home we can send or get money through banks. That is all possible just because of DBMS that manages all the bank transactions.

2. Airlines ( Reservation schedule ) : Airlines use databases for storing passenger information when tickets are booked and when passengers check-in at the airport.

4. manufacturing (production , inventory , order ) : Manufacturing companies make products and sell them on the daily basis. To keep records of all the details about the products like quantity, bills, purchase, supply chain management, DBMS is used.

4. Human resources ( employee recard  ,  salaries ) : Big firms have many workers working under them. The human resource management department keeps records of each employee’s salary, tax, and work through DBMS.

5. Tele communication ( record of calls , monthly bills ) : Any telecommunication company cannot even think about its business without DBMS. DBMS is a must for these companies to store the call details and monthly post-paid bills

6. Universities ( grades , registration ) : Examinations are done online today and universities and colleges maintain all these records through DBMS. Student’s registrations details, results, courses, and grades all the information are stored in the database.


Advantages of DBMS 

1. Data independence 
2. Efficient data access 
3. Data integrity and  security 
4. Data administration 
5. Reduce application development
6. Concurrent access and crash recovery

Comments

Post a Comment

Popular posts from this blog

What is Data abstraction? explain in detail ?

  What is Data abstraction? explain in detail ?  hey everyone today we will talk about what is data abstraction. Data abstraction data abstraction refers to the process of hiding irrelevant details from the user. The need of efficiency has led designed from the complex data structure to represent data in the database. here the three levels of data abstraction- 1.view level : The highest level of abstraction describe only part of the entire database. Even thought the logical level of user simple structure , complexity remains because of the variety of information stored in a large Database system do not need all this information inserts they need to access only a  part of the Database .The view level of abstraction exists to simplify their interaction with the system . The system may provide many view for the same Database.                                      2. logical level: ...
1 comment
Read more

Variable , Constant , Comments in JAVA ?

java Variable -A variable can be define as a memory location that stores an data value of a certain type. -A variable consists of a data type along with a suitable name. -Assigning a value for a variable for the first time is called initializing a variable. example int age; output first we took integer the declare its value and then print the output. Constant -The difference between a constant and a variable is that the value held by a variable can be changed throughout the problem execution . but after a constant has been initialized we can not change the value in it. example final double pi 21/7   output ERROR , because we have already declared the value of PI. Comments -Comment can be used to explain written code. -This will help a person to read and understand the code in future .  -Comments are ignored by the compiler during compilation. Whatever is written inside the comments will not be printed because it is only for understanding. instagram twitter facebook
3 comments
Read more