What is Database:
Database is collection of interrelated data which helps in efficient retrieval, inserting and deleting of data. In exams, marks obtained by the student in subjects is data before it is entered in the report card. In a report card, the combined (marks) data of all subjects speaks about students performance. Thus when data is maintained in an organized manner it becomes meaningful or organized information.
What is DBMS:
A database, often abbreviated as DB, is a collection of information organized in such a way that a computer program can quickly select desired pieces of data. A Database Management System (DBMS) is a software for creating and managing databases.
The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data. It stores data in such a way that it becomes easier to retrieve, manipulate, and update information.
Examples of popular DBMS are :
- MySQL,
- PostgreSQL,
- Access,
- Oracle,
- SQL Server,
- IBM,
- DB2 and
- Sybase.
Some Applications of DBMS
1.Railway Reservation System : Database is required to keep record of ticket booking, train’s departure and arrival status, status of seats available etc.
2.Library Management System : There are thousands of books in the library so it is very difficult to keep a record of all the books in a copy or register. So DBMS is used to maintain all the information related to book issue dates, name of the book, author and availability of the book.
3.Banking : People make thousands of transactions through banks daily and they can do this without going to the bank. So now banking has become so easy that by sitting at home bank customers can send or get money through banks. All this is possible just because of DBMS that manages all the bank transactions.
4.Universities and Colleges : Examinations are done online today and universities and colleges maintain all these records through DBMS. Student’s registration details, results, courses and grades all the information is stored in a database.
5. Credit Card Transactions : For purchase of credit cards and all the other transactions are made possible only by DBMS. A credit card holder knows the importance of his information that all are secured through DBMS.
6.Social Media Sites : We all are on social media websites to share our views and connect with our friends. Daily, millions of users sign up for these social media accounts like Facebook, Twitter, Pinterest and Google plus. But how is all the information of users stored and how are we able to connect to other people? Yes, this is all because of DBMS.
