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 _______________________________________________ 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.
