Topic 2: Data Models

Question 1

It is an abstraction of a more complex real-world object or event

Answer 1

Model

Question 2

It represents data structures and their characteristics, relations, constraints, transformations, and other constructs with the purpose of supporting a specific problem domain

Answer 2

Data Models

Question 3

This refers to the process of creating a specific data model for a determined problem domain

Answer 3

Data modeling

Question 4

The Building Blocks of Data Models

Answer 4

Entities
Attributes
Relationships
Constraints

Question 5

These refer to anything about which data are to be collected and stored

Answer 5

Entities

Question 6

These refer to a characteristic of an entity

Answer 6

Attributes

Question 7

These describes the association among entities

Answer 7

Relationship

Question 8

Three Types of Relationships

Answer 8

One-to-Many
Many-to-Many
One-to-One

Question 9

This is a type of relationship wherein one instance of an entity is allowed to be associated with several instances off the other entity

Answer 9

One-to-Many

Question 10

Several instances of an entity is allowed to be associated with several instances of the other entity

Answer 10

Many-to-Many

Question 11

One instance of an entity is allowed to be associated with one and only one instance of the other entity

Answer 11

One-to-One

Question 12

These refer to restrictions imposed on data

Answer 12

Constraints

Question 13

These refer to the rules that describe the operations, definitions and constraints that apply to an organization

Answer 13

Business Rules

Question 14

Characteristics of a Good Business Rule

Answer 14

• Declarative: statement of policy
• Precise: only one interpretation
• Atomic: no rule stands on its own
• Expressible: stated through structured natural language
• Distinct: not redundant
• Consistent: should not contradicts
• Only business people understand