Database Models

Question 1

What are database models

Answer 1

Database models are conceptual models that define the structure, manipulation of data in a database.
They help to organise and optimise our database.

Question 2

Explain Hierarchical Model and Network Model.

Answer 2

Hierarchical Model –> This is the oldest data model and organises data in a tree like format. Each node has exactly one parent, but can have multiple children.

Network Model –> This is the advanced version of Hierarchical model, since it uses directed graphs instead of trees. Each node can have multiple parents and children. Works on two datasets, sets and records.

Question 3

Explain Relational Mode.

Answer 3

Unlike Hierarchical model, there aren’t any physical links present.
This model strictly works on tables. It deals with just the data, not the physical structure. This provides data independence.