DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Lack of standards
|
|
|
Requires knowledge of physical data storage characteristics
|
|
|
Navigational system requires knowledge of hierarchical path
|
|
|
With data definition
|
|
|
Implementation limitations
|
Detailed explanation-1: -The main disadvantage of the hierarchical model is that it can have one-to-one and one-to-many relationships between the nodes.
Detailed explanation-2: -Efficiency: It is very efficient because when the database contains a large number of 1:n relationship and when the user require large number of transaction. Large base with a proven technology. Disadvantages: Implementation complexity: While it is simple and easy to design, it is quite difficult to implement.
Detailed explanation-3: -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.