By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,045 Members | 1,743 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,045 IT Pros & Developers. It's quick & easy.

Relational Database Design Question

P: n/a
Where would be the best place to find some good resources that cover more
than just linking 2 -3 tables? I know how to link them and i get my data set
up right i think but then i am not sure about all of the inner joins
contained in my queries. The onlt examples i find are just simple single
bridge tables, which doesn't help me. I am goning to have about 30 tables
and the boss is getting antsy, i need to finish this so i can start writing
my stored procedures to implement in the application code.

Thanks,
Jeff
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
TC
The principle are much the same, whether you are talking about 3 tables or
30 ones.

Could you get anything useful from:
http://support.microsoft.com/support...es/Q100139.ASP ?

HTH,
TC
"Jeff Brown" <no******@thistime.com> wrote in message
news:w0*******************@twister.austin.rr.com.. .
Where would be the best place to find some good resources that cover more
than just linking 2 -3 tables? I know how to link them and i get my data set up right i think but then i am not sure about all of the inner joins
contained in my queries. The onlt examples i find are just simple single
bridge tables, which doesn't help me. I am goning to have about 30 tables
and the boss is getting antsy, i need to finish this so i can start writing my stored procedures to implement in the application code.

Nov 12 '05 #2

P: n/a
Database Design for Mere Mortals by Michael Hernandez?
Nov 12 '05 #3

P: n/a
I like

Access Database Design & Programming
Steve Roman
O'Reilly & Associates

but the largest example I found with a quick scan links only 4 tables. But, as
TC noted, the principles don't change when you add more tables, just the
complexity.

It has good explanations of both theory of databases (keys, normal forms, etc.)
and implementation in Access.

Paul Core
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.