What is Database Management System

Database Management System

A database is an organized as structured set of related data. It helps you to organize related information in a logical manner for easy access and retrieval. Even in your daily life, you maintain a database like, your personal address dairy in which you records addresses and telephone numbers of your friends and relatives. A school maintains the records of its students, staff, fees, salary, etc.


But, to maintain a database manually becomes very difficult when there are numerous records. The chances of making of mistakes increases manifold. A computerized database is the best solution for all types of database related problems. Computerized record keeping system, known as database, saves time and energy.

Database management involves creating, modifying, deleting and adding data in databases and using this data to generates reports. The software that allows performing these functions is called a database management system (DBMS). A dBs must ensure the data can be updated regularly and be represented in desired formats.

Some popular dBs for pcs are Microsoft Access, FoxPro and oracle.

A database is a collection of related data organized in tables. Tables consist of records and fields. A record is a row in the table that contains information such as name, address, phone number, etc.

A field is a column that contains categories of information. For example, each field in the record table contains the same type of information about a person. Serial no, name and phone No. are fields. Each record in the table contains all the information about a person.

Components of database:
The structure of a database is based on fields, records and files.

Fields

Each column of information in a table is referred to as a field. It stores a particular category of information. For example, the column titled ‘NAME’ is a feed that stores the names of students in class. So, the information stored in a column is called is field.

Record

Number of fields makes one record. Each row of information is called a record. For ex, date of birth indicates one record of students.

File
A file is collection of related records.

Database

A database is an organized collection of related information or data stored in files. There are mainly two type of database:

Flat file database: a flat file database that can store and retrieve information, it is not able to link the files together.

Relational database: is a type of database that links separate tables together to get a common piece of information.

Queries
Query is like a saved filter. It lets you combine the data from multiple related tables into a single datasheet of results.

Reports
Reports are used to display data from tables and queries in a beautiful and an attractive manner. Reports contain title, headers, footers, graphics, etc.