Famous people say the darndest things!
Songs Music Lyrics
Lists of US Patents
Article Search
Most Recent Articles

Melrose Jewelers UK Announces 2008 Preowned Rolex Standards Awar...
Category:

What is involved in Website Optimisation?
Category:

The pleasure of visiting Blackpool
Category:

Zimbabwe's Mugabe Says Opposition Must Accept Him as President
Category:

How To ?Cross-Sell? And ?Sell Up? Over The Telephone
Category:

Condition Your Hair For Less
Category:

Tantalizing Headlines: Do's and Don'ts
Category:

Sell More Books With Your Sparkling Introduction
Category:

How to find a Professional Advisor that is right for you?
Category:

How to Generate Extra Cash in an Instant
Category:

The Reality Of Free
Category:

Generating Website Traffic with Sub-domains
Category:

Home Based Business Entrepreneur: The Five Faces of Fear - Your ...
Category:

Online classified ads and their benefits
Category:

Historic Cumberland - A Step Back in Time
Category:

Let Your Fingers Be Your Physician!
Category:

Get Off Your Butt and Create Your Financial Future Now!
Category:

Teddy Bears Aren't All Cute Cuddly Toys
Category:

Tylers Lock - Wedding venue extraordinaire reborn from the ruins...
Category:

Turn emails into dollars - with one word!
Category:

GROW YOUR BRAND ASSETS
Category:

Sick And Tired Of Feeling Sick And Tired??
Category:

Life Can Seem Unfair......Until We Change Our Perspective! See H...
Category:

How To Save 1/3 off Your Grocery Bill
Category:

CRACKING THE BILLABLE HOURS CEILING
Category:

MAKE YOUR WEB SITE WORK MORE SO YOU CAN WORK LESS
Category:

UNDERSTANDING THE CORPORATE BUYER
Category:

No Place Like H.O.M.E.
Category:

Questions To Ask Employees You Want To Retain
Category:

7 Tips to a Top Site
Category:

Your Most Valuable Asset
Category:

5 Deadly Effective Sales Letter Profit Boosters You Can Use Now!
Category:

Oriental Diagnosis - Find out the state of your health BEFORE il...
Category:

How To Make More Money With Affiliate Programs
Category:

How To Use PDF Files On The Web
Category:

Offshore Software Development India
Category:

10 Tips For Getting More Traffic From Your Articles
Category:

Writing Suitable Copy for the Press
Category:

How To REALLY Use Google Part One
Category:

How To REALLY Use Google Part Two
Category:

"Time Keepers and Clock Makers"
Category:

Good Web Design: The Importance of Navigation
Category:

Are You Making These Mistakes With Your Affiliate Program?
Category:

Do Not Call Registry is Just the 1st Step
Category:

The Truth About Public Relations
Category:

The Best Beach Resorts in Bulgaria
Category:

Why Losing Weight Should Not Be Your Ultimate Goal
Category:

Professional Intervention in the Family Business
Category:

Brand Equity - Worth Safeguarding
Category:

Sound Like Your Situation?
Category:

Local Pool Leagues
Category:

Why Pay For Information Its All Over For Free
Category:

Finally an answer to MLM failure
Category:

Ask For A Better Price
Category:

Read E-mail
Category:

Do Not Call Loop Holes
Category:

Ten Easy, Yet Powerful way to get in the spirit to date again af...
Category:

The Emergence of Internet
Category:

Olympic Organizers Report High Demand for Opening Ceremony Ticke...
Category:

5 Critical Promotion Mistakes People Make With Articles
Category:

The Anti-Spam Zealots who went to the FTC Spam Forum
Category:

One American City Defies THE Rule
Category:

Learning the Lessons of the Pray-to-Succeed Strategy
Category:

Back It Up or Lose It
Category:

Start doing online business using B2B Portals in Six Steps
Category:

Israeli and Palestinian Leaders Try to Narrow Differences
Category:

Effective methods of doing business online!
Category:

Six components of a good e-commerce site
Category:

Web Store - Why Do You Need One?
Category:

Making Summer Friendships Last
Category:

Top 10 Tips for Starting A Successful Networking Business
Category:

Jaguar Cars-Think Robert McCarthy for restoration
Category:

Jaguars-Classics to cherish. Go here to cherish them.
Category:

Doubting Your Way To Success!....Ridiculous.....Oh?
Category:

Solving the "I Get Tons of Traffic But No Sales" Mystery
Category:

Cultivating Your Pathway to Success: Don?t Leave Your Company?s ...
Category:

How To Boost Your Keyword Density On Your Web Site To Gain Top P...
Category:

7 ways to keep web development costs down
Category:

When the Snow Melts the Fun is just Beggining
Category:

Function Modelling - What Is It
Category:

The Nasty Truth About Mutual Funds Investing
Category:

"Even if you are on the Right Track, You're Probably Going to Ge...
Category:

How to become the million dollar athlete?
Category:

How To Use Articles To Build Your Affiliate Program
Category:

Generate 33% More Job Interviews with this Powerful Letter
Category:

How To Give Your Home More Space, Part 2
Category:

A Time of Self Healing, Hope and Reflection
Category:

How The ?Product Life Cycle? Can Kill Your Online Business
Category:

It's Just Common Sense!
Category:

Build A Business, Not Just A Practice
Category:

7 Ways to Easily Network
Category:

Don't Loose Your Head over Health Care Worries
Category:

The Fear of Feeling
Category:

A SCAM WARNING: PLEASE PASS THIS ON TO YOUR FRIENDS AND LIST!~!!...
Category:

How To Target Your Market
Category:

Interviews don't have to be...scary.
Category:

Shoes Gone Astray
Category:

Egypt Begins Closing Gaza Border
Category:

How To Promote Your Home Business With Ebooks
Category:

Can Christians Be Capitalists
Category:

Meeting Jesus In Meditation
Category:

How Healers Can Prevent Healing
Category:

Why People Are Not Healed - And How To Prevent It
Category:

Who Lives Your Life?
Category:

7 Steps to Developing Leaders
Category:

Expand Your Horizons
Category:

How to Increase Those "YES!" Moments
Category:

Take Advantage of Today’s Sub-Prime Mortgage Squeeze
Category:

Bridge Your Way To A Better Life
Category:

b>Is Your Ability to Buy Dietary Supplements, Herbal Preparation...
Category:

Effective e-Sales Copy
Category:

How To Stop Your Site Disappearing Into The Void
Category:

Hiring the services of a SEO professional could make a great dif...
Category:

EMAIL OVERLOAD. Taking The Overwhelm Out Of Email
Category:

FILING: How To Find What You Need When You Need It
Category:

HELP FOR ROAD WARRIORS. Ten Tips To Simplify Travel
Category:

Why Is Your Home Cluttered?
Category:

The Wild Wild Web
Category:

The ADD Child: Challenging Parents, Teachers and Friends
Category:

How To Pick An IT Consultant
Category:

Holistic Health
Category:

Creating Your Own Website For Free
Category:

Virtual Hospitality - The Quest For Free, High-Quality, Webhosti...
Category:

Proven Pricing techniques
Category:

The New Wave of Multi Level Marketing
Category:

Ways To Find A Successful Home Business
Category:

How to Eliminate Your Competition By Making Money From Them
Category:

It Takes A Lot Of A Little To See The Good Times Roll
Category:

A Brief Message of Hope
Category:

Smart Marketing
Category:

How To Write A Mission Statement
Category:

Time to Rate Last Year's Search Engine Predictions
Category:

Are You Walking the Talk?
Category:

Choosing Simple And Easy To Install Security Cameras
Category:

How to Make Cleaning a Kitchen Easy
Category:

Choosing Security Guards To Safeguard Our Lives And Our Possessi...
Category:

The Next Generation Of Entrepreneurs
Category:

IDEAS ? a framework for e-business Success
Category:

What you need to know about toll free calls part 2
Category:

Get More Clients using Pull then Push Marketing
Category:

On the go with your laptop
Category:

It Truly Is a "World-Wide" Web
Category:

STOP Telemarketers Dead In Their Tracks
Category:

3 Better Ways To Search Online
Category:

"The Importance Of Sales Copy"
Category:

Successful Small Businesses Use PR
Category:

How One Simple Concept Can Increase Your Sales
Category:

Link Building For Top Search Engine Placement - StepForth Search...
Category:

TrekShare - Crashing a Laos Wedding - Part 2
Category:

ANY BREAK IS A GOOD BREAK
Category:

Fine-tune Web Research with Toolbars
Category:

Women And "Bad Boys": What Is The Attraction?
Category:

Mind Tricking Sales Letters
Category:

4 QUESTIONS TO ASK ABOUT YOUR BUSINESS BEFORE YOU ADVERTISE
Category:

How To Tell Sadness From Depression
Category:

Are Banner Ads Worth It? The statistics tell the tale.
Category:

Powerful Email Strategies
Category:

Can YOU Make a Difference?
Category:

Stretching Your Marketing Dollars--7 Cheap and Easy Ways to Mark...
Category:

Business Like Image
Category:

Where is the Best PR Value?
Category:

A Strategic Fifth Column
Category:

Towards a Strategy of Prevention
Category:

The Sink Or Swim Approach To Leadership
Category:

Adventure Land: Fantasy Action Adventure Book is Almost Ready
Category:

How to Follow Up For Success
Category:

What Skills Really Matter Online?
Category:

Where does your security lie? part two (2)
Category:

What Does 21st Century Success Look Like?
Category:

How to Overcome Emotional Eating
Category:

KANCHANABURI :The Perfect Getaway From Bangkok
Category:

How (NOT) to Buy Mutual Funds
Category:

Storytelling - The Great Motivator of People
Category:

Distribute Your Self-Published Book (Part 1)
Category:

Produce More Sales from your Email Promotions: Five Ways (Part 1...
Category:

Web	LinkGrinder.com

Top Breaking News
     Zimbabwe's Mugabe Says Opposition Must Accept Him as President by VOA News
     Bush Expects Miracles at New Walter Reed Medical Facility by Ravi Khanna
     Explosion at Belarus Concert Injures At Least 50 by VOA News

The Database Design Alalysis - Business perspective

The Database Design Analysis phase - Where it all starts.

By Alf Pedersen Category: 0

Submit your Articles Here!

The Database Design Analysis phase - Where it all starts.

The business perspective

The analysis phase of our database design website deals with the early stage of a business system lifecycle. This is the phase we enter after strategic requirements are in place: The scope of the system, key technical requirements, and the tools for each stage of development, etc. is decided. Economics are most likely also determined.

We may also (most likely) have a rudimentary information model, and we know about key functionality that is required. The main purpose of the analysis phase is to bring all these pieces together to form a business model containing all entities with their attributes, domains and relations, together with a complete function model with its hierarchy, as well as domain constraints (on attributes), business rules (constraints), and events that trigger functions. The output of the analysis stage will be carried over to the design phase of the development project.

The one most important thing to remember in the analysis phase is: Our scope is to determine WHAT should be made, not HOW.

In many projects, I have overheard participants starting to talk about how a given function should behave Colors, buttons, defaults etc. However, all of that belong to the design phase. You have to stop this at once: The analysis phase is about the BUSINESS, not the SYSTEM. The system shall reflect the business, not the other way around, as sometimes unfortunately happens.

Actually, the analysis phase is an excellent time (and the right time) to learn the business in-depth. I do not insist that you know the business in detail. The business itself knows its business. Therefore, your chances of failure are high without business participation. On the other hand, I have witnessed failure in projects where the business wanted to control the whole process alone, and just use 'hired hands' to execute their demands. A balance has to be established.

As with many other things in life, neither to little nor too much of a thing is a good thing.

'Good judgments are based on experience. Experience is based on bad judgments'.

The importance of a professional Database analysis team.

The complexity and degree of computer involvement in the business is constantly growing. No wonder; each 18th month, we can buy hardware with twice the performance at the same price. We are therefore able to put more demands on our software, until we reach some limit. However, it only takes another 18 months; then we can buy new hardware without these limits... and so on.

There is also a good reason for it: We may very well rely on a standard system for our accounting or payroll routines, we can use market standards in word processing and spreadsheets, and so on. What separates a high-performing business from a failure is the way the CUSTOMER is reached for, and how he is treated. That is customer marketing and customer care. The customer is always the business. If you do not have customers, you do not have a business.

If such a business exists,however, please let me know.

Such systems, systems that give the business an advance compared to its competitors, we may call strategic systems. If two businesses buy the same strategic system from the shelf, then they do not gain any system advantage towards each other. On the other hand, the business that is fastest to respond, and deliver, and at the same time is competitive, will definitely have an advantage. In a world with rising competition and globalization, this will grow more and more important. Good news for the software industry and the analysis team...

In the analysis stage, we need an analysis team of both business experiences as well as experienced system analysts. In addition, we need tools that can help us seeing the overall picture, as well as helping us further forward.

Top business experience is required in the analysis team in order to get in-depth understanding of the business itself.

Remember: Our model, at this stage in development, must reflect the business, not some constraints given by any tool or personal preferences. This happens all too often and usually with not-to-good results.

In the analysis team, the system analysts must have an expert level knowledge of business modeling. By business modeling, I mean exactly that. I do not mean expert knowledge of f.i. Entity Relationship modeling without relating it to the real world. However good a person may be educated, nothing beats the experience earned from several similar tasks at the equivalent level of complexity. How does one gain experience then? Participate under a tutor. I would never hire a consultant without experience and trust her to understand the complexity of my business, all by herself.

I will not go into detail as to the total project staff is composed. This will depend on many outside factors, such as degree of participation from each party, size of the project, formal requirements (public sector tends to require at higher level of project staffing, partly due to rigorous documentation requirements), etc. What we focus on is the tightly performing party that determines the final business model: The experts on the business together with the system analysts, preferably more than one in this phase.

Due to the increasing complexity that tends to be taken into systems development, I cannot imagine a development project of any noticeable size that should not use a development tool as support for the analysis team as well as for each stage other of development. I regard the tool(s) chosen as an integral part of the team. In many cases, the tool is also the communicator between the business and the analyst. I have often started a project by going through the way we communicate with each other. In my experience, the business soon finds Entity Relationship diagrams familiar, if not as familiar as to the system analysts. However, they are a means of communication that work. The same may be said for function diagrams, or function hierarchies. They are even easier to understand for a non-system person.

That is why the eBook on ?Entity Relationship Modeling ? Principles? is in the writing, and soon will be published on this site as a free eBook, which you are free to use in your ongoing or upcoming projects.

As for choice of modeling tool, I give no concrete recommendations: I have used Oracle Designer (formerly Oracle CASE*Method) for the last 15 years, and I have found it to be a powerful and rich system, which delivers in many more areas than I have needed to use it for. I am probably a little biased here.

However, a toolset should include reusable objects: The results from the analysis phase should be the basis for generating tables and all other database objects for use in the design phase, as well as functions should be used for generating candidate modules. Furthermore, the database objects and candidate modules should be used to generate the DDL (Data Definition Language) scripts for physically building all the elements of the database, as well as the candidate modules should be used to generate running program modules. Not that I expect a system to be 100% generated ? far from it. However, with such functionality you could show a prototype, which illustrated the resulting, needed functionality, but without the last finishing touch or the most advanced business constraints built into it.

For more visualization of this article, visit http://www.databasedesign-resource.com

About the Author

The author has spent the last 15 years as a system analyst in manufacturing, government, private corporations and broadcasting, performing database analysis and design, based on Oracle Designer and Developer tools.

Return to Last Page

Homepage
Articles
DVD's
Member Login
Add Your Link
Edit Your Link
Contact Us
Image Hosting
Advertising
Disclaimer

Auctions - eBooks - Maps - Banner Links - Software - Weather - Music - Movies - TV

	Add Your Site · Terms Of Service · Privacy Policy

DISCLAIMER

	Follow The Bill is a free service that searches the Internet and indexes all files found so that you may search quickly and easily for shared files. These files are created and made available individually by users whose identity we are not aware of and who we have no control over. In essence we function like a search engine tool; these files ARE NOT STORED OR SERVED BY OUR NETWORK. We are not responsible for any materials obtained by using our service. We do not monitor any of the contents of these files. These files may contain viruses, illegal materials, materials inappropriate for minors, offensive files and the like. BY USING OUR SERVICE, YOU ASSUME FULL RESPONSIBILITY FOR DOWNLOADING THESE MATERIALS AND WILL INDEMNIFY US FOR ANY DAMAGES THAT MAY BE INCURRED. For More Specific Information VIEW OUR TERMS OF SERVICE. Thank you and Enjoy!