Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Designing an Oracle site from scratch !

Designing an Oracle site from scratch !

From: Atif Ahmad Khan <aak2_at_Ra.MsState.Edu>
Date: 1997/04/08
Message-ID: <5ic917$jk3$1@NNTP.MsState.Edu>#1/1

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 Tue Apr 08 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US