Course Number: 1609A

Microsoft, MS-DOS, MS, Windows and Windows NT are either registered trademarks or
trademarks of Microsoft Corporation in the U.S.A. and/or other countries.

The names of companies, products, people, characters, and/or data mentioned herein are fictitious
and are in no way intended to represent any real individual, company, product, or event, unless
otherwise noted.

Other product and company names mentioned herein may be the trademarks of their respective
owners.

Project Lead: Janet Robinson, Mark Bader
Instructional Designers: Mark Bader, Shawn Lock, Michas Sadzak
Program Managers: Mark Bader, Rama Biswas, Teresa Canady
Subject Matter Experts: Mark Bader, Whitney Roberts (KiZAN Corporation), Janet Robinson,
Scott F. Wilson (KiZAN Corporation)
Graphic Artist: Elizabeth Johanson (ArtSource, Inc.)
Editors: Joyce Cox (Online Training Solutions, Inc.), Todd Duft (Write Stuff), Elizabeth Hui
Reese (Write Stuff)
Testers: Chris Baca (Digital Counterbalance), Rick Carr (Digital Counterbalance)
Production Support: Linda Lu Cannon (Write Stuff), Marlene Lambert (Online Training
Solutions, Inc.), Eric Wagoner (Write Stuff)
Manufacturing Support: Julie Challenger, John Williams
Product Manager: Ron Wodaski
Business Manager: Roger Gerdes
Authors: Mark Bader, Whitney Roberts (KiZAN Corporation), Janet Robinson, Scott F. Wilson
(KiZAN Corporation)

Course Number: 1609A
Part Number: X04-99424

Services-Based Design.......................................................................................... 34
The MSF Application Model ........................................................................... 35
Logical Network of Cooperating Services....................................................... 36
Data Services ................................................................................................... 37
Examples of Services....................................................................................... 38
Benefits of Services-Based Design .................................................................. 39
Activity 2.1: Identifying Services .................................................................... 40
Review .................................................................................................................. 41
Guidelines ........................................................................................................ 42
Review Questions ............................................................................................ 43
Looking Forward ............................................................................................. 44
Module 3: Using a Conceptual Design for Data Requirements
Overview............................................................................................................... 47
Investigation Process............................................................................................. 48
Gathering Information ..................................................................................... 49
Analyzing Information..................................................................................... 50
Creating Use Cases .......................................................................................... 51
Data Requirements................................................................................................ 52
Characteristics of Data Requirements.............................................................. 53
Categories of Data Requirements .................................................................... 54
Identifying Functional Data Requirements ...................................................... 56
iv Contents Identifying Nonfunctional Data Requirements ................................................ 57
Activity 3.1: Identifying Data-Related Use Cases and Data Requirements..... 58
Validating Data Requirements ......................................................................... 59
Activity 3.2: Relating Data Requirements to Conceptual Design......................... 60
Review .................................................................................................................. 61
Guidelines ........................................................................................................ 62

Primary Keys ................................................................................................... 98
Foreign Keys.................................................................................................... 99
Examples of Primary and Foreign Keys ........................................................ 100
Activity 5.1: Identifying Keys in the Logical Model..................................... 101
Normalization Basics .......................................................................................... 102
Normalizing Logical Models ......................................................................... 103
Creating a First Normal Form Data Model .................................................... 105
First Normal Form Example .......................................................................... 106
Moving to a Second Normal Form Data Model............................................. 107
Creating a Third Normal Form Data Model .................................................. 108
Third Normal Form Example......................................................................... 109
Benefits of Normalization.............................................................................. 110
Contents v
Activity 5.2: Normalizing Data...................................................................... 111
Review ................................................................................................................ 112
Guidelines ...................................................................................................... 113
Review Questions .......................................................................................... 114
Looking Forward ........................................................................................... 115
Module 6: Deriving a Physical Data Design
Overview............................................................................................................. 119
Physical Data Design .......................................................................................... 120
Describing a Physical Data Model................................................................. 121
Identifying Database Tables and Fields ......................................................... 123
Common Data Types ..................................................................................... 124
Implementing Relationships................................................................................ 125
Implementing One-to-One Relationships ...................................................... 126
Implementing One-To-Many Relationships .................................................. 127

Review Questions .......................................................................................... 166
Looking Forward ........................................................................................... 167
Module 8: Designing Data Services
Overview............................................................................................................. 171