Question

What are the three types of database design situations?

Answer 1

There are many types that exist in database design.

1.Relational Database model :  

It is a database management system for managing the data .In this database the records are related to each other through some logic that is why it is called Relational Database model.In this model every row represents a record and column represent the fields that exist in the table.It is highly used in every organization because of it's simple structure.Here all the data is represented in terms of tuples.In relational database management system data is stored in a form of table.

2.Network model :

It is a flexible database model to represent easy relations between the objects.The objects here are related by some relationship based on the context given to them.In the network model , there is a term called graph.It is kind of structure which is used to structure the objects in the network model. There is a concept called schema which is used to view it's data in high level.Compare to Hierarchical Database model it is very flexible model. We can even represent the many to many relationships easily.

3.Hierarchical Database model

The data here is organized in tree data structure.Data here in one node is connected to other node through some relationships.here a record is a collection of field.Here each field contains only one value.So there is no chance of many to many relationships here.This is the drawback of Hierarchical Database model .Only one-to-one and one-to-many relationships are exist .