Business Rules

Question 1

when database designers go about selecting or determining the entities, attributes, and relationships that will be used to build a data model they might start by gaining a thorough understanding of what types of data exist in an organization, how the data is used, and in what time frames it is used

Answer 1

Business Rules

Question 2

from a database point of view, _____ becomes meaningful only when it reflects properly defined business rules

Answer 2

collection of data

Question 3

• is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization
• must be rendered in writing and updated to reflect any change in the organization’s operational environment

Answer 3

Business Rule

Question 4

Those business rules establish _____.

Answer 4

entities, relationships, and constraints

Question 5

Sources of Business Rules

Answer 5

• company managers
• policy makers
• department managers
• written documentation

Question 6

Written Documentations

Answer 6

• company’s procedures
• standards
• operations manual

Question 7

As a general rule, a _____ in a business rule will translate into an entity in the model,, and a _____ (active or passive) that associates the _____ will translate into a relationship among the entities.

Answer 7

noun; verb; noun

Question 8

To properly identify the type of relationship, you should consider that relationships are _____; that is, they go both ways.

Answer 8

bidirectional