What is DBMS and what is its function?

What is DBMS? You must have heard about DBMS, its full name is Database Management System. It is known from the name that it manages the entire database. Database management systems do all the work from creating, handling and deleting data. A software that can create, manage, control, delete and update data.

Through DBMS both users and programmers can handle their data, ie both can create, manage and update the data. It has its many benefits, about which it is very important for you to know. Let us know what DBMS is and what is in it in full detail.

Database is a collection of related data. The same data collection is the facts and figures that are processed to generate information.

Most data represent recordable facts. Data helps to produce information which are based on facts. for example. If we have marks of one class, then we can conclude who among them are toppers and who are average marks.

What is wordpad
What is ms word
What is data and its types
This database management system stores data in such a way that it is easy to retrieve, manipulate, and produce data from it.

DBMS Full Form?
The full form of the DBMS is the Data Base Management System.

DBMS Full Form in hindi?
DBMS Full Form is a database management system. When the definition of the database is understood, it is a collection of related data that is organized in such a way that it can be easily accessed, managed and updated.

What are the Characteristics of Database System?
1. Being of self-specified nature: A database system not only contains data but also stores the description of database structure and constraints with it. The definition is stored in the DBMS catalog, which contains information such as structure of each file, type and storage format of each data and constraint. The information that is stored in the catalog is called meta data.

2. Program Data Independence: If I talk about traditional file processing, then the structure of each file is embedded in the application program. Therefore, due to any change in the file, it is necessary to make necessary changes in the programs also to access that file. In DBMS, we have program data independence because the structure of data files is stored separately in the system catalog, if we compare it with the access programs.

3. It supports Multiple Views Data: There are many users of a database in which each requires a different view or perspective for the database.

4. Sharing of database can be between multiple users: DBMS allows multiple users to access the database at the same time.

What is the function of DBMS
1. Data Redundancy
Each application in the file system has its own private files and in such a situation duplicate files of the same data are created in many places. The same type of files are kept at one place in the DBMS, ie it is not repeated which reduces the Redundancy of the data.

2. Sharing Of Data
In DBMS, data is shared by the authorized user of the organization. In this, the data administrator controls the data and gives the user rights to access the data.

3. Data Consistency
DBMS can prevent the same type of data from being stored repeatedly in the database.

4. Integration Of Data
In DBMS all data is in tables and a database has more than one table. Relationships can be created between all these tables, which makes it easy to retrieve and update data.

Comments

Post a Comment

Popular posts from this blog

What is CMOS and how does it mitigate?

Do you know what CMOS is? If not, then today's article is going to prove very beneficial for you. Anyway, how can anyone forget CMOS whenever it comes to Intergrated Circuit. This is because the two biggest advantages of CMOS are that what no one else can provide are its high noise immunity and low static power consumption. CMOS circuits use a combination of P-Type and N-Type MOSFET, so that they can easily implement logic gates and other digital circuits. If seen, CMOS has many such features and advanatages due to which it is often given place in all modern intergrated circuits. So today I thought why should you people also be given complete information about what CMOS means so that you too can get to know about this great technology. Then, without delay, let's start and know what the CMOS is in Hindi. I always try to provide you as much information as possible, so that you will not have to go anywhere else. The full form of CMOS is "Complementary Metal Oxide Semiconducto
Read more

What is a Command Processor?

Do you know what is Command Processor? If not then the answer is that it is of an OS that processes and executes the commands of the users. If you want to get more information about Command Processor then you must read this article. This is because you will not get much information about this term of computer. So today I thought why should you people be given complete information about it so that no one remains in your mind. So without delay, let's start and know in detail about what is the Command Processor in Hindi. This is the part of the operating system that receives and executes the operating system commands. Each operating system has a command processor. When a command prompt is displayed, then this command processor is waiting for one of the commands. When you enter the command, the command processor analyzes the syntax of that command to make sure that the command is valid or not, and then it either executes that command or makes an error warning issue. . What is a compile
Read more