Database Management System (DBMS)
and Its Applications:
A Database management system is a computerized record-keeping system. It
is a repository or a container for collection of computerized data files. The
overall purpose of DBMS is to allow he users to define, store, retrieve and
update the information contained in the database on demand. Information can be
anything that is of significance to an individual or organization.
Databases
touch all aspects of our lives. Some of the major areas of application are as
follows:
1. Banking
2. Airlines
3. Universities
4. Manufacturing and selling
5. Human resources
Enterprise Information
◦ Sales: For customer,
product, and purchase information.
◦ Accounting: For payments,
receipts, account balances, assets and other accounting information.
◦ Human
resources: For information about employees, salaries, payroll taxes, and
benefits, and for generation of paychecks.
◦ Manufacturing: For
management of the supply chain and for tracking production of items in
factories, inventories of items
in warehouses and stores, and orders for items.
Online retailers: For sales data noted above
plus online order tracking, generation of recommendation lists, and
maintenance of online product evaluations.
Banking and Finance
◦ Banking: For customer
information, accounts, loans, and banking transactions.
◦ Credit card transactions:
For purchases on credit cards and generation of monthly statements.
◦ Finance:
For storing information about holdings, sales, and purchases of financial
instruments such as stocks and bonds; also for storing real-time market data to
enable online trading by customers and automated trading by the firm.
• Universities: For student information, course registrations, and grades (in addition
to standard enterprise information such as human resources and accounting).
• Airlines: For reservations and schedule information. Airlines were among the
first to use databases in a geographically distributed manner.
• Telecommunication: For keeping records of calls made, generating monthly bills,
maintaining balances on prepaid calling cards, and storing information about
the communication networks.