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 Power Supply?

                      What Is Power Supply?  POWER SUPPLY :    A power supply unit (PSU) converts main AC (alternative current ) 110-115 or 220-230 volt to low-voltage regulated DC (direct current) power for the internal components of a computer . There are two types of power supplies existed,  AC and DC power supply . Based on the electrical device's electric specifications it may use AC power or DC power.                       ATX power supply unit The power supply is located at the back of the computer,  usually at the top. However, many more recent  tower   computer cases house the power supply at the bottom  back of the case. In a desktop computer case (all-in-one),  the power supply is located at the back left or back right. links- instagram twitter facebook
3 comments
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