Database Design

[MeadeR]

Here's a good reference for the levels of normalization:

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q100/1/39.ASP&NoWebContent=1

I once had a college professor (Mason from CSUH) say that if a
datastructure (database in today's terminology) is deisigned good the
program/code will write itself.......

I've always started a program with first getting a very good
understanding of the data, how it will be used, etc - then I would
develop the data schema, then the code (which would write itself).....

Agree??

Does anyone know of a good modeling tool that interacts with MS Access
(something like Erwin)?? or a tool that provides SQL proceduaral
coding like is available in MS SQL (T-SQL)?

Thanks
Meade

https://www.computersosnj.com

[Peter Russell]

Re: Database Design

MeadeR previously wrote:
[color=blue]
> or a tool that provides SQL proceduaral
> coding like is available in MS SQL (T-SQL)?[/color]


I thought it was going to write itself!(:-)

If only.

Regards

Peter Russell

[Koen]

Re: Database Design

MeadeR@Computer SOSNJ.com (MeadeR) wrote in
news:32684913.0 310270455.5d2cd aeb@posting.goo gle.com:
[color=blue]
>
> Does anyone know of a good modeling tool that interacts with MS Access
> (something like Erwin)?? or a tool that provides SQL proceduaral
> coding like is available in MS SQL (T-SQL)?
>[/color]

Try Microsoft Visio for Enterprise Architects.

Koen