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 1

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

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

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

The hierarchical data model was developed in the ____.

Each row in a relation is called a(n)____________________.

____ are normally expressed in the form of rules.

End-user interfaces require the end user to manually generate SQL code.

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

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

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

The hierarchical model is software-independent.

When you can change the internal model without affecting the conceptual model,you have ____________________ independence.

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.

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

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

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

The entity relationship model is limited to conceptual modeling,with no implementation component.

Each column in a relation represents a(n)____________________.

Business rules must be rendered in writing.