Re: Designing an Oracle site from scratch !

Check out "Oracle Design" by Ensor and Stevenson, published by O'Reilly and Associates. You can order directly from their web site www.ora.com.

Ian Stevenson (co-author of Oracle Design)

Atif Ahmad Khan <aak2_at_Ra.MsState.Edu> wrote in article <5ic917$jk3$1_at_NNTP.MsState.Edu>...
>
> I am helping a business re-design their entire database.
> The original one suffered from poor design that later
> became apparent and severe. I am hoping to not repeat
> history. I am wondering if there are any sample designs
> that I could look at. Any good books maybe ?
>
> I have noticed that most business have similar needs, they
> have a product to sell (products table), have cusotmers
> (customers table), have orders from these customers (orders
> table), products that are ordered (ordered_products table)...
> employee table... So someone must have outlined a dbms
> strategy, that most business can adapt with little or no
> modification. No ?
>
> I have seen some very basic implementations with details of
> these tables, but it would certainly be more interesting to
> see a more complexed design that covers more areas and have
> more details. If there really is nothing then I would have
> to publish my design on a web page to give newcomers a
> starting poin :)
>
>
> Atif Khan
> aak2_at_ra.msstate.edu
>
Received on Wed Apr 09 1997 - 00:00:00 CDT