What is a database management system? Explain its components.
What is a database management system? Explain its components.
Database management system means a combination of hardware and software that can be used to monitor a database and to manage the updating and retrieval of a database. Database Management System (DBMS) is the collection of interrelated data and a set of procedures to access the data. It has programs to set the storage structures, load the data, accept data requests from programs and users, format retrieved data so that it appears in a form that program or user expects, hide data that a particular user should not have access to, accept and perform updates, allow concurrent use of the data without having users interface with each other and perform backup and recovery procedures automatically.
1. Components of DBMS: These are comprised of several components. These would include software, hardware, data, procedures and database access language.
Hardware: Hardware of computer consists of physical components such as keyboard, mouse, monitor, and processor. These are electronic and electromechanical components.
2. Software: A set(s) of programmes, which is used to work with such hardware is called its software. A coded set of instructions stored in the form of circuits is called firmware.
3. People: People interacting with the computers are also called live-wire of the computer system. They constitute the most important part of the computer system.
4. Procedures: The procedure means a series of operations in a certain order or manner to achieve desired results. There are three types of procedures which constitute part of a computer system: hardware-oriented, software-oriented and internal procedure.
5. Data: These are facts and may consist of numbers, text, etc. These are gathered and entered into a computer system. The computer system in turn stores retrieves, classifies, organises and synthesises the data to produce information according to a pre-determined set of instructions.
Database management system means a combination of hardware and software that can be used to monitor a database and to manage the updating and retrieval of a database. Database Management System (DBMS) is the collection of interrelated data and a set of procedures to access the data. It has programs to set the storage structures, load the data, accept data requests from programs and users, format retrieved data so that it appears in a form that program or user expects, hide data that a particular user should not have access to, accept and perform updates, allow concurrent use of the data without having users interface with each other and perform backup and recovery procedures automatically.
1. Components of DBMS: These are comprised of several components. These would include software, hardware, data, procedures and database access language.
Hardware: Hardware of computer consists of physical components such as keyboard, mouse, monitor, and processor. These are electronic and electromechanical components.
2. Software: A set(s) of programmes, which is used to work with such hardware is called its software. A coded set of instructions stored in the form of circuits is called firmware.
3. People: People interacting with the computers are also called live-wire of the computer system. They constitute the most important part of the computer system.
4. Procedures: The procedure means a series of operations in a certain order or manner to achieve desired results. There are three types of procedures which constitute part of a computer system: hardware-oriented, software-oriented and internal procedure.
5. Data: These are facts and may consist of numbers, text, etc. These are gathered and entered into a computer system. The computer system in turn stores retrieves, classifies, organises and synthesises the data to produce information according to a pre-determined set of instructions.
