0:06	hello everyone welcome back in this
0:09	presentation we are going to exclusively
0:11	focus on the various applications of
0:13	database management systems why waiting
0:16	let's directly step into the various
0:19	applications
0:20	before stepping into the first
0:22	application i request you to have a
0:24	paper and pen with you so that you can
0:26	make a note of the various application
0:29	areas that we are going to discuss
0:30	shortly the first application that we
0:33	are going to address today is the sales
0:36	how sales is an application area of dbms
0:39	be it any sales related enterprise it
0:42	may be a grocery shop or a pharmacy or a
0:45	supermarket or a fashion shop or a
0:47	textile shop anything
0:49	the information such as the customer
0:51	details the product details the purchase
0:54	details and whatnot everything needs to
0:57	be maintained
0:58	and where it is going to be maintained
1:00	obviously in the database so sales is
1:03	the first application that we are
1:04	concentrating on in the applications of
1:07	database management system coming to the
1:10	second application area which is the
1:12	finance what is this finance the
1:14	financial institutions main preference
1:17	will be databases only you know why
1:19	because they need to store the sales
1:21	information the information about the
1:23	purchase of stocks or bonds the online
1:26	trading information in simple terms i
1:29	mean to say the entire stock market and
1:31	the financial institution related
1:33	activities must be maintained and well
1:35	documented so obviously finance is one
1:38	of the application areas of database
1:40	management systems and coming to the
1:43	third application areas which is the
1:45	banking environment this banking is an
1:48	inevitable area of application of dbms
1:51	and it's obvious because the bank needs
1:53	to store the information of the
1:55	customers the accounts loan the
1:58	transaction informations the credit card
2:00
details the generation of monthly
2:02
statements in the credit cards asset
2:04
details and many more so obviously
2:07
banking is one of the application areas
2:09
of database management systems and
2:12
coming to the fourth application areas
2:14
schools colleges and universities this
2:17
is obviously an undeniable applications
2:19
of dbms because students information
2:22
teachers information non-teaching staff
2:24
information course information great
2:27
information and everything needs to be
2:29
maintained who knows even after 20 years
2:32
a person may come to the university and
2:34
ask for certain details at that time the
2:37
university or the school or the college
2:39
should not say that they have not
2:41
maintained the information
2:42
it's the primary responsibility of any
2:45
university or any educational
2:47
institutions to maintain the complete
2:49
information
2:51
and obviously university schools and
2:53
colleges will prefer database management
2:55
systems only for their efficient storage
2:58
and retrieval purpose and coming to the
3:00
next application areas which is the
3:02
manufacturing supply chain management is
3:05
an essential part of any manufacturing
3:07
organization because they need to
3:09
maintain the details of the production
3:11
of items the inventories of the items in
3:14
the warehouse the stores and the order
3:16
information customers information
3:18
purchase information sales information
3:21
and whatever thing possible so
3:23
manufacturing is the next application
3:25
areas of database management systems and
3:28
coming to the next application areas
3:30
which is the online stores
3:32
and in this contemporary world we are
3:34
mainly depending on these online stores
3:37
like amazon flipkart snapdeal and many
3:40
and what kind of information are stored
3:42
and maintained in the online stores the
3:45
sales information which we have already
3:46
seen in addition to the sales
3:48
information the online stores have to
3:50
maintain the online order details the
3:52
sales details the user login details
3:56
even we can see the recommendations
3:58
right the recommendation details the
4:00
reviews about the product by the
4:02
customers and many and that's why we are
4:04
saying that the online stores are also
4:07
one of the important applications of
4:09
database management systems and coming
4:11
to the next one the railway reservation
4:14
and what kind of information that
4:16
railways needs to maintain the pnr
4:19
information the passenger name record
4:21
information the customer or the
4:23
passenger information the train schedule
4:25
the reservation information even hr
4:28
information because railways they have
4:30
their own employees so hr information to
4:32
be maintained accounting information to
4:35
be maintained the route and the
4:37
alternate route details needs to be
4:38
maintained like railways we also have
4:41
another applications of database
4:43
management system which is the airlines
4:45
so this is similar to the railways like
4:47
the passenger name record information
4:49
customer or passenger information flight
4:52
schedule the reservation information hr
4:54
accounting route alternate route details
4:57
and also the login details
4:59
and coming to the next application areas
5:01
which is the hr the human resource
5:04
obviously any organization will
5:06
certainly have employees so employees
5:08
details have to be maintained the salary
5:11
details the payroll information the tax
5:14
information the benefits and goodies
5:16
information everything needs to be
5:18
maintained by any organization and
5:20
that's why human resources are also one
5:23	of the application areas of dbms and
5:25	coming to the next application which is
5:28	the telecommunication industry we cannot
5:30	deny the fact that telecommunications
5:33	has made a remarkable revolution in this
5:35	world and what kind of information needs
5:38	to be maintained by the telecom sector
5:40	the customer records the call made
5:42	details the prepaid and post paid
5:44	connection records recharge and bill
5:46	details balance details and many
5:49	and coming to the last application areas
5:51	which is the insurance obviously user
5:54	details the policy details the buyer
5:57	details the nominee details the payment
5:59	details claims settled and login details
6:02	everything needs to be maintained by the
6:03	insurance company so we have seen few
6:06	application areas of database management
6:08	systems and this is just a sample if you
6:12	look into the real-time applications of
6:14	dbms it's vast it's enormous you may be
6:17	having a doubt in your mind why we are
6:20	preferring dbms
6:22	we know we have file systems which is
6:24	also going to store the data and which
6:26	is also going to retrieve the data now
6:28	what's so special with dbms and why we
6:31	are not preferring file systems
6:33	so it means there are some advantages of
6:35	having dbms over file systems right and
6:38	that's what the topic of the next
6:40	lecture we will compare database
6:42	management system with file systems
6:44	before we sign out let's see the
6:46	homework question i have already listed
6:49	few application areas of dbms on the
6:51	screen now what's the homework question
6:54	i request you to just figure out other
6:56	application areas of dbms and post your
6:59	answers in the comments section
7:02	i'll catch you in the next presentation
7:04	and thank you for watching
7:06	[Music]
7:06	[Applause]
7:08	[Music]
7:17	you