Book on Table Design and Relationships

[Tom]

I have some fundamental understanding of relational table design and how to
join them properly.

However, I'd like to read up on some more sophisticated ways of table
design.

Does anyone know of an "mid-level" Access book that focuses on this subject
matter of "table relationships"?

Also, it would be great to have a chapter (or more) that provides generic
(or specific) examples for constructing the relationships.... maybe even
includes some entity relationship diagrams.

 

[Tim Ferguson]

Does anyone know of an "mid-level" Access book that focuses on this
subject matter of "table relationships"?

Can't beat the classics:-

CJ Date. An introduction to database systems. Volume 1
(PS does anybody have information about volumes after one?)

Fabian Pascal. Understanding Relational Databases.

And from our very own...
Rebecca Riordan. Designing Relational Databse Systems.

Almost anything that does _not_ have Access in the title (or Oracle, or SQL
Server, or any proprietary product) -- you want to learn about R design and
practice, not how to fiddle with a particular software interface, right? A
good trick is to try any university bookshop and see what titles are
stocked by the dozen: these will be on the course recommended lists and are
bound to be reliable.


Hope that helps


Tim F

 

[Tom]

Thanks Tim.

I just placed an orders for all 3 books on Amazon.com. I'm "hungry" for
the information.

Thanks for your feedback!

 

[Armen Stein]

I have some fundamental understanding of relational table design and how to
join them properly.

However, I'd like to read up on some more sophisticated ways of table
design.

Does anyone know of an "mid-level" Access book that focuses on this subject
matter of "table relationships"?

Also, it would be great to have a chapter (or more) that provides generic
(or specific) examples for constructing the relationships.... maybe even
includes some entity relationship diagrams.

Hi Tom,

I recommend Database Design for Mere Mortals, by Michael Hernandez, if
you haven't read it already.

It's a non-jargon approach to database design, taken from the point of
view of actually interviewing clients in real business scenarios.

--
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/ASIN/0764559036/jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com