Chapter 2 Review

The hierarchical model is software-independent.

The hierarchical data model was developed in the _____.

The _____ data model uses the concept of inheritance.

_____ are normally expressed in the form of rules.

The external model is the representation of the database as "seen" by the DBMS.

Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories.

The relational model is hardware-dependent and software-independent.

Which of the following is true of NoSQL databases?

A(n) _____ represents a particular type of object in the real world.

A(n) _____ enables a database administrator to describe schema components.

In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored.

Today, most relational database products can be classified as object/relational.

A data model is usually graphical.

_____ are important because they help to ensure data integrity.

An implementation-ready data model should contain a description of the data structure that will store the end-user data.

The object-oriented data model was developed in the _____.

A noun in a business rule translates to a(n) _____ in the data model.

Within the database environment, a data model represents data structures with the purpose of supporting a specific problem domain.

In the _____ model, the basic logical structure is represented as an upside-down tree.

Database designers determine the data and information that yield the required understanding of the entire business.

A(n) _____ is the equivalent of a field in a file system.

Oracle 12c, MS SQL Server, and Tamino are examples of _____ data models.

MySQL is an example of the _____.

A(n) _____ is anything about which data are to be collected and stored.

VMS/VSAM is an example of the _____.

Each row in the relational table is known as an entity instance or entity occurrence in the ER model.

Which of the following types of HDFS nodes acts as the interface between the user application and the HDFS?

A(n) _____ is a restriction placed on the data.

Which of the following types of HDFS nodes stores all the metadata about a file system?

The _____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.

Which of the following is true of business rules?

An implementation-ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data.

Students and classes have a _____ relationship.

In the _____ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent.

The network model has structural level dependence.

A(n) _______ enables a database administrator to describe schema components.

The relational data model was developed in the _____.

In an SQL-based relational database, each table is dependent on every other table.

A(n) _____ is bidirectional.

In Chen notation, entities and relationships have to be oriented horizontally; not vertically.

The _____ model uses the term connectivity to label the relationship types.

In the _____ model, each parent can have many children, but each child has only one parent.

Business rules must be rendered in writing.

A(n) _____'s main function is to help one understand the complexities of the real-world environment.

A disadvantage of the relational database management system (RDBMS) is its inability to hide the complexities of the relational model from the user.

A verb associating two nouns in a business rule translates to a(n) _____ in the data model.

Even when a good database blueprint is available, an applications programmer's view of the data should match that of the manager and the end user.

The _____ data model is said to be a semantic data model.

M:N relationships are not appropriate in a relational model.

In an SQL-based relational database, rows in different tables are related based on common values in common attributes.