FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Data Models

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

The data model uses the concept of inheritance.

A) relational
B) network
C) object-oriented
D) entity relationship

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

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

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

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

Oracle 11g is an example of the .

A data model is usually graphical.

The hierarchical data model was developed in the .

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

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

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

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

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

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

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

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's foundation is a mathematical concept known as a .

Which of the following is True of NoSQL databases?

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

are important because they help to ensure data integrity.