COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Relational Database
|
|
Hierarchical Database
|
|
Network Database
|
|
Object Oriented Database
|
Detailed explanation-1: -The network model is a database model conceived as a flexible way of representing objects and their relationships. Its distinguishing feature is that the schema, viewed as a graph in which object types are nodes and relationship types are arcs, is not restricted to being a hierarchy or lattice.
Detailed explanation-2: -Types of database models Hierarchical database model. Relational model. Network model. Object-oriented database model.
Detailed explanation-3: -Relational Model (RM) represents the database as a collection of relations. A relation is nothing but a table of values. Every row in the table represents a collection of related data values.
Detailed explanation-4: -Cons of Hierarchical Model Relationships that are complex are not supported. Because it only supports one parent per child node, if we have a complex relationship in which a child node needs to have two parents, we won’t be able to describe it using this model.
Detailed explanation-5: -A hierarchical model represents the data in a tree-like structure in which there is a single parent for each record. To maintain order there is a sort field which keeps sibling nodes into a recorded manner.