DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Nouns translate into entities
|
|
Nouns translate into relationships among entities
|
|
Verbs translate into relationships among entities
|
|
Verbs translate into entities
|
Detailed explanation-1: -How do you translate business rules into data model components? As a general rule, a noun in a business rule will translate into an entity in the model, and a verb (active or passive) associating nouns will translate into a relationship among the entities.
Detailed explanation-2: -A business rule is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization. Properly written business rules are used to define entities, attributes, relationship, and constraints.
Detailed explanation-3: -Data-driven business rules are constraints on particular data values. These constraints need to be true, regardless of any particular processing requirements. Analysts define these constraints during the data design stage, rather than during application design.
Detailed explanation-4: -An ERD visualizes the relationships between entities like people, things, or concepts in a database. An ERD will also often visualize the attributes of these entities. By defining the entities, their attributes, and showing the relationships between them, an ER diagram can illustrate the logical structure of databases.
Detailed explanation-5: -Business rules will help define what data is kept, how hierarchical relationships between entries will be defined and data security. Business rules in the context of database design are fundamentally unique.