RE: Explain DBMS.
||Basics of DBMS
Basics of DBMS.docx (Size: 188.98 KB / Downloads: 169)
Database Management System (DBMS) is a collection of interrelated data [usually called database] and a set of programs to access, update and manage those data [which form part of management system].
Primary goals of DBMS are:
1. To provide a way to store and retrieve database information that is both convenient and efficient.
2. To manage large and small bodies of information. It involves defining structures for storage of information and providing mechanism for manipulation of information.
3. It should ensure safety of information stored, despite system crashes or attempts at unauthorized access.
4. If data are to be shared among several users, then system should avoid possible anomalous results.
Applications of DBMS:
1. Banking – For customer information, accounts, and loans, and banking transactions. [all transactions]
2. Airlines – For reservation and schedule information. [reservations, schedules]
3. Universities – For student information, course registrations, and grades. [registration, grades]
4. Credit Card Transactions – For purchases on credit card and generation of monthly statements.
5. Telecommunication – For keeping records of calls made, generating monthly bills, maintaining balances on prepaid calling cards, and storing information about communication networks.
6. Finance – For storing information about holdings, sales, and purchases of financial instruments such as stocks and bonds.
7. Sales – For customer, product, and purchase information. [customers, products, purchases]
8. Manufacturing – For management of supply chain and for tracking production of items in factories, inventories of items in warehouses/stores, and orders for items. [production, inventory, orders, supply chain]
9. Human Resources – For information about employees, salaries, payroll taxes and benefits, and generation of paychecks. [employee records, salaries, tax deductions]
Data and Information:
Data are raw facts or observations typically about physical phenomenon or business transactions. More specifically data are objective measurements of the attributes (or characteristics) of entities (such as people, places, things and events)
Data Organization and Grouping:
Data as we already mentioned occurs in real world individually. But it is grouped and organized to help process it and generate information.
The grouping of related data items from user’s view is called logical grouping. The grouping of data items from the point of view of its storage inside the computer is called physical grouping.
Just as writing is organized in letters, words, sentences, paragraphs and chapters, Data can be organized as characters, fields, records, files and databases.