[UPHPU] DB schema feedback/comments request

[Smith, Jeff]

Hello everyone, 
	I am pretty much a self taught kind of guy (i.e. I lack a formal
education) as such I missed out on a lot of things.  One of my weakest
areas is database design.  Is there a good resource on schema design?  I
particular what 3rd normal form is?  I have heard the term before but
have not had a chance until now to do further research.  Thanks.

Jeff Smith
Equal Opportunity Geek
Arcana Tower Enterprises


-----Original Message-----
From: uphpu-bounces at uphpu.org [mailto:uphpu-bounces at uphpu.org] On Behalf
Of Ray Hunter
Sent: Friday, May 26, 2006 1:09 AM
To: UPHPU.org
Subject: Re: [UPHPU] DB schema feedback/comments request

Brandon Stout wrote:
> I would like to request feedback on my addressbook database.  It's all
> self-designed.  Soon, I'll follow up with the various queries I run on
> the database, but until then, I have a data dictionary and graphical
> schema here:
> 
>
http://mscis.org/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE
_id=71
> 
> My future code samples (including the queries) will all fall under the
> same phpWebSite category, so they will all show up here (in addition
to
> this page):

I'm a big fan of normalization and 3rd normal form. I, personally, would
design
the tables to at least 3rd normal form.

--
ray

_______________________________________________

UPHPU mailing list
UPHPU at uphpu.org
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net