DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Conceptual simplicity
|
|
|
System complexity limits efficiency
|
|
|
Data access is flexible
|
|
|
Handles more relationship types
|
|
|
Navigational system yields complex implementation, application development, and management
|
Detailed explanation-1: -The disadvantages of network model are as follows: Database contains a complex array of pointers. System complexity limits efficiency. Structural changes require changes in all application programs.
Detailed explanation-2: -The main advantage of the network model is the ability to address the lack of flexibility of the hierarchical model, of which it is supposed to be a direct evolution. In the network model, each child (called “member”) can have more than one parent (called “owner”) to generate more complex, many-to-many relationships.
Detailed explanation-3: -The network database model allows records from more than one table to be associated with a single owner record of another table. This provides a definite advantage over the relational counterpart when querying results from multiple foreign-key tables associated with one primary-key table.