Database Management System (DBMS)

A database is a collection of related data. It is the electronic equivalent of a file cabinet. A database management system (DBMS) or database manager is a program that sets up, or structures, a database. it also provides tools to enter, edit and retrieve data from database. All kind of individuals use databases from teacher recording grades to police officers checking criminal histories. Colleges and universities use databases to keep records on their all existing and ex-students, instructors and courses details. Organizations of all types maintain employee database. Database can be used in different ways and different places. For microcomputers there are three most widely used database management system designed to use they are Microsoft Access, Corel Paradox and Lotus Approach. In normal ways Microsoft Access is widely used because to create and modify database again is featured well in this application which is packed in Microsoft Office packages of all variant.

The relational database is the most widely used database structure. Data is organized into related tables. Each of the is made up of rows called records and columns called fields. Each record contains fields of data about some specific person, place or things as their input is made by collecting the general information from that particular person, place or things.

A database management system (DBMS) provides a variety of tools to create and use databases. A sort tool will quickly rearrange a table's record according to a selected field.

The greatest power of a database management system come from its ability to quickly find and bring together in the formation stored in separate tables using queries, forms and reports. A query is a question or request for specific data contained in a a database. Database forms look similar to traditional printed forms. These electronic forms are displayed on the computer's display and typically reflect the contents for one record in a table. They are primarily used to enter new records and to check them for modification of new data to existing records. Data from tables and queries can be printed in a variety of different types of reports from a simple listing of an entire field in a table to list of selected fields based on a query involving several tables.

How does database management system works ?

There are three steps are involves in the database management system where it is simple process just like finding any thing in any given page. If a similar matches found then all the information related to that records are displayed and if the records are not found then sure tells no such kind of records found.

First step always a query and or a question by the user like a roll number, visitor number, name of member or any other unique identification number given to him. By this number and text the query is made on the form and web application from where you will get all the details about the individual and thing.

Second step is done by the database management system where the database program will search whole database with the given query made. Afterward the system will give output.

Third step of the database management system to proceed the data. If details about the query is available then the details would be appear next to query box in the form. If details about the query is not available then database management system will give not available here like message.

This is the database management system and its work. Today this is the part of all the organizations where every single details are accessed whenever we need it.