Modeling Data in the Organization

Question 1

A GOOD DATA NAME IS

Answer 1

Related to business, not technical, characteristics
Meaningful and self-documenting
Unique
Readable
Composed of words from an approved list
Repeatable
Written in standard syntax

Question 2

Data definitions

What is a term and a fact

Answer 2

Term–word or phrase with specific meaning
Fact–association between two or more terms

Question 3

What is an Entity?

And Entity Type

Answer 3

Person, place, object, event, concept (often corresponds to a row in a table.

Collection of entities

Question 4

What is a Relationship instance

Answer 4

link between entities (corresponds to primary key-foreign key equivalences in related tables)

Question 5

Attributes

Answer 5

Properties or characteristics of an entity or relationship type (often
corresponds to a field in a table)

Question 6

Enumerate Business Rules

Answer 6

Are statements that define or constrain some
aspect of the business
Are derived from policies, procedures, events,
functions
Assert business structure
Control/influence business behavior
Are expressed in terms familiar to end users
Are automated through DBMS software

Question 7

A good business RULE IS

Answer 7

Declarative–what, not how
Precise–clear, agreed-upon meaning
Atomic–one statement
Consistent–internally and externally
Expressible–structured, natural language
Distinct–non-redundant
Business-oriented–understood by
business people

Question 8

Whats an Entity instance?

Answer 8

Single occurrence of an entity type

Question 9

An Entity Should be

Answer 9

An object that will have many instances in the
database
É An object that will be composed of multiple
attributes
É An object that we are trying to model

Question 10

An Entity SHould not be

Answer 10

user of the database system
É An output of the database system (e.g., a
report)
12