Content text DBMS miss bata.pdf
Basic Terminologies • Data – Data are raw facts that can be recorded in some media such as paper media, digital media, human brain, etc. • Information – Information are the processed data. • Database – Database is an organized collection of logically related data stored in a standard format. • Database System – A database system is an integrated collection of logically related data along with the details. – Some of the commonly used DBMS are MySQL, Microsoft Access, Oracle.
Concept of Database Management System (DBMS) • Database Management System (DBMS) is the collection of software programs that is used to manage the database effectively and conveniently. • DBMS provides an interface to perform various operations such as I. Defining the database II. Inserting data records into the database III. Deleting data records IV. Retrieving data from database V. Providing security to the database
Applications of DBMS 1. Banking For storing customer information, tracking day to day credit and debit transactions, generating bank statements etc. All these work has been done with the help of database management systems. 2. Sales To store customer information, product information and invoice details. 3. Airlines To store the early reservation information along with flight schedule.