Advantages and Disadvantages of Database Management Systems

This set of flashcards covers the key advantages and disadvantages of different types of database management systems.

One advantage of hierarchical database management systems is that they provide __ storage diagrams/structure.

Simple

A disadvantage of hierarchical database management systems is that they are limited to more __ data relationships.

simple

Network database management systems allow the use of __ relationships.

many-to-many

A characteristic of object-oriented database management systems is their ability to manage __ data structures.

complex

Relational database management systems can prevent __ redundancy.

data

One disadvantage of relational database management systems is that their administration can be __ consuming.

time

A key advantage of relational database management systems is that they use a logical structure of __ and primary keys.

entities

One limitation of object-oriented database management systems is that they are limited to being used with __ languages.

OOP

A disadvantage of network database management systems is that their designs can get very __.

complicated

One advantage of database management systems is that they store data __.

efficiently