Session 15

Question 1

Steps when building a decision table

Answer 1

1. Identify Conditions and Values
2. Identify all possible actions
3. List all possible rules
4. Defines actions for each rule
5. Simplify the decision table

Question 2

Whats Data Modeling

Answer 2

Develops missing and crucial piece of the description of an info system

Question 3

Conceptual Data Model

Answer 3

Captures overall structure of organizational data

Question 4

Whats the objective of a conceptual data model

Answer 4

accurately describes the content and structure of data in the client/users world

Question 5

What are the two diff ways to gather info for conceptual data modeling

Answer 5

Top-Down
Bottom-up

Question 6

Whats top down info gathering

Answer 6

Data model is derived from an intimate understanding of the business

Question 7

Whats bottom up info gathering

Answer 7

Data model is derived by reviewing specifications and business documents

Question 8

Whats an ERD

Answer 8

data modeling tool that depicts associations among diff categories of data w/in a business/info system

Question 9

Whats an identifier/primary key

Answer 9

Unique identifiers of each entity

Question 10

Whats an attribute?

Answer 10

Characteristics of an entity

Question 11

How do you choose a PK

Answer 11

• Must be unique
• Must not change over life
• Must always have a valid value