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 41

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

The main sources of business rules are c...

View Answer

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following is true of business rules?

A) They allow the designer to set company policies with regard to data.
 
B) They allow the designer to develop business processes.
C) They can serve as a communication tool between the users and designers.
 
D) They provide a framework for the company's self-actualization.

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

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

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

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

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

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

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

Which of the following is true of NoSQL databases?

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

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

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

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

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

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