OpenEuphoria

Re: For all 237...

• Posted by Daniel Berstein <daber at PAIR.COM> Nov 16, 1998
• 882 views

>Here's a new question for all - generally the first question
>asked by clients after "how are you today?"
>
>Given the requirements below, please estimate how long
>it would take to prepare a working system: Assume you
>are to be paid a flat fee, so taking longer won't increase
>your income any (and will take time from other more enjoyable
>pursuits:)
>
>Reguirements (from a recent job):
>Create a program that can maintain a database of 50,000 customers
>(providing for expansion to 100,000).
>
>The program must allow simultaneous use by at least 4 persons.
>The program must be able to locate a specific customer within
>5 seconds (1 is preferable) by searching on any one or more of
>the following fields:
>name, address, city, state, zip code, phone number, last purchase date
>
>Partial search strings are mandatory, i;e. SMI returns all  Smith, Smithe,
etc.
>902 returns all zips like 90210, 90211, etc.
>Smith and 902 returns all Smiths/Smithers...etc living in area code 902xx
>Case is ignored.
>
>Assume the client will purchase whatever support software you recommend.
>(Tell us what it is, and how long it will take to get a running system,
> saving fancy graphics and such for later, if you like.)


Specifications development & abstract data model:    2 days
Programming/debug cicle: 5/10 days (first almost-working pre-alpha after day
2)
Implementation (on clients network): 1 day
User's (boss) capacitacion: 0.5 days
User's feedback modifications and refinement: 2 months
Payment: god will say ;)

Implementation requirements:
Database server with RDBMS (InterBase suggested) with 5 concurrent user
licences
Windows NT 4 network preferred

A lower cost&performance system can be developed, but programming time
increases and potential data integrity corruption may occur. For bussiness
critical information just use a good&scalable DBMS!

BTW InterBase has a native JDBMS... it's very simple to port your local
database
system to the Internet.

Regards,
    Daniel   Berstein
    daber at pair.com