Database Management System (DBMS) and Its Applications


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.

No comments: