Gustav Karner has done research while at Rational Software on estimating software construction costs based on use cases. The idea of weighting objects due to complexity and a useful set of factors to consider when determining complexity make this kind of interesting. His ideas are condensed at the following url.
www.bfpug.com.br/Artigos/UCP/Karner%20-%20Resource%20Estimation%20for%20Obje ctory%20Projects.doc or you can Google for Gustav Karner and check it out in HTML. Graham. >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Behalf Of Ted Roche >Sent: Monday, June 25, 2007 9:24 AM >To: [email protected] >Subject: Re: Bidding for jobs based upon the number of tables involved > > >On 6/24/07, MB Software Solutions <[EMAIL PROTECTED]> wrote: > >> Did any of you ever come up with a bid where the number tables in the >> database helped you form the idea of how many screens it'd take to >> support such a database? > >Yup! > >One table, $xxx/hour >Ten tables, $xxx/hour >Four hundred tables, $xxx/hour > >The formula works great! > >Seriously, simple data models may work with complex business >processes, and vice versa. > >It might be a couple of tables with a million rows of data or a bunch >of tables with a small number of rows. Tables can be a lookup table >with a PK, a short decode and a long decode, or they can have hundreds >of fields in them. I'm afraid simple metrics can't give great numbers. > >You want to know how many _screens_ exist based on how many >_tables_.... hmm, there's obviously a relationship. Every lookup table >has a CRUD screen. Event business process has a primary table; that >screen might have a dozen tabs and be more complex thatn some of your >worst nightmare apps. I'd say 10% more than 1:1, but the complexity of >the screens is a linear function for increasing lookup tables and a >geometric one for 'primary business entities.' > >-- >Ted Roche >Ted Roche & Associates, LLC >http://www.tedroche.com > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

