PrepAway - Latest Free Exam Questions & Answers

Which type does the graphic that follows illustrate?

There are several different types of databases. Which type does the graphic that follows illustrate?

PrepAway - Latest Free Exam Questions & Answers

A.
Relational

B.
Hierarchical

C.
Network

D.
Object-oriented

Explanation:
B: A hierarchical database uses a tree-like structure to define relationships between data elements, using a parent/child relationship. The structure and relationship between the data
elements are different from those in a relational database. The tree structure contains branches, and each branch has a number of leaves, or data fields. These databases have welldefined,
prespecified access paths, but they are not as flexible in creating relationships between data elements as a relational database. Hierarchical databases are useful for mapping
one-to-many relationships.
A is incorrect because a relational database model uses attributes (columns) and tuples (rows) to contain and organize information. It presents information in the form of tables. A
relational database is composed of two-dimensional tables, and each table contains unique rows, columns, and cells (the intersection of a row and a column). Each cell contains only
one data value that represents a specific attribute value within a given tuple. These data entities are linked by relationships. The relationships between the data entities provide the
framework for organizing data.
C is incorrect because a network database model is built upon the hierarchical data model, but instead of being constrained by having to “know” how to go from one branch to
another and then from one parent to a child to find a data element, the network database model allows each data element to have multiple parent and child records. This forms a
redundant network-like structure instead of a strict tree structure. (The name does not indicate it is on or distributed throughout a network, it just describes the data element
relationships.)
D is incorrect because an object-oriented database is designed to handle a variety of data (images, audio, documents, video). An object-oriented database management system
(ODBMS) is more dynamic in nature than a hierarchical database, because objects can be created when needed and the data and procedure (called method) go with the object when it
is requested. In a hierarchical database, the application has to use its own procedures to obtain data from the database and then process the data for its needs. The hierarchical
database does not actually provide procedures, as object-oriented databases do. The object-oriented database has classes to define the attributes and procedures of its objects.

One Comment on “Which type does the graphic that follows illustrate?

  1. joe says:

    A hierarchical database uses a tree-like structure.

    Relational database model uses attributes (columns) and tuples (rows) to contain and organize information.

    Network database model is built upon the hierarchical data model, but instead of being constrained by having to “know” how to go from one branch to
    another and then from one parent to a child.

    Object-oriented database is designed to handle a variety of data (images, audio, documents, video)




    0



    0

Leave a Reply