Question

2. List the four types of DBMS. Which one of these is commonly used database and why​

Answer 1

Answer:

here is ur answer

Explanation:

i) Hierarchical ii) Network iii) Relational iv) Object-Oriented.

Among these databases, the most commonly used database is Relational Database Management System

because multiple tables in RDBMS are related to each other by using common fields.

Answer 2

Answer:

There are four common types of database model that are used . Depending upon the specific needs, anyone of these models can be used.

1. Hierarchical databases.

2. Network databases.

3. Relational databases.

4. Object-oriented databases.

Relational model is one of the most commonly used database model because it is one of the easiest.

Explanation:

• Hierarchical database

Hierarchical database is one of the oldest database model in which the data is organized into a tree-like structure. Its structure is like a tree with nodes representing records and branches representing fields.

• Network databases

Network database model organized  like a graph and it can have more than one parent node.

• Relational Database

In Relational Database model, data is organized in rows and column structure. It consists of few major components -

Attribute:  Attributes are the properties that define a relation.

Tables : In the Relational model the,  the table are referred as relations. It has two properties rows and columns and it is stored along with its entities.  Rows represent records and columns represent their attributes.

Tuple : It is nothing but a single row of a table and it contains a single record.

Relation Schema: A relation schema represents the name of the relation and all its attributes.

• Object-oriented databases

An object-oriented database is a system in which information is represented in the form of objects.  This data model has been created based on the concept of object-oriented- programming language.

• Relational model is one of the most commonly used database model. In relational model, key terms that are used frequently, are relations, attributes, and domains.

• Relational model can be stored in fixed structures and manipulated using SQL.

• In this model, any changes that is made in the database structure do not affect the data access.
• The relational database supports both data independence as well as structure independence concept. These features make the database design, maintenance, administration and usage much easier.
• we can write complex query in SQL to accesses or modify the data from database.
• Maintain security is easier as compare to other models.

To know more about DBMS, click here ->

https://brainly.in/question/2767821

https://brainly.in/question/30782760