dbTalk Databases Forums  

Access as a RDBMS--why the multiple relationships?

comp.databases.theory comp.databases.theory


Discuss Access as a RDBMS--why the multiple relationships? in the comp.databases.theory forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
raylopez99
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.