Question

Describe the importance of databases and database management systems in managing organizational data and information. Include in your discussion the types and some examples of database management systems. Also, address the advantages and disadvantages of using a DBMS.

Answer 1

Databases

Collection of data is called Databases. Everything in this world is connected in one way or another to each other. In database we can show the relation among them.That's why databases are very important. In an organization we need data of everything , from the data of person working there to the data of the work he is handling. So we create an organized data from this and shows their relationship which is called database.Thus it helps in easier management of everything and thus increased efficiency.

Database Management System(DBMS)

To manage these databases physically is a heptic and difficult task. Thus here comes Database Management System with which we can handle all the data and make databases and handle them easily. These are softwares which provide security to the database. Organizations have to protect all the data and also have to handle and manage the data effeciently. So they use DBMS for these tasks. These allows the organizations to create or manage databases easily as per their rquirements.

Types of DBMS

Hierarchical :- In this data is organized like a tree structure. Here each child have only one parent.

Network:- In this model each child can have multiple parents. It is used when there are many to many relationships.

Entity- Relationship Model:- This is based upon entity and its attributes. Here nodes are represented with entities and their properties as attributes.

Here Student is entity and Name,Department,Roll No. are its attributes.

Relational Model:- In this model tables are used and all the data is stored in these tables and relationship among them is maintained using common field which is called primary key. Eg Roll No. is a primary key here in this example.

Examples of some famous DBMS are: Oracle, MySQL, SQL SErver, Google Firebase.

Advantages

It decreases time to manage data thus increases efficiency of an organization.

High security of data.

Various tools to store and manage data.

Can decide who can have access to the data.

Disadvantages

Complex system so need professionals to maintain.

Cost of software is high.

Not efficient for smaller organizations as maintenance cost is also high.