Exam 2: Data Models

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

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

Which of the following is true of NoSQL databases?

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

What are the sources of business rules, and what is the database designer's role with regard to business rules?

An internal _____ refers to a specific representation of an internal model, using the database constructs supported by the chosen database.

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

Which of the following is true of business rules?

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

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

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

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

A(n) _____ is the conceptual organization of an entire database as viewed by a database administrator.

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

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