Re: Database schema qurstion.

Raymond:

IMO, your questions is not concerning the best schema but an approach to naming standards and conventions, basic data architecture and database design. There are a number of books that cover database management methodologies and techniques in bookstores such as Borders and Barnes and Nobles. I have found books by Joe Celko to be very informative when it comes to this topic. You may also want to find some other non-vendor specific books related to database management system.

The structure of your schema is determined by your user (or developer) requirements for your project. Once your user requirements are determined and understood, you can design your database tables, primary keys and the like.

Kevin

"Raymond R Cassick" <ray.cassick_at_vtg.com> wrote in message news:8iqx5.2263$l35.48076_at_iad-read.news.verio.net...
> I am doing some research for a new product and am at the point where I am
> starting to look at the DB design.
>
> I need to store information (obviously) ranging from customer data to
> accounting data.
>
> The big question that I have is.... Has anyone done ant research on the
> best schema to use for specific instances? I mean, if I want to store
> customer data, how long does the name field have to be, how should the
> fields be grouped together in tables to make best use of indexes, etc...
>
> There HAS to have been some kind of study done with this in mind
 somewhere.
> I just can't find it.
>
>
Received on Wed Sep 20 2000 - 00:23:38 CEST