what is database management system

what is database management system

Database Management System (DBMS) is essentially a collection of interrelated data and a set of software programs (or group of programs) that provides storage, access, security, and other facilities of those data. From 8.1.2 we already know the collection of data is usually referred to as database .Database systems are designed to manage huge amount of data. The management of data involves both data definition and the manipulation of data. The DBMS acts as an interface between application programs and physical data files and provides tools to add, delete, display, print, search, select, sort, and update data.

The primary objective of DBMS is
• To provide a convenient way to store data into a database.
• To provide an efficient manner to retrieve data from database.

Purpose of Database Management System

In traditional file system each program has its own file, so too many files will be needed and there may be many redundant data that create inconsistency. Database Management System removes these disadvantages. The DBMS permits an organization to centralize data, manage them efficiently, and provide access to stored data by application programs. Database Management System can store data one time and allow multiple programs to access those data. So data redundancy and inconsistency is removed in Database Management System. A major purpose of a database management system is to provide users with an abstract view of data.

Applications of Database Management System
Databases touch all aspects of our lives.
• Human resources: Payroll.
• Banking: Transactions.
• Universities: Student information management system, library information system.
• Sales: customers, products, purchases.

• Manufacturing: inventory, orders, production.

Applications of Database Management System
Databases touch all aspects of our lives.
• Human resources: Payroll.
• Banking: Transactions.
• Universities: Student information management system, library information system.
• Sales: customers, products, purchases.
• Manufacturing: inventory, orders, production.
• Create mailing list for mail merges. This allows the user to send out letters containing personal information kept in database.

Database Management System Offers the Following Services:
• Data Definition.
• Data Maintenance.
• Data Manipulation.
• Data Display.
• Data Integrity.

• Database File: Database file is the main file that represents the entire database. Example: student.mdb

• Table: A table is a collection of data about a specific topic. There can be multiple tables in a database. Example: student, employee.

• Field: Each column represents as field. Each field in a table has a field name; appearing at the top of the column. Tables usually contain multiple fields. Example: studentid, studentname, are the field name of student table.

• Record: Each row represents as record. For example, studentid, studentname fields make up a single student record.

• DataType: Data types are the properties of each field. It indicates the type of data that each field can hold. A field only has one data type. For example text, number, date etc.

Tweet