![]() |
||
The Analysis Progress - Increasing SpeedAnalysis progressWith the tools of today's technology (laptops, projectors, computer networks and not least, the Internet), the analysis process can take place literally anywhere.Actually, most processes are able to. For all practical meanings, we are more mobile: some parts of the analysis progress may take place at the business office, and other parts at the analyst's office. They can communicate on the net at any time, collaborating outside of formal meetings. No doubt, this is increasing performance in the analysis progress, as well as saving time, and thereby costs. For instance, sometimes I do vital parts of a project at my home office, but my tools repository (Oracle), resides on the server park at the office. (Sidebar: The invention of home offices is perfect for employers: We, the employees, work both day and night, and on top of it, we love it: Crazy world). OK, back to business: While we may have inherited a sketch of an E-R model from the strategy phase of the project, now is the time to start asking the difficult questions. We will be probing that sketch, and stressing both the model and the business representatives (yes, I am now talking on behalf of the system analyst; since you are still reading this, most likely you are also one). The difference between an experienced and an un-experienced analyst makes the world of a difference here. While an un-experienced analyst will try to fit the business’ points of view into the E-R model, the experienced analyst will start to doubt those points of view, remembering her experience from two years back, in a similar situation. This phase in the project is namely not about making nice models; it is about making models that work, and making models that will work also if the business perspective changes, somewhere in time. And it will. It always does. Building flexibility into a model is really quite simple: Follow the rules for the five Normal Forms (do at least 3NF!), and you have already answered and solved a lot of vital questions, securing flexibility. If you want an in-depth study of the five Normal Forms, go to my eBooks page. The sooner we can ask, and collect answers, to questions about the business, the faster the analysis progress will be. Again, as one analyst to another, I must emphasize the importance of delivering results to your customer as fast as you can, without compromising quality; of course, it is the best way of making repetitive business too, as well as marketing. In the next keynotes, we will look at some classic analysis and ER modeling traps and errors.
Return from Analysis Progress to The Analysis Phase
|
Interview with What visitors say...
"I just stumbled accross your site looking for some normalization theory and I have to say it is fantastic.
Read more
Testimonials
I have been in the database field for 10+ years and I have never before come across such a useful site. Thank you for taking the time to put this site together." Mike, USA Free eBookSubscribe to my newsletter and get my ebook on Entity Relationship Modeling Principles as a free gift:![]() WorkshopOn rare occasions, I may perform a Database Design Workshop . Unfortunately, I am currently unable to, but maybe later...Influence meInfluence the content on this site: I want to know what database information you need the most: Participate in my Database Design Content investigation. I would appreciate it if you took the time... |
|
|
Theory & Practice
Database eBooks DB Normalization Analysis Phase Database Keys Software Tools DB Glossary Appl.Architecture Oracle DBA MySQL DBA SQL Server DBA Install Oracle Install SQL Server Proj.Management Oracle Constraint Programming Tips Bookstore Worst DB Designs Internet biz. Website Design Database Normalization eBook:![]() |
||
|
Copyright © 2004-2010 www.databasedesign-resource.com / Alf A. Pedersen
All rights reserved. All information contained on this website is for informational purposes only. *Disclaimer: www.databasedesign-resource.com does not warrant any company, product, service or any content contained herein. Return to top
The name Oracle is a trademark of Oracle Corporation. |
||