Hathaway & Associates, Inc. is a Florida-based training and consulting firm

To better serve you,
we have more offerings in

Training, Products, Services, SDLC

Model Business Data

Seminars and Services We Offer to Perform this Process
Techniques We Use and Teach to Support this Step
Other Steps (Activities) We Can Help You With

Model Business Data

We can:

		show you how to do this activity
	with e-mentoring

		teach you how to do this activity
	with our in-house or public seminars

		lead your experts through this activity in an
	interactive JAD or e-JAD

Business data is any information that an organization needs to function. Data modeling identifies which data is essential and defines the context within which your organization uses and maintains the data independent of your system architecture. A data model also identifies how technological decisions restrict your ability to do what you want to do.

Business data modeling
		creates a visual image of the information components that your business needs

		is a starting point for cross-application database design

		enables the business users to assess the technological impact of business decisions

		increases the portability of the delivered solution

		establishes a baseline for communication across functional boundaries

		provides a basis for business-rules definition

		is an integral component of a repeatable development process

When should you model business data?

You should model business data independent of any information system projects. At the latest, do it before you make any information technology decisions.

Who should model business data?

Data analysts, system analysts, system designers, database analysts and business managers have to work together to create a data model.

Entity-Relationship Diagrams

Entity-Relationship diagrams describe the data and the business relationships among the data independent of any implementation approach, technology, hardware or software.

To create a data model,
ask these four questions:

What do you need to store data about? The answers are your entities.
Examples: customer, product, account, etc.

How are these entities related? This will show the relationships among the entities.
Examples: customer buys product, transaction debits account, etc.

What is the nature of the relationship? This will identify the cardinality of the relationship.
Examples: one customer may buy many products, many transactions debit many accounts, etc.

What data do you need to store about the entities and their relationships? This will identify the attributes.
Examples: customer: name, address, phone, etc.

Entities:

Relationships:

Cardinality:

Attributes:

Data Model Rules

Entity Rules:	An entity has to occur many times to be of interest (if there is only one occurrence, it is a constant). Each occurrence of an entity has to have a unique primary key (you have to be able to identify a single instance of the entity in a group of the same entities).
Relationship Rules:	The relationships are created by business transactions. The relationships link the entities involved in the transaction. A relationship should only be represented if you need to track information about the transaction
Cardinality Rules:	Relationships between entities can be: one-to-one one-to-many many-to-many (via intersection entities) In addition, they are either mandatory or optional.
Attribute Rules:	An attribute identifies an entity, resolves a relationship with another entity or describes something about the entity. An attribute belongs to one and only one entity. An attribute can only have a single value for each occurrence.

Data Normalization

Preparation

To start normalization, you need a set of data elements with a name and a primary key.

Apply these three steps to identify the simplest set of attributes (relations) for storing the data elements.

In the end, each relation has to have a name, a unique primary key (P-KEY) and attributes.

Invoice #:
Customer Name:
Service Address:
Account#

Date Due	Amount Due

Date	Svc ID	Description	Amount

Service From:

Service To:

Translate User View into a "Relation"

Name: "Invoice"

Attributes:

P-KEY: Invoice#
Customer Name
Service Address
Account#
Date Due
Amount Due

Date
Svc ID
Description
Amount
Service From
Service To

1st Normal Form

Remove all repeating groups (lines) and create a separate set of attributes (relation). Include the primary key of the original set in this group.
Create a unique key for the new relation by combining the original set's primary key with one or more attributes that make an occurrence of the new group unique. Name the new group.

Each Invoice Can Have Multiple Services

Name: "Invoice"

Attributes:

P-KEY: Invoice#
Customer Name
Service Address
Account#
Date Due
Amount Due

~~Date~~
~~Svc ID~~
~~Description~~
~~Amount~~
Service From
Service To

Therefore We Create a New Relation

Name: "Transaction"
Attributes:	P-KEY: Invoice# P-KEY: Date P-KEY: Svc ID Service Description Amount

2nd Normal Form

Examine the relations that have more than one attribute in their key.
Remove all non-key attributes that describe only part of the key.
Create a separate relation with this part of the key as its primary key and name it.
Do not remove any key attributes from a relation.

The Transaction Relation Has Multiple Keys
The two attributes "Service Description" and "Amount" describe only the Key "Svc ID"

Name: "Transaction"
Attributes:	P-KEY: Invoice# P-KEY: Date P-KEY: Svc ID ~~Service Description~~ ~~Amount~~

Therefore We Create a New Relation

Name: "Service"
Attributes:	P-KEY: Svc ID Service Description Amount

3rd Normal Form

Examine all relations.
Remove all attributes that do not describe the primary key, create a new relation for them with a primary key and a name.
Replace the attributes in the original relation with the primary key of the new relation as a foreign key (F-KEY).
Do not remove any key attributes from a relation.

No Change to the "Service" Relation

Name: "Service"
Attributes:	P-KEY: Svc ID Service Description Amount

This is the Final "Transaction" Relation

Name: "Transaction"
Attributes:	P-KEY: Invoice# P-KEY: Date P-KEY: Svc ID

Customer Name, Account #, and Service Address Do Not Describe the Key "Invoice"

Name: "Invoice"

Attributes:

P-KEY: Invoice#
~~Customer Name~~
~~Service Address~~
F-KEY: Account#

Date Due
Amount Due
Service From
Service To

Therefore We Create a New Relation "Customer"

Name: "Customer"
Attributes:	P-KEY: Account# Customer Name Service Address

Training for the Novice Business System Analyst

Analyzing Business Data (BARE)

Defining Business Data (BARG)

Defining Business Data (BARDTT)

Defining the Project (SPM)

Training for the Experienced Business System Analyst

Analyzing Business Data (BARE)

Designing a Logical Data Model (SYSDEV)

Finding the Right Questions (ABAT)

Managing the Deliverables (JADREQ)

Training for the Expert Business System Analyst

Classifying and Analyzing Business Objects (BAUML)

Modeling Data (SYSDEV)

Understanding (Using) the Business Data (SYSDEV)

Designing a Logical Data Model (SYSDEV)

Managing the Working Session (JADREQ)



	Under Time Pressure?

	Learn how to run an efficient, effective JAD session that does this activity faster. Facilitating Productive JAD Sessions

	Our eMentoring offer is a cost-effective alternative for small groups to learn these and other business system analysis techniques at their own workplace or for follow-up after a training seminar

JAD Sessions for Your Time-Critical Projects

your business
analysis skills

Business Rules Definition

Business Data Modeling

Requirements Gathering

	Analyze Business Problems
	Analyze Business Processes
	Gather Prioritized Requirements
	Design System Architecture
	Develop Quick Fixes
	Engineer Business Processes
	Evaluate Potential Solutions
	Engineer Test Data
	Execute Tests
	Plan Testing Activities

Hathaway & Associates offers training, virtual and in-house services to support a wide range of activities within the system development life cycle all targeted exclusively to the Business Analyst, Requirements Engineer and the Subject Matter Expert.

You can also visit our bookstore for the newest in the business analysis field

Home In-House Training Public Seminars e-Mentoring Consulting FAQ Books

info@theHathaway.com