Re: Newbie needs to create a client/server system

shivesh_at_gmail.com wrote:

>This is not a large organization, 10-20 employees. There will be 1
>server. and probably at most 20 clients, but clients will be connected
>from 2 different locations, 1 from a foreign country, and 1 from the
>same place as the server.

For a system this size, I'm wondering why you need Oracle in the first place - it is overkill (and costo mucho). Take a look at Firebird or PostgreSQL for your db needs.

>Basically the database will contain all employees data, customer data,
>customer orders, perhaps even company's finance stuff. the system must
>be able to handle simultaneous client accesses and update data in an
>efficient and correct fashion. The usual DB stuff.

Yep.

>I need to write both the client application and server backend.
>Obviously, I think we are going to use Oracle for the whole system.
>This is my first time doing the complete database design, does anyone
>have any suggestions to any sites, books that would allow me to
>complete the system (from scratch)?

Again, ask yourself (and your client) "Why Oracle?"?

>Also, what should be the expected charge ($) to complete this whole
>system, in your opinion?

Take a look at a system callled Compiere - which is Open Source and may correspond to your needs.

There are many many CRM/ERP solutions commercially available out there - unless your needs are really strange, I would start by looking at what's commercially available and how customisable it is.

Your question is the equivalent of "how long is a piece of string?".

Paul...

-- 

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2, 

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.2.0;

When asking database related questions, please give other posters 
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.
 
Furthermore, As a courtesy to those who spend 
time analyzing and attempting to help, please 
do not top post.