Hi Friends,

As a DBA i have around 3 years of exp where in most of the work was only administering and managing Databases,But now a new responsibility has been given ie.designing databases.

Responsibility is taking requirements from clients and then converting them into database ,Thats fine i am comfurtable in designing databases.

The problem what iam facing is how to estimate what time it takes to design the database.If any one can advice me regarding this it will be very helpful. some suggestions like factors to keep in mind for time estimation.

Waiting for your kind reply
Regards
Pradeep

if you explain your problem in more clear that what
you want to design the database, what is time estimation factor
means ?

normally when database design, it include, tables, view, procedures,
diagram (relationship), users and user roles etc.
arrange it systematically that quick information will retrieve
from the database.

Hi Friend,
Thanks a lot for the Reply.

Image that a new project has come which is a inventory management system for a garment firm.Client has given the requirements.

So from our end we need to give them the Architecture Document and Time Estimation Document.

We assume that we have a very good functional knowledge team for Inventory Management.

now Project Manager asks you for time estimation to design the database for this Inventory Management System.How do you estimate the Time

Regards

Pradeep

I'm a bit reluctant to attempt to answer this question becuase I think the topic is so open-ended that any answer would be so full of caveats and 'it depends' as to make any specific responses useless. In another thread, we've been discussing some of these issues:

http://p2p.wrox.com/topic.asp?TOPIC_ID=10171

One poster in that thread asked me if I would respond here. I'll be happy to discuss the issue with you if you have specific questions, but I don't think you are going to find any magic formula that says that the time required to design an application database is x percent of some factor y.

I usually iterate my way to a solution, and simply fold in the database design time into overall applciation design which even then isn't an exact science...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com