There are mainly five Database management system components, which are Data, People, Software, Hardware, Procedures. Even though all five components have key functions and play unique roles within a given database management system, they all work harmoniously and contribute to the overall effective function of the DBMS.
Relationship between the components.
Data: The main function of any DBMS is for the STORAGE and manipulation of data, these data can be whole or even data about the data itself, also known as metadata.
Hardware: These various data are then collected and stored with the aid of various hardware components, these hardware components could be a computer system, a storage medium (hard drive), they help serve as access point between data and users.
People: When it comes to DBMS there’s a wide range of people who use it, such as end users, DBMS administrators, and system programmers. For the smooth running and effective delivery of services there is the need for DBMS administrator who is tasked with the manipulation and oversight of data stored on the DBMS, the DBMS also has system programmers who are tasked with implementation of designs and maintenance of the DBMS.
Procedures: Each database has guidelines that govern their functions, a set of instructions follow a sequence of steps to be executed, these guidelines are set in place during the design and implementation of a DBMS by the system programmer.
Software: Software simply refers to programs put in place to ensure the execution of functions within the DBMS, it deals with the collecting and outputting of data in the database, it understands commands put in place by the administrator, system programmer and executes accordingly, it follows the procedures of the DBMS on execution of commands.
Each component interacts together within the DBMS to ensure the overall function of the system.
Please leave a comment below and share with other students in your network if you found this answer helpful. Happy learning!