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

What Is JAVA ? Data types in java

  JAVA Designed by - james gosling released  - 1995   A java is a programming language . it is one of the most popular programming language in the world . created by james gosling at sun Microsystems. First it was named Oak then Green and finally java. currently the ownership of the programming language is with Oracle. uses of java ? create Desktop applications . create mobile application .  create web application .  create games. used in web and application servers. why learn java ? It is a fast and powerFull language . It works on many platforms like window , mac , Linux etc. Easy to learn and use .open source and free. Learning other languages will be way more easier after learning java and its OOP concept. java first program *Every java program is written inside a class. *Commands start to execute from the main method in the class. 1. save the file using the same name used for the class name with extension .java. 2. Compile (This will create the java byte co...
1 comment
Read more