Exam 2: Data Models

The data model uses the concept of inheritance.

A(n) is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.

are important because they help to ensure data integrity.

A(n) in a hierarchical model is the equivalent of a record in a file system.

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 relational model is hardware-dependent and software-independent.

A data model is usually graphical.

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

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.

Oracle 11g is an example of the .

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

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

The hierarchical data model was developed in the .

The relational model's foundation is a mathematical concept known as a .

Describe the conceptual model and its advantages. What is the most widely used conceptual model?

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

A(n) is a relatively simple representation of more complex real-world data structures.

Describe the three parts involved in any SQL-based relational database application.

Which of the following is True of NoSQL databases?