Relationship Databases

[srule_]

Does anyone have any good resources or know of any good books to learn about relationship databases?

And is this how they work: Table one has: Author info, Table Two has: Book info. I can make a relationship database that will related the author to all the books he wrote based on a "foreign ID" which will be a primary key in the other table?

[nikos101]

Yes thats exactly how it works. That way you can have more flexibility with your queries. I learned with this book. (http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764579509.html)
It tells me all I need to know to become quite good with MySQL and it is gentle!