Re: database design questions....

Hi,
Here's a page on the Database Answers Web Site that describes a simple approach to Database design :-

   http://www.databaseanswers.com/approach2db_design.htm

Here's a Page of links to over 40 simple Data Models,(Database designs), for you to browse looking for one to help you :-

   http://www.databaseanswers.com/data_models/index.htm

Finally, here's an example of PHP/MySQL in use on the same Web Site :- http://www.databaseanswers.com/data_models/hotels/chk_guest_list.php3

B.Dimple

Robert Young <rob_at_webteacher.com> wrote in message news:<3B587E6A.2EDCADA6_at_webteacher.com>...
> Check out Webdata Pro, http://webdatapro.com. It is an easy and powerful
> tool for building and administrating Web databases using MySQL.
>
> Rob Young
>
> Ed Peddycoart wrote:
>
> > I am working on a website which will make use of a MySQL database. I know
> > little if anything about the best way to design my db for efficiency, or
> > anything else for that matter. The information which I need to put in the
> > database will be contact/profile information on various people: Name,
> > Address, Phone, Email, Marital Status, Spouse, kids, things like that and a
> > field for comments submitted from the various people. Right now I have a
> > single table with a record for each item I want to store. Is that an
> > acceptable way?
> >
> > What are some websites which contain some basic information on DB design
> > etc. Things such as the best way to structure the db for effiency, searches,
> > what do all the terms mean (keys, index etc) etc.
> >
> > Ed
>
> --
> ------------------------------------------------
> Webteacher Software, LLC
> 'Webdata' - the first EASY database for the web
> 'JavaScript for the Total Non-Programmer'
> 'CGI for the Total Non-Programmer'
>
> http://www.webteacher.com
> mailto:sales_at_webteacher.com
> ------------------------------------------------
Received on Fri Aug 17 2001 - 16:44:00 CEST