Re: Access as a RDBMS--why the multiple relationships? -
12-15-2007
, 09:48 AM
On Dec 14, 12:59 pm, raylopez99 <raylope... (AT) yahoo (DOT) com> wrote:
Thanks to all that replied and esp David Cressey, as I figured it
out: the relationship diagram in Microsoft Access is a query as well
as graphical data modeling aid. Further, it automatically sets the
foreign key constraints (if you check the right checkboxes) behind the
scenes, so you don't have to soil your hands with a SQL statement
(which I've done, that is build a table and set up constraints between
tables using just text commands and statements, but it's not something
I like doing, though if you're good at it I understand your reluctance
to trust a GUI).
And I should point out that Louis Davidson's book is not so bad for a
rank beginner in that it does have a chapter (I had overlooked) on
1NF, 2NF, 3NF and BCNF.
RL |