What is DBMS, Advantages & Disadvantages of dbms - BCA Notes

If you guys are searhing for the dbms notes for BCA then you should check out our post here in this post we add all related topics for dbms so if you are a BCA student then you should read our post till the end.

dbms notes for bca

What is DBMS

The full name of DBMS is Database Management System, DBMS is software that is used to create a database and manage that database, DBMS allows its users to Create, Retrieve, update, and manage data in a systematic way to provide the facility.

A database is a collection of related data, stores the database data in such a way that users can easily access, update and manage it.

You must have understood what is DBMS, so let's read further.

Types of DBMS

There are 3 types of DBMS. Which is as follows:-

• Relational Hierarchical
• network
• hierarchical

1. Relational Model

• In this model, data is stored in a relation means table and each relation has a Row and Column.

• There is a collection of Relational Model Tables in which the data and relationship are specified.

• The data that is in the relational model is stored in a two-dimensional table.

• We know that a table is also called a relation and we call a row of each table a Tupple and a column an attribute.

Tuple represents Entity

Some popular relational DBMSs are- DB 2, oracle, SQL server, RDBMS etc.

Advantage Of the Relational Model

• A relational database is very flexible, any kind of changes can be made easily in it.

• The concept of the relational database is very simple because in this we store the data in the table.

• A relational database provides data integrity means no users can access the database without the permission of the owner.

Disadvantages of the Relational Model

• It requires powerful computer hardware, storage devices, and software.

• In this, the problem of data inconsistency and data duplication is generated.

2. Network Model

• In the network model, data is organized in the form of a graph.

• There can be more than one Parent Node in it, which means that it has more than one Parent-Child relationship.

• The network model was most commonly used at a time when the relational model was not proposed.

3. Hierarchical Model

There is a parent-child relationship in this model. In this model, each entity has only one parent and many children. There is only one entity in this model which we call root.

Components Of DBMS

1. Tables

All the data in DBMS is kept in Tables. Data Store, Filter, Update, Creating etc. all the work is done on tables only. Tables are made up of Rows and Columns in which data is stored.

2. Field

Each column inside the table is called a field, fields are specified about someone such as Customer Name, Customer Number, Customer Address etc.

3. Record

The row in the table that contains the data is called a record, in the record it is written about the information of a customer, such as what is the name of the customer, what is the number of the customer, what is the address of the customer.

In the fields which are there, it is written that what can be written about a customer and entries are made about it in the record.

4. Queries

Extracting any type of data from the tables of the database is called Query, like if you want to extract the list of Employees living in the same city, then it will be called Query.

5. Forms

If you store data in tables, then it is not easy to store and revise it, so Forms are used to overcome this problem, it is easy to store data in forms and in forms also tables can be used. Data is stored in the same way.

6. Reports

When you print the records of the database on On Paper, it is called a report.

Advantage Of DBMS

1.Controlling Data Redundancy

In File Based System, each application program has its own private file, in this condition duplicate file of the same type of data is created at many places, in DBMS all the data of an organization is stored in a database file that means data It is stored at only 1 place in the database and is not repeated.

2. Data Consistency

Data Consistency is achieved by controlling Data Redundancy That Means the same type of data is prevented from being stored repeatedly in the database.

3. Integration Of Data

Data in DBMS is stored in tables and there is more than one table in a database and relationships can be created between these tables.

4.Data Security

Data in DBMS is completely controlled by the Administrator and only the database Administrator ensures which user has to give access to the database.

5. Recovery Procedure

A computer is a machine, then it is certain that there may be a problem in the hardware or software of that computer, so it is very important that if we can recover the data of that computer, then this work can be done easily with DBMS.

Conclusion

Here in this post, we add all related information about the introduction of DBMS and the advantages of DBMS, types of DBMS, characteristics of DBMS, and many more so if you are a BCA student and searching for the DBMS notes for BCA then you should read our post till the end.