{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chapter 06 - Chapter 6 Developing Data Models for Business...

Info icon This preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 6 Developing Data Models for Business Databases
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
6-2 Outline Guidelines for analyzing business information needs Transformations for generating alternative designs Finalizing an ERD Schema Conversion
Image of page 2
6-3 Characteristics of Business Data Modeling Problems Poorly defined Conflicting statements Wide scope Missing details Many stakeholders Requirements in many formats Add structure Eliminate irrelevant details Add missing details Narrow scope
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
6-4 Goals of Narrative Problem Analysis Consistency with narrative No contradictions of explicit narrative statements Identify shortcomings Ambiguous statements Missing details Simplicity preference Choose simpler designs especially in initial design Add refinements and additional details later
Image of page 4
6-5 Steps of Narrative Problem Analysis Identify entity types and attributes Determine primary keys Add relationships Determine connections Determine relationship cardinalities Simplify relationships
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
6-6 Determine Entity Types and Attributes For entity types, find nouns that represent groups of people, places, things, and events For attributes, look for properties that provide details about the entity types Simplicity principal: consider as an attribute unless other details
Image of page 6
6-7 Determine Primary Keys Stable: never change after assigned Single purpose: no other purpose Good choices: automatically generated values Compromise choice for industry practices Identify other unique attributes
Image of page 7

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
6-8 Entity Identification Example
Image of page 8
6-9 Identify Relationships Identify relationships connecting previously identified entity types Relationship references involve associations among nouns representing entity types
Image of page 9

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}